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.

Copy Multiple Accounts: databases failing

Discussion in 'General Discussion' started by texo, Jan 19, 2012.

  1. texo

    texo Well-Known Member

    Joined:
    Mar 28, 2007
    Messages:
    143
    Likes Received:
    0
    Trophy Points:
    16
    Every account that I've copied using the "Copy multiple accounts/packages from another server" tool has copied without any problem except for the databases. Not one account had it's database copied correctly, and I had to mysqldump/scp/import dump for every one.

    Here is a sample of one transfer log with the error messages. Any advice appreciated!

    Code:
    Restoring database wellnomi_wp621......
    Restoration of MySQL database (wellnomi_wp621) failed with error: Execution of /usr/bin/mysql --defaults-file=/home/wellnomi/._.work.rFpkXkEF0idHh6Ka --force wellnomi_wp621 Saved to /home/wellnomi/wellnomi_wp621.sql.1326966046
    Done
    Restoration of MySQL database (roundcube) failed with error: Execution of /usr/bin/mysql --defaults-file=/home/wellnomi/._.work.rFpkXkEF0idHh6Ka --force roundcube Saved to /home/wellnomi/roundcube.sql.1326966046
    Done
    Restoring database wellnomi_wp673......
    Restoration of MySQL database (wellnomi_wp673) failed with error: Execution of /usr/bin/mysql --defaults-file=/home/wellnomi/._.work.rFpkXkEF0idHh6Ka --force wellnomi_wp673 Saved to /home/wellnomi/wellnomi_wp673.sql.1326966047
    Done
    Restoration of MySQL database (horde) failed with error: Execution of /usr/bin/mysql --defaults-file=/home/wellnomi/._.work.rFpkXkEF0idHh6Ka --force horde Saved to /home/wellnomi/horde.sql.1326966047
    Done
    Restoring database wellnomi_wp815......
    Restoration of MySQL database (wellnomi_wp815) failed with error: Execution of /usr/bin/mysql --defaults-file=/home/wellnomi/._.work.rFpkXkEF0idHh6Ka --force wellnomi_wp815 Saved to /home/wellnomi/wellnomi_wp815.sql.1326966048
    Done
    Done
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,450
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
  3. texo

    texo Well-Known Member

    Joined:
    Mar 28, 2007
    Messages:
    143
    Likes Received:
    0
    Trophy Points:
    16
    Thanks, but even with a minimal my.cnf the databses are still not restored successfully.
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,450
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    You might want to put in a ticket to cPanel Support so they can take a closer look then.
     
Loading...

Share This Page