MySQL basics

From LinuxReviews
Jump to navigationJump to search

Dump a database[edit]

mysqldump -uuseranme -puserpassword databasename > databasename.sql

Restore a database[edit]

mysql -uusername -puserpassword databasename < databasename.sql