[snip]
I am doing backup for tables using Mysqldump. But while doing the restore I
am not able to do that using the same Mysqldump. Could you please help me in
that.
[/snip]

mysqldump is not intended to be used for the restore.

You need to run the following:

mysql -D dbname < mysqldumpfile

You may have to specify a user and password as well, depending on your
setup.

---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa


-----Original Message-----
Hi,

       I am doing backup for tables using Mysqldump. But while doing the
restore I am not able to do that using the same Mysqldump. Could you please
help me in that.




For backup : using   Mysqldump -databases <db_name> ---tables table1
table2 > dump.dmp

For restore : used  Mysqldump -databases <db_name> < dump.dmp




In the above, I am not able to restore the data.




Please help us for a good solution.




Thanks,

Narasimha





Confidentiality Notice


The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain confidential or privileged information. If you are not the intended
recipient, please notify the sender at Wipro or [EMAIL PROTECTED]
immediately and destroy all copies of this message and any attachments.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to