Database backup question.

New Member Joined: Sep 25, 2003 Posts: 21

Hello, hm about 2 days ago I noticed that the usual backup that I make everday recieves an error now.

Basically a while ago I made a simple shell script to make backups. here it is:

echo "Enter password:"
read password
mysqladmin -h localhost -u root flush-tables --password=$password
mysqldump -h localhost -u root --add-drop-table --extended-insert nuke > nuke.sql.`date +"%m%d%y"` --password=$password

---------------------------------------------------

Now if I run the script i recieve the following:

mysqldump: Can't get CREATE TABLE for table 'nuke_msanalysis_online' (Can't open file: 'nuke_msanalysis_online.MYI'. (errno: 145))
---------------------------------------------------------------------------------

that file is there, and the permissions seem to be right just like for the other files. But umm will this error be a problem if I want to in the future use a backup?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

That looks like the table needs repairing. Run a REPAIR TABLE either using phpMyAdmin or through MySQL command line.

Posted: Sun Oct 19, 2003 3:31 pm

I am looking for that option with phpmysqladmin umm not finding it.. what would the command be to do it from the command line?

Posted: Sun Oct 19, 2003 4:07 pm

In phpMyAdmin pull up the listing of all tables by selecting your database. Then select the table to be acted upon. Then at the bottom of the list, there should be a drop down box with several options of which repair should be one of them.

Posted: Sun Oct 19, 2003 6:34 pm

Thanks alot raven that worked, sorry I really didn't see it at the bottom.