Problems restoring mysql database backups

ana45

I created the 'info' database using phpMyAdmin.

My task is to restore database backups.

Today, I even tried restoring the database backup named 'cyberview_db_2809_2009-10-27_17h30m.Tuesday.sql' using phpMyAdmin into 'info'.

[ I have been using the automysqlbackup.sh.2.5 to create backups daily using the crontab.]

But the error returned was :

-- Server version 5.0.77
/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
MySQL said:
#1065 - Query was empty[/QUOTE]
But when I create another database, and restore using the original database which is 'cyberview_db_2809.sql' , I don't have such a problem. So I assume that the problem is in the database backups itself.

Is it because the backup script is not good enough or what is causing the problem with the backups? Are the database backups corrupted?

Weedpacket

I've had phpMyAdmin choke on largish dumps in the past, both due to timing out and character set errors. It may not be the same issue as yours, but perhaps using MySQL's command-line utilities to restore the backup will give you more success.

ana45

Well actually I even tried restoring from the command line several times but failed to do so. The only file that got created in the database was db.opt. Nothing else.

Is there other ways you can suggest to solve this problem? I am really running out of ideas.

Tqs.

Bjom

I use the mysql administrator (from the mysql website), which is much more comfortable than both the options you used, but it hardly will solve your issues.

Have a look at the sql file. Any errors?

What you can do is to create a stored procedure in your DB and copy/paste all the code from inside the sql file into it, then run the sp.

Bjom