Export and Import on new server help please I beg!

Discussion in 'MySQL' started by JamesB, Jan 14, 2008.

  1. #1
    Hi All

    Please help?

    I recently purchased a site that uses a database. Mysql. Its an arcade site if that helps.

    I have managed to set up a hosting account for the site and uploaded all the files. Now I need to export the database from the original server and install that on my server. This is where I get really lost and need some detailed help.

    I go into the guys original myphp admin and export the database. I’m not to sure I’m ticking all the right boxes but I save it to my desktop.

    I then go to my server. This is where I’m lost. I have tried to set up a database and user then import the file I saved to the desktop. it comes up with an error.

    So then I try to import it with out setting up a user, again an error.

    Can someone please detail the correct steps to me?

    Thanks

    James
     
    JamesB, Jan 14, 2008 IP
  2. JamesB

    JamesB Peon

    Messages:
    510
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Well God Dam I think I sorted it!
     
    JamesB, Jan 14, 2008 IP
  3. ZKC

    ZKC Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    there is expert to solve my problem with mysql database i changed to new server so i cant upload to my data base
     
    ZKC, Jan 26, 2008 IP
  4. rojar123

    rojar123 Peon

    Messages:
    934
    Likes Received:
    33
    Best Answers:
    0
    Trophy Points:
    0
    #4
    you have to export the database from exisiting phpmyadmin. It will save it as an .sql file. Just import that into your new server and woo laa, it shud work, for further support , please do ask, cheerS:)
     
    rojar123, Jan 26, 2008 IP