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

[Related posts]

How to Dump All Databases in MySQL Server
To damp all MySQL databases, use the –all-databases option. mysqldump -u username –p password –all-databases > dump.sql...
How to Backup Only Data of a MySQL Database
For exporting MySQL database’s only the data, use –no-create-info option. The dump will not re-create the database, tables, fields, and other structures when importing. mysqldump...
How to Backup MySQL Databases
There are two methods to backup MySQL, first method is by copying all files such have extentions *.frm, *.MYD, and *.MYI, and second is by...
File Server With Samba and FTP in FreeBSD
This manual describes how to create file server, where users from can access their files with samba client and FTP server, (from windows too). In...