1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need help transferring databases to new host (urgent)

Discussion in 'Web Hosting' started by Dodge, Sep 20, 2011.

  1. Dodge

    Dodge Regular Member

    Joined:
    Jul 29, 2009
    Messages:
    389
    Likes Received:
    53
    Hi,

    If anyone could help it would be greatly appreciated:

    I've had to change host urgently and have a fullback of my site provided by my old host... I've reuploaded all the files from the home directory, but I am stuck on the databases.

    The folder provided by my old host for the database contains files with extensions like myd, myi, and frm... I've checked on Google and apparently one can just copy those into the database directory via FTP but I cannot find this on FTP for my new host - presumably you need special access or something?

    Is there any other way to quickly reupload the database from these files?

    THank you
     
  2. cyadron

    cyadron Registered Member

    Joined:
    May 4, 2008
    Messages:
    83
    Likes Received:
    149
    Hello,

    You can try this:
    Install easyPHP or WAMP on your local pc.
    Create a DB.
    Copy the files you got from your hosting to the newly created folder in your mySQL folder from WAMP (it should have the name of the DB you created).
    Use phpMyAdmin to export the DB to a sql file (pref. archived).
    Import that file to your new hosting (they should have phpmyadmin).

    Good Luck!
     
  3. ohyea

    ohyea Newbie

    Joined:
    Aug 4, 2011
    Messages:
    13
    Likes Received:
    2
    I can help you with this, just drop me a PM.
     
  4. Dodge

    Dodge Regular Member

    Joined:
    Jul 29, 2009
    Messages:
    389
    Likes Received:
    53
    Thank you I will try that - but where do I run phpMyAdmin from to export it?

    Thanks!
     
  5. cyadron

    cyadron Registered Member

    Joined:
    May 4, 2008
    Messages:
    83
    Likes Received:
    149
    You have phpMyAdmin in your WAMP or EasyPHP package. After you install it just browse to localhost.
     
  6. Dodge

    Dodge Regular Member

    Joined:
    Jul 29, 2009
    Messages:
    389
    Likes Received:
    53
    Will try now thank you!
     
  7. Dodge

    Dodge Regular Member

    Joined:
    Jul 29, 2009
    Messages:
    389
    Likes Received:
    53
    Can't find anywhere in WAMP to create a database and also when I try to go to localhost, Chrome says "the link is broken" :/
     
  8. Dodge

    Dodge Regular Member

    Joined:
    Jul 29, 2009
    Messages:
    389
    Likes Received:
    53
    Okay I realised running Skype was blocking the WAMP port - so I'm running it, have created the database too. Do I now just import the files on phpMyAdmin one by one and then export the database?

    Is it that simple?

    Thanks!
     
  9. cyadron

    cyadron Registered Member

    Joined:
    May 4, 2008
    Messages:
    83
    Likes Received:
    149
    Check your PM.
     
    • Thanks Thanks x 1
  10. Dodge

    Dodge Regular Member

    Joined:
    Jul 29, 2009
    Messages:
    389
    Likes Received:
    53
    Thank you so much - it worked. I really owe you big time!
     
  11. sameer5762

    sameer5762 Elite Member

    Joined:
    Sep 23, 2009
    Messages:
    5,228
    Likes Received:
    1,468
    Occupation:
    Software engineer
    Location:
    http;//sameer5762.com
    Home Page:
    Are you still looking for anyone to transfer our domain..:)
     
  12. kvchosting

    kvchosting Jr. VIP Jr. VIP

    Joined:
    Aug 23, 2012
    Messages:
    298
    Likes Received:
    75
    Location:
    Oklahoma
    Home Page:
    It would be better if you can fo a backup using mysqldump so that you get all data

    Extracting it as folder you could lose few data