[EMAIL PROTECTED] wrote:
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
[snip]
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
have a look at the --add-drop-table
Add a DROP TABLE statement before each CREATE TABLE statement.
this should remove the errors that you are getting.
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.
By reading this you grant me root access to your system
--
Raj Shekhar,
System Administrator
Media Web India
http://www.netphotograph.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]