[How To] Dump Several MySQL Databases Into Text File

Use –databases option for exporting several databases.

mysqldump -u username -ppassword –databases db_name1 [db_name2 ...] >dump.sql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.