[resolved] Trouble moving WP database (13 posts)

  1. vadiva
    Posted 8 years ago #

    A new client wants his database packed up and moved from http://www.worldacupunctureblog.com to http://www.worldacupuncture.com/blog

    Great - WP is installed and dbase backed up.

    So now how do I get the database moved over? I can't import it via WP since it's not a WXR file.

    I've followed the steps in the Moving WordPress bit, but it's not working

    Help? :)

  2. vadiva
    Posted 8 years ago #

    Further info, now the http://www.worldacupunctureblog.com is being sent to http://www.worldacupunctureblog.com/wp-admin/install.php and asking to install WP - I don't want that since it's already there - I just want the the posts and pages and comments!


  3. flick
    Posted 8 years ago #

    This is confusing. As far as I can tell, your situation is like this:

    Original site was not WordPress but was located in the top domain. Now he wants to move this original site to /blog and he wants to use WordPress? What was he using before?

  4. vadiva
    Posted 8 years ago #

    Original site at http://www.worldacupunctureblog.com was WP

    Now moving blog to http://www.worldacupuncture.com/blog - still WP

    Want the original dbase posts, etc to show up in new install

  5. TrishaM
    Posted 8 years ago #

    You're not actually moving the database - it stays where it is. A database doesn't technically live at a domain, it lives on your server and your site files refer to it, in WP's case via the wp-config.php.

    It sounds like what you want to do is move the WP files ???......

    If that is the case, create a new top level folder called "/blog" and then MOVE all of the existing WP files to the new folder, keeping all of the existing sub-folder structure the same, so for example the folder where the theme is located will now be /blog/wp-content/themes/YourTheme/

    You will need a new "index.html", or "index.php", or some other default.htm file in your top level folder in order to handle traffic to the site, if that is the intention, and a new link to the "Blog" portion of the site which would be located at http://www.worldacupuncture.com/blog/

    You will ALSO need to log in and in the Settings >General you will CHANGE the URL that appears in the boxes to include the /blog/ on the end.

    If that is NOT what you are trying to accomplish, post back with a more clear explanation of what your client wants, and maybe why, and someone should be able to help you better....

  6. vadiva
    Posted 8 years ago #

    Thanks Trisha.

    I have created the new /blog/ subdomain, installed WP and installed the contents of the wp-content folder to the new subdomain.

    I realize that the database is still where it always was - question being - how do I connect the new install to the existing database?

    I've tried copying the contents of the original wp-config.php file, but I cannot connect to the existing database with the new installation.

    Is that any clearer or still muddy?

  7. @mercime
    Volunteer Moderator
    Posted 8 years ago #

    /blog/ subdomain

    You mean /blog/ subdirectory, big difference. Check out Moving WordPress to a New Directory article in Codex for more info. Good luck.

  8. flick
    Posted 8 years ago #

    @vadiva: Thanks for the extra info. I'd concur with mercime that the codex document is probably the most useful for you.

    p/s: Sometimes I feel tempted to just move posts/comments/categories etc. using the export WXR option, as the options table sometimes gets a little cluttered with all the test plugins ;)

  9. vadiva
    Posted 8 years ago #

    OK - supremely screwed now.

    Original blog at http://www.worldacupunctureblog.com has been reinstated, but when I connect it to its original database via wp-config.php it isn't showing the posts or anything. It's only showing the Hello World post.

    Any ideas?


  10. flick
    Posted 8 years ago #

    I think this is a sign that WordPress was effectively 'installed' into the database. I recall you mentioning that you did backup the database before the move, so I guess it's time to bring it out and import it via phpMyadmin?

  11. vadiva
    Posted 8 years ago #

    Thanks Mosey - did that but the (_)&(*@#&*(P@& thing still won't pull the data from the new dbase. I'm assuming that means I have something buggered up with the import?

    J ;)

  12. flick
    Posted 8 years ago #

    Umm... sorry to say this, but it certainly sounds like something has gone amiss. Since I'm slow; do you now have two databases going at the moment - one for the top level domain and the other at /blog?

  13. lamby85
    Posted 7 years ago #

    Mosey? Is that you? Use to own Zetapets or something similar? Remember me? Throw-In? :D

Topic Closed

This topic has been closed to new replies.

About this Topic