Need help transfering MySQL Databse to new Server using phpMySQL

Discussion in 'MySQL' started by red-sky, Jan 30, 2009.

0
  1. #1
    Hey,

    I'm having a problem transferring my GEOIP MYSQL database from one server to another, they are both shared servers.

    I have tried exporting and importing through PHPMyAdmin and to what I thought would be easy is proving to be a nightmare, here is the error I get:

    Does anybody know how to fix this? All I have done is a simple export to sql file and import it on the new server?

    Will be very grateful to anyone who knows how to sort this.

    Thanks in advance.
     
    red-sky, Jan 30, 2009 IP
  2. proxywhereabouts

    proxywhereabouts Notable Member

    Messages:
    4,027
    Likes Received:
    110
    Best Answers:
    0
    Trophy Points:
    200
    #2
    proxywhereabouts, Jan 30, 2009 IP
  3. red-sky

    red-sky Peon

    Messages:
    89
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks for the reply, had a look through it and it baffles me, where and what do I enter about the database file in the bigdump.php?

    Note: I am an utter noob with MySQL, don't ask me how i made the database, was a complete trial and error thing lol
     
    red-sky, Jan 30, 2009 IP
  4. charya

    charya Banned

    Messages:
    146
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Ill do it for you if u want..Pmd u already..i offer this service too on the hosting i offer at cthost..
    cya
     
    charya, Jan 30, 2009 IP
  5. red-sky

    red-sky Peon

    Messages:
    89
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Can anybody give any advice on how to use bigdump.php? I have followed the instructions and no matter what i do i keep getting thrown a '500 internal server error'. In the bigdump file, do I provide the database name, username and password of the dumped database that was dumped from server 1, or do i create a new database on server 2 and provide the database name, username, and password of that in the bigdump file?

    Please help...
     
    red-sky, Jan 30, 2009 IP
  6. rohan_shenoy

    rohan_shenoy Active Member

    Messages:
    441
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    60
    #6
    ^
    Probably, error 500 may mean that error is not the bigdump files! Can you just check again by deleting the bigdump files?
     
    rohan_shenoy, Jan 30, 2009 IP
  7. fulltilt

    fulltilt Peon

    Messages:
    128
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Sounds like you don't have a database to import into.

    Have you created a database on your new server before you start creating tables ?
     
    fulltilt, Jan 30, 2009 IP
  8. charya

    charya Banned

    Messages:
    146
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Dealing with this with red-sky :)...Fixed the 500 Internal Error
     
    charya, Feb 1, 2009 IP
  9. InovvativeTech

    InovvativeTech Banned

    Messages:
    32
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #9

    1)Make sure you have created a database before dumping it
    2)Select the database in PHPmyadmin-> Click Import-> Browse the file

    If you still get an error you can contact your hosting support about the issue
     
    InovvativeTech, Feb 3, 2009 IP