MySQL Forums
Forum List  »  Newbie

MySQL Dump with ERROR 1146 (42S02)
Posted by: Mark Kwok
Date: February 06, 2013 02:57AM

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
Written By
Posted
MySQL Dump with ERROR 1146 (42S02)
February 06, 2013 02:57AM


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.