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
Subject
Written By
Posted
MySQL Dump with ERROR 1146 (42S02)
February 06, 2013 02:57AM
February 07, 2013 07:49PM
February 14, 2013 03:18AM
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.