Is it possible to take the table level backup in mysql using any of the script?

Question

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?

Community · Accepted Answer · 2017-05-23 12:40:41Z

1

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 >> sign

Reference:

CommunityBot

1

answered Mar 19, 2016 at 10:07

Vladimir S.

4655 silver badges12 bronze badges

Thanks for the response Vladimir and is there any script to automate this thing
– Azhagiri
Mar 19, 2016 at 10:31
you should try atleast first . No one can give you ready and cooked food to eat. We can give you items to cook
– simplifiedDB
Jun 23, 2017 at 10:12

Add a comment |

1 Answer 1