Mor10 video for wordpress migrate DB

  • thetechyoldguy

    (@thetechyoldguy)


    9 years, 10 months ago

    Everytime I try to migrate from live site to local site, something goes wrong with the database.

    His video shows to drop all the tables in the fresh install of wordpress and then uploading a gz file to the site you are migrating to. It all reports to have been copied properly. However when I click on the migrated to site, it always insists on installing wordpress again. That means my gz file from the source is not migrating for some reason. I got pissed off after numerous failures an deleted DesktopServer. If someone could tell me where I was going wrong, I might reinstall it and try again. Not amused right now though.

    https://wordpress.org/plugins/wp-migrate-db/

Viewing 2 replies - 1 through 2 (of 2 total)
  • brianzulberti

    (@brianzulberti)

    9 years, 8 months ago

    Wow, I’d just like to say that I am having the exact same issue. Exact same issue. I came here boiling with frustration and hoping someone could help. If anyone knows what is up, please weigh in.

    At this point I want to take Mor10 and hurl him into a black abyss.

    Morten Rand-Hendriksen

    (@mor10)

    9 years, 8 months ago

    If after a migration you land on the WordPress installer page, it almost always means the database prefix in your migrated database does not match the table_prefix value in wp-config.php. Without matching tables, WordPress asks for new ones to be created through the install process.

    From what I can tell, DesktopServer uses the standard table prefix “wp_”, so my guess is the site you are exporting from has a different prefix. It is also possible the prefix in your particular DesktopServer site has a different prefix.

    To find out, open wp-config.php in your DesktopServer install and look for table_prefix. Make sure the prefix defined there matches the prefixes in the database tables of your exported site (you see them in phpMyAdmin at the beginning of each table name.) If the prefixes do not match, you know what the problem is. To solve this, you can either try to change the table_prefix setting in DesktopServer (just remember what the original setting was in case you want to switch back), or you can use the automatic Pull feature in WP Migrate DB Pro to handle the transfer seamlessly.

    For reference, this particular issue is addressed in the course in the movie called “The importance of matching table prefixes”: https://www.lynda.com/WP-Migrate-DB-Pro-tutorials/importance-matching-table-prefixes/472837/476570-4.html

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Mor10 video for wordpress migrate DB’ is closed to new replies.