MySQL Administrator (1.2.5 rc) Backup Problems
Posted: Sat Nov 25, 2006 3:07 pm
I am having some problems using MySQL Administrator(1.2.5 rc) to backup my database, and my web host doesnt seem to know what's going on. I hope someone here can help me.
I am trying to backup a vBulletin(3.6.4) database. Originally I tried to use the "Lock All Tables" backup style as it is recommended for MyISAM type tables. When I execute that I get the following error:
My host is running MySQL 4.0 and they state they have no problem backing up my database with MySQL Administrator(1.0.18).
Can someone please inform me are there any known issues, or am I doing something wrong, or is this something on my hosts end that will not allow me to backup my database?
I am trying to backup a vBulletin(3.6.4) database. Originally I tried to use the "Lock All Tables" backup style as it is recommended for MyISAM type tables. When I execute that I get the following error:
My host told me I needed to use normal backup. I could not use Lock All Tables style backups. I tried running a normal backup and I get the following error message:"The command FLUSH TABLES WITH READ LOCK cannot be executed."
(and yes the grammer errors are really included in the message)An error occured while executing the backup.
Error while analyzing an SQL statement
My host is running MySQL 4.0 and they state they have no problem backing up my database with MySQL Administrator(1.0.18).
Can someone please inform me are there any known issues, or am I doing something wrong, or is this something on my hosts end that will not allow me to backup my database?