MySQL basics

From LinuxReviews
Jump to navigationJump to search

Dump a database[edit | edit source]

mysqldump -uuseranme -puserpassword databasename > databasename.sql

Restore a database[edit | edit source]

mysql -uusername -puserpassword databasename < databasename.sql