No mySQL db after site transfer in WHM

Discussion in 'Site & Server Administration' started by BluAzn, Feb 15, 2009.

  1. #1
    Hello there,

    I have a problem on my server, I am copying sites over to my server and it seems like the databases are missing. The site content has copied over, only the database itself isn't. Before it worked fine with the v11.20 but after I have upgraded into the latest version, the db has gone missing.

    Please give me solutions to this matter.

    Thank you,
     
    BluAzn, Feb 15, 2009 IP
  2. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #2
    About the only suggestion I have is to login into the old server and do a mysql dump. Then import it to the new server.
     
    Colbyt, Feb 15, 2009 IP
  3. Asus-Games

    Asus-Games Peon

    Messages:
    582
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #3
    You could try to use the "multiple account transfer" feature and see if that works better. If that doesn't work, here are some instructions on how to transfer a whole CPanel account using SSH:


    1. Log into WHM of your new server and create a new account called "restore", or anything you like for that matter. Remember the FTP address, username ('restore', in this example), and account password. We will need these for later.

    2. Log into the cPanel account you are wanting to transfer on the old server.

    3. Click on "Backup >> Generate/Download a Full Backup".

    4. Once here, select the backup destination to be "Remote FTP Server".

    5. Enter your email address for verification, followed by all of the FTP account information for "restore", which we created on the new server.

    -Remote Server: new server's address
    -Remote User: restore
    -Remote Password: restore's password
    -Port: 21

    Then, click "Generate Backup". This may take some time to backup the files, depending on how large the account is. You should receive an email provided in the above info once it is complete.

    6. Now, log into SSH on your new server.

    7. Type in the following commands:

    cd /home/restore/public_html

    ls

    After running the list command above (ls), you should see the tar file of the account on the old server. This means that you have successfully sent the file via FTP to your new server.

    8. Now move the tar file to your new server's /home directory with the following command:

    mv tar_file_name /home

    9. Now, log into WHM on your new server and navigate to "Backup >> Restore a Full Backup/cpmove file"

    Once here, you should see the old account's username under "Possible cpmove archives found:".
    If you do not, log back into SSH and be sure that the account's tar file has been moved into /home.

    10. Type in the account name in the text field in WHM, which is proceeded by "Enter the username for the account you wish to restore:".

    11. Click "Restore".

    12. Repeat process for additional accounts.
     
    Asus-Games, Feb 15, 2009 IP
  4. BluAzn

    BluAzn Well-Known Member

    Messages:
    1,477
    Likes Received:
    127
    Best Answers:
    0
    Trophy Points:
    185
    #4
    Thanks for the help, I managed to get the db during the transfer.
     
    BluAzn, Feb 20, 2009 IP