WordPress.org

1. grabbingsand
   Member
   Posted 1 year ago #

   Here is an interesting one.

   My old domain expired, but I was able to pull a complete MySQL database backup. I've registered and hosted a new domain at Dreamhost. For the sake of expediency, I opted for the One-Click Wordpress install.

   The new blog is: http://www.grabbingsand.org/wordpress/

   I would like to use my MySQL database backup to populate the new blog with all of my blog entries. This should simply be a matter of following instructions (such as here or here).

   But I can see that the Tables created by the One-Click install do not match the Tables in my backup. (I understand, of course, that my backup has some Tables from plug-ins not yet installed.)

   For example, where my old backup has "WP_links" -- the new install has created "wp_c4s7mf_links" ... this continues for "WP_options" and "WP_posts" and so on.

   I'm pretty certain that the Wordpress install will fail if I simply drop the "wp_c4s7mf_" tables and replace them with the old tables. So what is best to do? Open the backup and do a Find & Replace for "WP_links" (and other such Tables) to replace "WP_" with "wp_c4s7mf_"?

   Thanks for your attention.

Topic Closed

This topic has been closed to new replies.