Setting up test site using other site’s data in separate database

Viewing 1 replies (of 1 total)
  • stvwlf

    (@stvwlf)

    15 years ago

    Hi

    First read this
    http://codex.wordpress.org/Moving_WordPress

    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 olddomain.com/blog with newdomain.com/newfolder

    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.