Announcement

Collapse
No announcement yet.

Moving a MySQL database from old host

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Moving a MySQL database from old host

    Hi there,

    I'm looking to move a web site hosting lock, stock and barrel from my old host to my eUKHost.

    This will involve moving an MySQL database.

    Can someone advise me the best way to do this? Is it just a case of backing up my current DB using PhPMyAdmin and then improting it using MyAdmin on my eUKHost account?

    I've never actually done this before so some advice would be really welcome!
    Online poker room ratings

  • #2
    if you have cpanel control panel with your old hosting company then the best option is to make a MySQL Server backup from backup section of control panel and then restore it from restore section of your control panel with us. if you dont have cpanel with other hosting company then you will need to download a full backup of database from phpmyadmin and restore it on our server from phpmyadmin.
    eUKhost - eNlight Cloud Hosting || eUKhost Knowledgebase
    Toll Free : 0808 262 0255 || Skype : mark_ducadi

    Comment


    • #3
      I must say if you've got access to phpmyadmin on both servers a simple export and import does the job very well - I've used this method many times without any problems. :smile:

      Comment


      • #4
        Great - thanks alot
        Online poker room ratings

        Comment


        • #5
          I think both ways will work sufficiently well for what you want to do. I think its just a matter of preference .
          David Smith
          Managing Director
          DPS Computing Limited

          - Massive update! (September 2011) - It's now not neglected!!
          - New Site (10/2009)

          Comment


          • #6
            Personaly I'd dump the database as if it's above a certain size you'll struggle getting it to work.

            Comment


            • #7
              I'd certainly do a backup of the database from phpmyadmin first. Then if your old host had cpanel i'd get support here to do the copy over for you (especially if you wanted email and other settings copied as well)
              if that fails for some reason you've always got you backup to rely on
              David Allen - www.serina.co.uk

              Comment


              • #8
                Hello,
                I am replying late and I hope the migration has already been done succeffully and the web site hosting is living happily ever after.

                For the benefit of others, a small suggestion:
                Don't delete the database from old host until a few days into the new host. This could be useful in case of compatibility issues if any.

                Keeping the IP address(es) of the old host also comes handy as you'd probably have moved your domain also to the new host.

                Regds
                IJ

                Comment

                Working...
                X