The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL databases not being backed up!

Discussion in 'General Discussion' started by thurmma, Dec 31, 2008.

  1. thurmma

    thurmma Member

    Joined:
    Nov 3, 2003
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    After upgrading to the latest WHM/Cpanel package our MySQL databases are NOT being backed up! This is a MAJOR issue for us. I have checked all of the settings in WHM and the system is set to backup accounts and full Mysql directory, but when I restore a site, the databases are NOT there!

    Any and all help will be greatly appreciated. I was wondering why our backups were ending 2 hours earlier than they used to be.
     
  2. dragon2611

    dragon2611 Well-Known Member

    Joined:
    Nov 30, 2003
    Messages:
    126
    Likes Received:
    0
    Trophy Points:
    16
    Same problem here :eek:
     
  3. dragon2611

    dragon2611 Well-Known Member

    Joined:
    Nov 30, 2003
    Messages:
    126
    Likes Received:
    0
    Trophy Points:
    16
    Grabbing PostgreSQL privileges...Done
    Leaving timeout safety mode
    Copying mailman lists....Done
    Copying mailman archives....Done
    Copying homedir....Done
    Entering timeout safety mode
    Grabbing mysql dbs........mysqldump: unknown option '--mysql]'
    mysqldump: unknown option '--mysql]'

    Local mysql tools are version 4.x and remote mysql is 5.x. Unable to backup stored procedures.
    horde.turba_objects horde.turba_objects: mysqldump: unknown option '--mysql]'
    horde.turba_objects OK
    horde.horde_prefs horde.horde_prefs: mysqldump: unknown option '--mysql]'
    horde.horde_prefs OK
    horde.kronolith_events horde.kronolith_events: mysqldump: unknown option '--mysql]'
    horde.kronolith_events OK
    horde.kronolith_storage horde.kronolith_storage: mysqldump: unknown option '--mysql]'
    horde.kronolith_storage OK
    horde.mnemo_memos horde.mnemo_memos: mysqldump: unknown option '--mysql]'
    horde.mnemo_memos OK
    horde.nag_tasks horde.nag_tasks: mysqldump: unknown option '--mysql]'
    horde.nag_tasks OK
    ...Done
    Grabbing mysql privs...Done
    Copying cpuser file.......Done
    Copying crontab file.......Done
    Copying quota info.......Done
    Storing Subdomains....
    Done
    Storing Parked Domains....
    Done
    Storing Addon Domains....
    Done
    Storing ssl domain......Done
    Copying password.......Done
    Copying shell.......Done



    Also if i run mysqldump i get the following message

    root@wyvern [/home/server]# mysqldump
    mysqldump: unknown option '--mysql]'
    root@wyvern [/home/server]#

    I never even specificed a --mysql arguement :confused:

    Box is running centos5.2 X64


    EDIT:

    In my case it was traced to a syntax error in my /etc/my.cnf file
     
    #3 dragon2611, Jan 4, 2009
    Last edited: Jan 4, 2009
  4. Freezer

    Freezer Well-Known Member

    Joined:
    Jun 13, 2005
    Messages:
    120
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Den Haag
    Fill in a support ticket?
     
  5. dragon2611

    dragon2611 Well-Known Member

    Joined:
    Nov 30, 2003
    Messages:
    126
    Likes Received:
    0
    Trophy Points:
    16
    Seconded, I did this and they tracked it down to a typo in my /etc/my.cnf file :eek:
     
  6. jols

    jols Well-Known Member

    Joined:
    Mar 13, 2004
    Messages:
    1,111
    Likes Received:
    2
    Trophy Points:
    38
    I'm shocked! Did this ever get fixed, or do we have hundreds of individual account WordPress, Joomla etc. backups in your server backups that can never be restored in case we need to do a full server restore?

    Anyone?
     
  7. dragon2611

    dragon2611 Well-Known Member

    Joined:
    Nov 30, 2003
    Messages:
    126
    Likes Received:
    0
    Trophy Points:
    16
    This was fixed a long time ago, and the issue in my peticullar case was a typo id made on a config change :eek:
     
  8. jols

    jols Well-Known Member

    Joined:
    Mar 13, 2004
    Messages:
    1,111
    Likes Received:
    2
    Trophy Points:
    38
    That's a relief. Thanks for your response.
     
  9. minzhong

    minzhong Active Member

    Joined:
    Jan 9, 2005
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    I notice the mysql databases are being backup as folders. how can we configure cpbackup to backup the databases as .sql ?
     
Loading...

Share This Page