MySQL Administrator - won't start backup

[bdeprez]

I try to backup my database with MySQL Adminstrator but when hitting 'Start Backup' it shows a pop-up saying 'Error during backup - Cannot set ANSI quotes'...

Anyone have a clue what happens?

Thanks in advance,
Bernard (the newbie)

[sdousley]

if it's just the one database u wanna backup, try the mysqldump program.

syntax you will use is:

mysqldump -u username -p database > database.sql

obviously changing "database" to the relevent database name and "username" to a mysql username.

This will output the SQL used to create the database "database" into the file "database.sql"

[bdeprez]

Hi sdousley,

thanks for that, but I have 4 databases I need to backup and I used the Mysql administrator before (when my server was still on Win)...

The good thing is also that I can have the database scheduled via this application too...

If anyone has an idea what the origin of this problem could be, then I would be very gratefull for any help!

Thanks,
Bernard.

[sdousley]

ah, right, ok then....

Not too sure.

I will look into this.

Looks like a useful application. I'll install it tonight, and get back to you tomorrow on it

[bdeprez]

Thanks for that!!!

B.

[hasigo]

Hi,

you need to update your MySQl-Server. I had the same problem with Version 4.0.1. After updating to Version 4.0.18 no more errors occurred.

[sdousley]

yeh, i'm on 4.0.25-r2, and mysql administrator worked fine when i installed it. (Sorry for the delay, couldn't find this post to reply again)

[bdeprez]

Hi,

you need to update your MySQl-Server. I had the same problem with Version 4.0.1. After updating to Version 4.0.18 no more errors occurred.

The strange thing is: I have 4.1.12 running on my machine... Should I downgrade? Or is the problem somewhere else?

Thx,
B.