MySQL Forums
Forum List  »  Quality Assurance

Taking MySql DB dump for selected tables.
Posted by: Anto Vijay K J
Date: July 04, 2011 05:34AM


My requirement is taking MySql DB dump for particular tables in a DB using mysqldump script.My DB is running on Solaris server.

I tried following command to take db dump for single table,

mysqldump --socket=<Socket name> -u<UserName> -p<Password> <DB Name> --skip-lock-tables <TableName1> >> Test.dump

It is creating Test.dump file. But I am not sure , whether this is the correct way of taking db dump for single table.

And Please guide me to take db dump of multiple tables using single command.

Options: ReplyQuote

Written By
Taking MySql DB dump for selected tables.
July 04, 2011 05:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.