Monday, August 2, 2010

Dump multiple databases from console - mysqldump

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: