MySQL - Dump and Reload
mysqldump --password --user=root world > world.sql
create database world;
mysql -u root -p world < world.sql
mysqldump -h myhost -u root -pmypass dbname > dbname_backup.sql
To restore:
mysqladmin -h myhost -u root -pmypass create dbname;
mysql -h myhost -u root -pmypass dbname < dbname.sql
To dump schema only:
mysqldump -u someuser -p -d --routines mydatabase > mydatabase.sql
mysqldump -u someuser -p --no-data --routines mydatabase > mydatabase.sql
page revision: 8, last edited: 01 Apr 2017 05:48
