How can I restore MYSQL Databases?

Discussion in 'MySQL' started by Internal09, Aug 30, 2011.

0
  1. #1
    Hello, I just transferred hosts and I uploaded all my home directory files from old host. But now I need to restore MYSQL Databases and I tried doing it through cPanel but it doesn't work. What are someways I can put it back up?
     
    Solved! View solution.
    Internal09, Aug 30, 2011 IP
  2. infogle

    infogle Prominent Member

    Messages:
    2,732
    Likes Received:
    128
    Best Answers:
    1
    Trophy Points:
    300
    #2
    Have you tried the backup feature on cPanel where you can also download the MySql Backups and upload the same to new host - By the way how many databases you have ?
     
    infogle, Aug 30, 2011 IP
  3. Internal09

    Internal09 Member

    Messages:
    256
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    35
    #3
    Yes I tried using that. I have about 10 different databases for 10 different sites. Each use wordpress.
     
    Internal09, Aug 30, 2011 IP
  4. #4
    Easiest way is using phpmyadmin export and Import feature.
    [​IMG]
     
    aap, Aug 30, 2011 IP
  5. Internal09

    Internal09 Member

    Messages:
    256
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    35
    #5
    So should I just create a new SQL Database with the same name and stuff and then import the old SQL Databases into that?
     
    Internal09, Aug 30, 2011 IP
  6. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #6
    Yes - create the database, then import the backup file for that database. Wash, rinse, repeat for the other 9.
     
    Rukbat, Aug 31, 2011 IP
  7. HalvinCarris

    HalvinCarris Peon

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Glad you solved it.
     
    HalvinCarris, Sep 3, 2011 IP