Creating and using an alternate database

  • Note: Related to a similar post, but with a new angle that I believe merits a fresh post)

    I recently moved a development site (dev.jasnamaine.org) to it’s permanent home (jasnamaine.org). I updated the urls in general settings.

    However, despite multiple efforts to search and replace the database via Velvet Blues and Better Search and Replace, the database still contains many references to the development URL.

    I’m on a cpanel setup with phpMyAdmin.

    I’d like to download the database, do a S&R for the old URL and then reupload the DB.

    Since this gives me the shivers, I’m wondering if I can:

    1) Create a new database;
    2) Do the S&R;
    3) Upload the revised file to the new database;
    4) Update the reference in the WP-config file

    If I screw up, I figure I just need to switch back to the original DB, right? Or am I missing something here?

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

    (@sterndata)

    Volunteer Forum Moderator

    No, do not download and then search/replace as you’re wind up breaking serialized fields. Use the plugin “better search replace” to do your search and replace on the live site, *after* making a backup of the database.

    Thread Starter jgold723

    (@jgold723)

    OK… I tried that and BS&R found some, but not all of the references to the old dev url.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Creating and using an alternate database’ is closed to new replies.