Skip navigation links

MySQL Forums :: Quality Assurance :: Taking MySql DB dump for selected tables.


Advanced Search

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

Hi,

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


Subject Views Written By Posted
Taking MySql DB dump for selected tables. 1133 Anto Vijay K J 07/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.