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

Retrieved from "https://linuxreviews.org/w/index.php?title=MySQL_basics&oldid=4228"