Transferring Databases

  • I am currently working on a WordPress site for a client and her current site has thousands of pages dating back to 2006.

    Is there a way to replicate the entire site in a new design by just grabbing the database of posts and uploading that database to the new WP website?

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

  • Like download a copy of the database to your development environment? Yes.

    Access the sites database with PHPMyAdmin (or some other database tool), export the database (should generate a big long block of SQL code).

    Copy and paste this SQL code, using PHPMyAdmin’s import tool to your local dev environment’s database.

    Download the uploads folder (it has all the images) and place it in the wp-content folder of your local dev environment.

    Finish up by running a find and replace across all the tables to update all the urls to match the dev environment.

    See also: https://codex.www.ads-software.com/Moving_WordPress

    Hope this helps.

    Thread Starter mhollis

    (@mhollis)

    This will automatically re-create all pages?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Transferring Databases’ is closed to new replies.