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.

ERROR: Failed to dump one or more databases

Discussion in 'Database Discussions' started by Spetsnaz, Oct 31, 2012.

  1. Spetsnaz

    Spetsnaz Well-Known Member

    Joined:
    Jun 25, 2011
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    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
     
  2. Spetsnaz

    Spetsnaz Well-Known Member

    Joined:
    Jun 25, 2011
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    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) 
     
  3. Spetsnaz

    Spetsnaz Well-Known Member

    Joined:
    Jun 25, 2011
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    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!
     
Loading...

Share This Page