mysqldump: Couldn't find table: ";"是怎么回事？

Question

"C:\Users\adminstrator>mysqldump -u root -p yuanbiji >g:/www/yuanbiji11.sql;
Enter password: *******
mysqldump: Couldn't find table: ";"

C:\Users\adminstrator>mysqldump -uroot -pwh36524 yuanbiji > g:/yuanbiji11.sql;
Warning: Using a password on the command line interface can be insecure.
mysqldump: Couldn't find table: ";"
"

Answer 1

Can not be done

Answer 2

1. The database file is damaged, use the repair command;
2. Look at the files in the yuanbiji directory in your mysql data directory. There are at least two files for each table.
3. According to personal experience, power outage or abnormal shutdown or abnormal shutdown of services may be caused by this problem.
4. According to personal experience, this problem may also occur after modifying the configuration file. Please restore the previous configuration file, such as modifying the encoding.
5. Recover data via binary files in mysql, see instructions.

Gook luck!

Answer 3

I encountered the same problem, and finally found that it can be solved by removing the ";" after the mysqldump command