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.

migration mysql restoring

Discussion in 'General Discussion' started by mojamoi, Jan 28, 2014.

  1. mojamoi

    mojamoi Well-Known Member

    Joined:
    Jul 23, 2007
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    16
    migration using command line


    I successfully transfered all files to new server\\But how do u retore the .sql files
    \

    I know just cpanel username and password

    i did similar to this

    mysql database_de < database_de.sql
    mysql database_deaq < database_deaq.sql

    But client says only files were restored and not databases?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    The commands you used would have imported those SQL files into those databases. Do you have root access to the destination server? If so, you could try terminating the account on the destination server and restarting the transfer using the following option in Web Host Manager:

    "WHM Home » Transfers » Copy an Account From Another Server With an Account Password"

    Thank you.
     
  3. mojamoi

    mojamoi Well-Known Member

    Joined:
    Jul 23, 2007
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    16
    i have just root aceess no whm access



    "WHM Home » Transfers » Copy an Account From Another Server With an Account Password"


    when i do like this it says file corrupted
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    If you have root access to a server, then you have access to Web Host Manager. Simply sign into WHM with the "root" username and password. Feel free to open a support ticket using the link in my signature so we can take a closer look at the "File Corrupted" error message. You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page