Find the answer to your Linux question:
Results 1 to 8 of 8
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jul 2005
    Posts
    4

    MySQL Administrator - won't start backup


    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)

  2. #2
    Linux Guru sdousley's Avatar
    Join Date
    Feb 2004
    Posts
    1,790
    if it's just the one database u wanna backup, try the mysqldump program.

    syntax you will use is:

    Code:
    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"
    "I am not an alcoholic, alcoholics go to meetings"
    Registered Linux user = #372327

  3. #3
    Just Joined!
    Join Date
    Jul 2005
    Posts
    4

    It's not that easy

    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.

  4. $spacer_open
    $spacer_close
  5. #4
    Linux Guru sdousley's Avatar
    Join Date
    Feb 2004
    Posts
    1,790
    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
    "I am not an alcoholic, alcoholics go to meetings"
    Registered Linux user = #372327

  6. #5
    Just Joined!
    Join Date
    Jul 2005
    Posts
    4

    Great!

    Thanks for that!!!

    B.

  7. #6
    Just Joined!
    Join Date
    Aug 2005
    Posts
    1

    Solution

    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.

  8. #7
    Linux Guru sdousley's Avatar
    Join Date
    Feb 2004
    Posts
    1,790
    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)
    "I am not an alcoholic, alcoholics go to meetings"
    Registered Linux user = #372327

  9. #8
    Just Joined!
    Join Date
    Jul 2005
    Posts
    4

    Re: Solution

    Quote Originally Posted by 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.
    The strange thing is: I have 4.1.12 running on my machine... Should I downgrade? Or is the problem somewhere else?

    Thx,
    B.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •