Trying copy database to new URL for development but table names are not wp_ (3 posts)

  1. xonline
    Posted 4 years ago #

    Please help.
    I am trying to do a significant upgrade and theme change to my wordpress website.

    I want to create a copy database on a test URL (ie http://www.mydomain.com and http://www.mytestdomain.com)

    However I find that the original mysql wordpress database tables don't start with wp_ but have a prefix of something else, eg ab_ (I presume at one point I considered a multi-site solution).

    So my plan was to copy export teh original database and import it into the test URL. Then run "safe search and replace" tpo swap teh url's over so that I could use them in the test environment - then put them back.

    But the test environment cannot see the ab_ wordpress tables.

    Please can anyone explain how I fix this.

    Many thanks


  2. fonglh
    Posted 4 years ago #

    Change the $table_prefix variable in the wp-config.php file of your test site to ab_

  3. xonline
    Posted 4 years ago #

    Genius, that worked - Thank you fonglh.

Topic Closed

This topic has been closed to new replies.

About this Topic