MySQL basics

From LinuxReviews
Jump to navigationJump to search

Dump a database

mysqldump -uuseranme -puserpassword databasename > databasename.sql

Restore a database

mysql -uusername -puserpassword databasename < databasename.sql