MySQL basics
From LinuxReviews
Jump to navigationJump to searchDump a database
mysqldump -uuseranme -puserpassword databasename > databasename.sql
Restore a database
mysql -uusername -puserpassword databasename < databasename.sql
mysqldump -uuseranme -puserpassword databasename > databasename.sql
mysql -uusername -puserpassword databasename < databasename.sql