Backup

ngohieutp · 08-17-2009, 10:54 PM

Hi. I want to backup my mysql databases. And I found this command to do it. But I received an error.

Code:

# mysqldump -u usernam -p --no-data database_name > \backups\structure.sql
Enter password: 
mysqldump: Got error: 1146: Table 'table_name' doesn't exist when using LOCK TABLES
#

Plese tell me why this happens ? How to resolve it ?
Thank you.

chrism01 · 08-17-2009, 10:58 PM

Sounds like a DB corruption. Login to that particular db/schema and use 'show tables' then check if they all exist, specifically the one mentioned in the error msg.

ngohieutp · 08-17-2009, 11:05 PM

I don't know, this is what I get :

Quote:

mysql> use vtv;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-------------------------------+
| Tables_in_vtv |
+-------------------------------+
...
| cdr_1900561293_thongke |
| cdr_1900561293_thongke_200902 |
| cdr_1900561293_thongke_200903 |
| cdr_1900561293_thongke_200904 |

...

It means we have cdr_19001773_thongke_200902 table in vtv database.
Now :

Quote:

mysql> select * from cdr_1900561293_thongke_200902;
ERROR 1146 (42S02): Table 'vtv.cdr_1900561293_thongke_200902' doesn't exist
mysql>

And when I use backup command, It shows error like my question.