I am new to MySQL and I am in need of the script which is taking backup of multiple tables from the multiple databases in single file in MySQL?
To dump only specific tables from a database, name them on the command line following the database name:
mysqldump my_database table1 table3 table5 > dump.sql
To dump only specific tables from multiple database, use mysqldump again, but append to the end of the previously created file:
mysqldump my_database2 table1 table3 table5 >> dump.sql Note the