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.

For taking Multiple tables dump:

-> mysqldump -u username -p -P portno --socket dbname tab1 tab2 tab3 .. > dumpfile;

Hi HariSankar,

thanks for your reply.

I used the commad given by you, But i got the following error msg.

./mysqldump: Got error: 1146: Table 'db.tab1' doesn't exist when doing LOCK TABLES

Then I used '--skip-lock-tables' option in my command.After using this , It is creating dump file but the dump file size is always being as 1053kb.

Please give some idea about it.

Hi Vijay,

In my query tab1 tab2 means your table names which you want to take dump..

Just replace the dbname with your database name and tab1 tab2 etc with your table names....

Hi Hari,

I used the same . In the above error ,db is my DB name and tab1 is one of the table name in my db. I didnt want to mention my db name and table name , that's why mentioned like db.tab1 .

> /mysqldump: Got error: 1146: Table 'db.tab1' doesn't exist when doing LOCK TABLES
It means that table is not exist in your datbase check that you provided the correct name.

.> It is creating dump file but the dump file size is always being as 1053kb.

You are worrying about size of the dumpfile.. I can't understand here..

Do you feel the dump is not taken properly?

If you want to check the dump just create the sample database and import the dump into that and check the table data....

Yeah Hari,

I think it is not taking db dump properly. I tried importing the dump into the DB but it is not importing the data in the tables.

Hi Vijay,

Post your dump and import statement...

Hi Hari,

That db is being used in my client side . So i wont be able to share it .

I Used following command for importing

mysql --socket=<Socket Name> -uocm -pocm -e "source <DUMP file name>" <db name>

Hi Vijay,

Use this command to import dump,

mysql -u username -p -P port --socket socketfile dbname < dump.sql

You can use this also,

mysql -uocm -pocm --socket=<Socket Name> <db name> -e "source <DUMP file name>"

hi Hari,

i tried the both commands , but still it is not importing the data.

I guess, dumpfile is not having data.Taking db dump is itself not proper.

Hi,

Is it showing any error message while importing data?

Check whether the tables are created or not in database and open the dump file using vi editor and see whether it contains insert statement or not...

Hari,

Only below stuff is there in my dump file

Hi Vijay,

Check the user has a sufficient privileges for taking dump.
Try to take dump again using root user and ensure that the tables are exist in database.
If mysql dump showing any error message post it here.

ex:
mysqldump -u root -p dbname tab1 tab2 etc > dump.sql