How to migrate a larger mysql database to new host?

Discussion in 'Site & Server Administration' started by swapshop, Jun 4, 2007.

Thread Status:
Not open for further replies.
0
  1. #1
    Hello

    Can any one give me some more ideas on migrating a 8mb mysql db?

    Current webhost uses cpanel. I have been using mysql admin provided from cpanel.

    Issue is I cant export this size file due to 10,240k restriction
    I cant get shell access either.

    Backups are avaliable so I have attempted this route as well but the file exported as either a .zip or .gzip will not load into the new hosts mysql interface?

    What is the usual procedure to migrate a mysql db please? Or any additional ideas to assist me as I have a deadline to migrate my site please?
     
    swapshop, Jun 4, 2007 IP
  2. Brokentwo

    Brokentwo Peon

    Messages:
    70
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Hey swapshop.

    Have your host backup your account using the account backup script provided by cPanel. (ssh command ./pkgacct username) - In case your host doesn't know.

    Good luck, server transfers can be brutal sometimes. ;)
     
    Brokentwo, Jun 4, 2007 IP
  3. Cifra

    Cifra Well-Known Member

    Messages:
    383
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    110
    #3
    I migrated my 24 mb database with BigDump.
    Check it out: www.ozerov.de/bigdump.php
     
    Cifra, Jun 4, 2007 IP
  4. -Abhishek-

    -Abhishek- Regaining my Momentum!

    Messages:
    2,109
    Likes Received:
    302
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Do you have SSH access ?

    On your current server ... Run the SSH command ..

    mysqldump -uUSERNAME -pPASSWORD DATABASE > dump.txt

    Upload it to the new server and run

    mysqldump -u<username> -p<password> <database name> < dump.txt

    That should have you set on the new server ...

    Abhishek
     
    -Abhishek-, Jun 4, 2007 IP
  5. agnivo007

    agnivo007 Peon

    Messages:
    4,290
    Likes Received:
    289
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Yea...the above is a good way if one has ssh access...but you don't have it.

    Anyway, in cpanel, goto backup > click on the db name > save the dbname.gz to your hdd

    In new account cpanel backup section or better phpmyadmin for a new db, just import the file.

    8MB DB is nothing...after gzipping, it comes to about 4-5MB max ;)
     
    agnivo007, Jun 5, 2007 IP
    -Abhishek- likes this.
  6. -Abhishek-

    -Abhishek- Regaining my Momentum!

    Messages:
    2,109
    Likes Received:
    302
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Oh! Did the op say 8MB ? How come 10K restriction is stopping you then ?

    And for god's sake, 8 Mb is not a large DB!
     
    -Abhishek-, Jun 5, 2007 IP
    agnivo007 likes this.
  7. inworx

    inworx Peon

    Messages:
    4,860
    Likes Received:
    201
    Best Answers:
    0
    Trophy Points:
    0
    #7
    8 MB < 10 MB

    8 MB is large for dial up connections;)
     
    inworx, Jun 5, 2007 IP
  8. swapshop

    swapshop Peon

    Messages:
    656
    Likes Received:
    34
    Best Answers:
    0
    Trophy Points:
    0
    #8

    Think its a time out issue maybe php?

    Thanks for the replies

    We have not shell ssh access. Our host isnt helpful hence we are moving

    Cpanel backup works
    New host is DH

    Cant seem to import the file get a mysql error
    Same version mysql thou?
     
    swapshop, Jun 5, 2007 IP
  9. swapshop

    swapshop Peon

    Messages:
    656
    Likes Received:
    34
    Best Answers:
    0
    Trophy Points:
    0
    #9
    We get a error

    Download another backup.gz and tried it 3 times
    Error cant read file???
     
    swapshop, Jun 5, 2007 IP
  10. bouncer69

    bouncer69 Peon

    Messages:
    978
    Likes Received:
    43
    Best Answers:
    0
    Trophy Points:
    0
    #10
    If you want help I can help you. It is just nothing 5 min job.
     
    bouncer69, Jun 5, 2007 IP
  11. swapshop

    swapshop Peon

    Messages:
    656
    Likes Received:
    34
    Best Answers:
    0
    Trophy Points:
    0
    #11
    issue was [prefix_tablename] seems a install dodtn go well.In the end asked the host to install it with cmd mysql
     
    swapshop, Jun 12, 2007 IP
  12. inworx

    inworx Peon

    Messages:
    4,860
    Likes Received:
    201
    Best Answers:
    0
    Trophy Points:
    0
    #12
    I can help you this case. Pm me.
     
    inworx, Jun 12, 2007 IP
Thread Status:
Not open for further replies.