MySQL Forums
Forum List  »  InnoDB

MySQL Dump with ERROR 1146 (42S02)
Posted by: Mark Kwok
Date: February 04, 2013 08:02PM

Hi, I am using "5.5.23-log" and have error when using the "mysqldump" in recently day. Following is my command

command:
mysqldump CENTRAL_DB --tables SYS_SETTING -uroot -p --opt|mysql SHOP_DB -uroot -p -h XXX.XXX.XXX.XXX

Error message:
ERROR 1146 (42S02) at line 60: Table 'CENTRAL_DB.SYS_SETTING' doesn't exist


I am able to "SELECT" all the data in "CENTRAL_DB.SYS_SETTING" and I can run the same command a month ago. Also, I have no problem to run
"mysqldump -uroot -p --skip-triggers --compact --no-create-info CENTRAL_DB SYS_SETTING > /DUMP_SYS_SETTING.sql"

Any idea to fix this case?
Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Dump with ERROR 1146 (42S02)
3885
February 04, 2013 08:02PM
1205
February 22, 2013 10:50AM


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.