MySQL databases not being backed up!

thurmma

Member
Nov 3, 2003
11
0
151
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.
 

dragon2611

Well-Known Member
Nov 30, 2003
124
0
166
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

[email protected] [/home/server]# mysqldump
mysqldump: unknown option '--mysql]'
[email protected] [/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
 
Last edited:

jols

Well-Known Member
Mar 13, 2004
1,107
3
168
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?
 

dragon2611

Well-Known Member
Nov 30, 2003
124
0
166
This was fixed a long time ago, and the issue in my peticullar case was a typo id made on a config change :eek:
 

minzhong

Active Member
Jan 9, 2005
31
0
156
I notice the mysql databases are being backup as folders. how can we configure cpbackup to backup the databases as .sql ?