Hi,
Thank you for your reply. If I have the create table info in my
dump file, while doing the restore using mysql dbname < dump.dmp, I am
getting errors like
mysql -uMNMSDBA -pMNMSDBA -f mnms <
c:\progra~1\mitel\opsman~1\temp\almhist.dmp
ERROR 1050 at line 11: Table 'alarm' already exists
ERROR 1050 at line 40: Table 'alarm_category' already exists
ERROR 1050 at line 70: Table 'alarm_report' already exists
ERROR 1062 at line 91: Duplicate entry '1' for key 1
ERROR 1062 at line 92: Duplicate entry '4' for key 1
ERROR 1062 at line 93: Duplicate entry '5' for key 1
ERROR 1062 at line 94: Duplicate entry '8' for key 1
ERROR 1062 at line 95: Duplicate entry '10' for key 1
ERROR 1062 at line 96: Duplicate entry '11' for key 1
ERROR 1062 at line 97: Duplicate entry '13' for key 1
ERROR 1062 at line 98: Duplicate entry '15' for key 1
ERROR 1062 at line 99: Duplicate entry '16' for key 1
ERROR 1062 at line 100: Duplicate entry '17' for key 1
ERROR 1050 at line 108: Table 'alarm_report_category' already exists
ERROR 1050 at line 137: Table 'alarminfo' already exists
ERROR 1062 at line 155: Duplicate entry '56' for key 1
ERROR 1062 at line 156: Duplicate entry '57' for key 1
ERROR 1062 at line 157: Duplicate entry '58' for key 1
ERROR 1062 at line 158: Duplicate entry '59' for key 1
ERROR 1062 at line 159: Duplicate entry '75' for key 1
ERROR 1062 at line 160: Duplicate entry '76' for key 1
ERROR 1062 at line 161: Duplicate entry '77' for key 1
Please advise me, how to suppress the above error messages.
While taking backup used
mysqldump -uMNMSDBA -pMNMSDBA --databases mnms --add-locks
--disable-keys -f --tables ALARM ALARM_CATEGORY ALARM_REPORT
ALARM_REPORT_CATEGORY ALARMINFO >
c:\progra~1\mitel\opsman~1\temp\almhist.dmp
Please help me in this.
Thanks,
Narasimha
-----Original Message-----
From: Tom Crimmins [mailto:[EMAIL PROTECTED]
Sent: Monday, January 03, 2005 10:55 AM
To: Lakshmi NarasimhaRao (WT01 - TELECOM SOLUTIONS)
Cc: mysql@lists.mysql.com
Subject: RE: backup/restore
[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]
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]
