Support » Fixing WordPress » Setting up test site using other site’s data in separate database

Viewing 1 replies (of 1 total)
  • Hi

    First read this

    Then, if you understand what I’ve said below, here is the method I use to accomplish what needs to happen:

    I do a database backup of the whole “new” WP database. That creates a text file of SQL code to recreate the database from scratch.

    I keep a backup copy of that file before making these changes.

    I load the SQL file into a text editor (NOT a word processor) – on Windows Notepad works if you don’t have a text editor). I then do a search and replace – replacing every instance of the old WordPress install URL with

    In phpMyAdmin, I delete all the tables in the database. Using phpMyAdmin Import I load the edited SQL file. The result of this is every reference in the database point to the new domain.

    The backup copy is important in case something goes wrong. Using it you can restore the database in 5 minutes.

Viewing 1 replies (of 1 total)
  • The topic ‘Setting up test site using other site’s data in separate database’ is closed to new replies.