WP Migrate DB
[resolved] Database Moves - Pages, Post, Settings DO NOT SHOW (6 posts)

  1. mfaherty
    Posted 3 years ago #

    On all attempts with different sites
    when I move a database now, all the records show that it has moved to the new site database, but none of the pages, posts, or setting show in the new site??
    Is there a quick tweak. for this?
    This plugin has been perfect until maybe the 3.5.1 update?


  2. Brad Touesnard
    Plugin Author

    Posted 3 years ago #

    Hi, I'm not sure what the problem would be here. No one else has reported any issue like this, which leads me to believe there is something "special" about your data or database. Maybe you could upload your database to Dropbox/Google Drive and send me a link to download it? Then I can debug the issue.

  3. jayleask
    Posted 3 years ago #

    I was just running into a similar issue. I used your tool to create the backup, then used One-Click Install on Dreamhost to create a new instance of WordPress, then used phpmyadmin to import the backup.

    Upon import it looks like a new set of tables was created with new prefixes; i.e. "wp_h76j6o_posts" was created by the import and "wp_agfy7i_posts" was created by the one-click-install

    I take full responsibility for doing something wrong - I just don't have a clue what :)

  4. jayleask
    Posted 3 years ago #

    sorry, posting again so I can subscribe to responses - forgot to do that last time

  5. Ruude4s
    Posted 3 years ago #

    @Jayleask: in your case I think the problem is related to the custom table prefixes that Dreamhost uses in their one-click wordpress installs. This results in two wordpress sites using differnt table prefixes (in your case wp_h76j6o_ and wp_agfy7i_). You can fix this very easy. After importing the database, open the wp-config.php file and look for the following (probably in line 62):
    $table_prefix = 'wp_agfy7i_';
    Change it so it uses the prefix of the imported database:
    $table_prefix = 'wp_h76j6o_';
    After saving it should now show all the posts. You can delete the tables created by the one-click install (although leaving them there won't hurt anybody).

    And btw, you can subscribe to a thread by clicking 'Subscribe to topic' in the right sidebar.

  6. pascalhammerli
    Posted 2 years ago #

    Thank you,

    Though I did not use your tool, I had exactly this problem. Changing the prefix from within PHPmyAdmin worked perfectly!

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WP Migrate DB
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic