Backing up My SQL Database

  • andyandy

    (@androidandreas)


    8 years, 8 months ago

    On the face of it, backing up the database for my site was a doddle.

    My existing host made it simple, using the Control Panel.

    However, my question is whether a database created using one host’s software can be reinstalled on another host. Or is it impossible to give a general answer, and something that I would need to ask the new web hosting company?

    • This topic was modified 8 years, 8 months ago by andyandy.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    8 years, 8 months ago

    Yes, they’re all using various versions of MySQL and probably all offer phyMyAdmin.

    chrispink

    (@chrispink)

    8 years, 8 months ago

    You would need the same OS on the new server (e.g. if Linux now running mySQL then the easiest migration is with that OS on the new server)

    The easiest way to migrate a WordPress database is to

    export your old database using the default settings

    set up a new install on the new server then, using phpMyAdmin, drop all the tables in the database and import the old one.

    on the old server, compress the wp-content directory and download it. Then, on the new server, replace the newly-installed wp-content with the old one.

    One last step; once this is done, log in to admin, go to Settings > Permalinks and press Save.

    This will clone your site seamlessly.

    Thread Starter andyandy

    (@androidandreas)

    8 years, 8 months ago

    Thanks for the replies.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Backing up My SQL Database’ is closed to new replies.