MySQL Administrator (1.2.5 rc) Backup Problems

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
MDC
Forum Newbie
Posts: 1
Joined: Sat Nov 25, 2006 2:50 pm

MySQL Administrator (1.2.5 rc) Backup Problems

Post by MDC »

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:
"The command FLUSH TABLES WITH READ LOCK cannot be executed."
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:
An error occured while executing the backup.

Error while analyzing an SQL statement
(and yes the grammer errors are really included in the message)

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?
Post Reply