MySQL Forums
Forum List  »  Backup

mysqldump file not found error
Posted by: Thomas Feldkamp
Date: August 12, 2005 03:59AM


I want to backup the database to upgrade from 4.0.x to 4.1.x, becuase we use the german charset and there was no really succesful way to update the data to the new charset.
So I'd read that if I make a backup and create the tables new, the data is written in the right way in the database.

Now I've a problem to backup the databases.
I use the following command:

mysqldump --all-tables --add-drop-table -uroot -ppw > backup.sql

Everytime I use this command, There is an error
mysqldump: Got error: 1017: Can't find file: '.\cs\relations.frm' (errno: 24) when using LOCK TABLES

The file which couldn't bben found does exist in the data directory and is read-/writeable.

When I look in he backup.sql file, it looks like it is the first table which will be dumped.

I tried this command on an other computer, too. But the error occures there too whether the table which wasn't found is a different.

Who can help?

Thanks in rewards

Options: ReplyQuote

Written By
mysqldump file not found error
August 12, 2005 03:59AM

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.