mysqldump -u root -p --create-options --databases dbname1 dbname2 > dbs.sql
Use
--create-options
to have “create database” statements. Do not use this option if databases already exists.Simply dump all databases:
mysqldump -u root -p --create-options -A > dbs.sql
Import them:
mysql -u root -p < dbs.sql
No comments:
Post a Comment