ERROR: Failed to dump one or more databases

Spetsnaz

Well-Known Member
Jun 25, 2011
78
0
56
cPanel Access Level
Website Owner
Hello I got a problem now.
I have exactly installed everything from my old VPS to my new one.
Still trying to transfer all the accounts or 1 account I get this
ERROR: Failed to dump one or more databases
 

Spetsnaz

Well-Known Member
Jun 25, 2011
78
0
56
cPanel Access Level
Website Owner
cpanel to cpanel problems

This is what I get always trying to transfer from my cpanel to my other cpanel



Code:
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.
ERROR 1286 (42000) at line 1: Unknown storage engine 'InnoDB'

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

Storing mysql dbs............
horde.turba_objectshorde.turba_objects                                OK
(775 bytes) horde.turba_shareshorde.turba_shares                                 OK
(775 bytes) horde.horde_prefshorde.horde_prefs                                  OK
(775 bytes) horde.kronolith_shareshorde.kronolith_shares                             OK
(775 bytes) horde.kronolith_storagehorde.kronolith_storage                            OK
(775 bytes) horde.mnemo_memoshorde.mnemo_memos                                  OK
(775 bytes) horde.nag_taskshorde.nag_tasks                                    OK
(775 bytes)
 

Spetsnaz

Well-Known Member
Jun 25, 2011
78
0
56
cPanel Access Level
Website Owner
The best way to fix this issue from cPanel transfer to another cPanel and you are getting
"ERROR: Failed to dump one or more databases" from transfering.

1)Go to WHM -> Copy Multiple Accounts/Packages From Another Server
When you see the option of what accounts to transfer, make sure you tick on all "skip database"
All the account's and their info will be transferred but not the MySQL usernames.

Go back to the old server and go to the MySQL directory and transfer it to the MySQL directory of the new server.
It is located in /var/lib/MySQL.

You will now have to perform a long time taking task.

Go into SSH and type these commands

mysqlcheck --all-databases -r
mysqlcheck --all-databases -a
mysqlcheck --all-databases -o

What do they do?
First - repairs
Second - Analyze
Third - Optimize

Now the complicated part, It might be easier but I rather take the time and make sure it works.
Still in SSH type
cd /var/lib/mysql/
chown mysql:mysql dbname/ -R
mysql -u user -p dbname -e 'show tables;'
(REPLACE DBname with the Database name, example : mysite_wp53)

Now go into WHM and find Database Map Tool. It's under SQL Services
Find the domain. (example: mysite.com)
When you click it it will appear as
cPanel User: USERNAME
Database type: MySQL
Database users: (blank) (replace it with the username, example : mysite_user1)
Database names: (blank) (replace it with the database name, example : mysite_wp53)
*IMPORTANT they must match, and to make sure they match go into the client's account and check their MySQL structure.

This might be a bit confusing, but if someone can explain it better it would be great!