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
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.