Zion Ahead

Well-Known Member
Nov 10, 2006
347
0
166
Getting these errors when using multiple transfer via whm (cpanel to cpanel server)

ERROR: Failed to dump one or more database

I tried below to no avail, on both servers (source/destination)

/usr/local/cpanel/bin/update-horde --force
/scripts/fullhordereset

Trace output from whm transfer:

[email protected]'s password: ==sshcontroloutput==
pkgacct started.
pkgacct version 10 - user : client - tarball: 1 - target mysql : 5.5 - split: 1 - incremental: 0 - homedir: 0 - archive version: 3 - running with uid 0
pkgacct working dir : /home/cpmove-client
Copying Reseller Config...
Copying Reseller Packages and Features ...
Done
Copying Suspension Info (if needed)...Done
Copying SSL Certificates, CSRS, and Keys...Done
Copying Domain Keys....Done
Copying Counter Data....Done
Copying Bandwidth Data......client-imap-rate.rrd....clientdomain.net-all-rate.rrd....client-smtp-rate.rrd....client-http-peak.rrd....client-pop3-rate.rrd....clientdomain.net-http-peak.rrd....client-imap-peak.rrd....clientdomain.net....clientdomain.net-all-peak.rrd....client-ftp-peak.rrd....client-ftp-rate.rrd....client-all-rate.rrd....clientdomain.net-http-rate.rrd....client....client-pop3-peak.rrd....client-smtp-peak.rrd....client-http-rate.rrd....client-all-peak.rrd..Done
Copying Dns Zones.......clientdomain.net...Done
Copying Mail files....Done
Copying frontpage files....Done
Copying proftpd file....Done
Copying www logs.......log file sizes [3486 byte(s)]......clientdomain.net......clientdomain.net-bytes_log...Done
Copy userdata...Done
Copy custom virtualhost templates...Done
Copying mailman lists and archives....
Done
.........
Determining mysql dbs...DBD::mysql::db selectall_arrayref failed: Unknown storage engine 'InnoDB' at /usr/local/cpanel/bin/cpmysqladmin line 195.
DBD::mysql::db selectall_arrayref failed: Unknown storage engine 'InnoDB' at /usr/local/cpanel/bin/cpmysqladmin line 195.
...mysql version: 5.5......mysqldump version: 5.5...Saving mysql privs...Done
ERROR 1286 (42000) at line 1: Unknown storage engine 'InnoDB'
...Done

Skipping Logaholic Backup. Logaholic is globally disabled on this system.

Storing mysql dbs............
horde.turba_objectshorde.turba_objects OK
(1101 bytes) horde.turba_shareshorde.turba_shares OK
(1062 bytes) horde.horde_prefshorde.horde_prefs OK
(2996 bytes) horde.kronolith_shareshorde.kronolith_shares OK
(1119 bytes) horde.kronolith_storagehorde.kronolith_storage OK
(1119 bytes) horde.mnemo_memoshorde.mnemo_memos OK
(1097 bytes) horde.nag_taskshorde.nag_tasks OK
(1089 bytes)
ERROR: Failed to dump one or more databases
 

clook

Well-Known Member
PartnerNOC
Jun 9, 2002
62
1
308
Preston, UK
On the server you're moving the account from, generate a backup of the account using "/scripts/pkgacct USERNAME"

This will fail aswell but the output will be more detailed and give you more to go on. In the issue I have just dealt with the pkgacct showed errors relating to unknown variables when running mysqldump and when the lines were commented out in /etc/my.cnf (and mysql restarted) the pkgacct and also the server to server migration worked fine.

In case it's of use, the lines in my.cnf that I commented out after seeing the script complain about them were:

default-storage-engine=MyISAM
innodb_file_per_table=1