WordPress.org

Ready to get started?Download WordPress

Forums

My whole site is down! Database experts in here (8 posts)

  1. jjdjentertainment
    Member
    Posted 2 years ago #

    So heres what happen.

    Originally had my site on jjdjentertainment.com/home I want to setup multi-sites across multiple domains i had orginally set this up to do multi-sites in subdirectories, but from my reading it couldnt be done if it wasn't in the root folder.

    So I install a clean copy of wordpress in my rootfolder, brought over my post and such from my /home site and re-designed a new site. Went to install the muulti site feature today, go to the point i was adding the last bit of code to wp-config and .htaccess and i closed by browser by accident, so i have to go back into my site (i had to remove the code i just added into wp-config so it would let me back in) and went back to my network install. re-added the wp-config code and it recognized i was already in the middle of the install. did everything i needed and when i clicked the login button i got the code that my databases needed to be repaired.

    I did that and this is what it told me...
    wp_4_posts: Table 'jjdj_wrdp2.wp_4_posts' doesn't exist
    wp_4_comments: Table 'jjdj_wrdp2.wp_4_comments' doesn't exist
    wp_4_links: Table 'jjdj_wrdp2.wp_4_links' doesn't exist
    wp_4_options: Table 'jjdj_wrdp2.wp_4_options' doesn't exist
    wp_4_postmeta: Table 'jjdj_wrdp2.wp_4_postmeta' doesn't exist
    wp_4_terms: Table 'jjdj_wrdp2.wp_4_terms' doesn't exist
    wp_4_term_taxonomy: Table 'jjdj_wrdp2.wp_4_term_taxonomy' doesn't exist
    wp_4_term_relationships: Table 'jjdj_wrdp2.wp_4_term_relationships' doesn't exist
    wp_4_commentmeta: Table 'jjdj_wrdp2.wp_4_commentmeta' doesn't exist

    Help please

  2. I think you misunderstood something.

    If you install WordPress in a subfolder (i.e. your main site is at domain.com/foldername) then you cannot map domains.

    HOWEVER. If you installed WP in the main root of your site (domain.com) and your subsites are subfolders (domain.com/sitename) then you CAN use domain mapping.

    Do you have a good backup of your site?

  3. jjdjentertainment
    Member
    Posted 2 years ago #

    It looks to be that somehow I uploaded part of my database from my original site with the subfolder /home and it was showing that on my database of the new site. fixed it in PHPmyadmin and its working great. Now just need help with setting up the multi domain

  4. hattendesign
    Member
    Posted 2 years ago #

    I recommend using the xml export function from your old blog and then import it into the new one instead of going mysql > mysgl.

    In a multisite setup, wp will create new tables for each blog so you really have to leave it up to wp to figure out what goes where.

    So my 2 cents are, fresh install, fresh network setup, then import xml

  5. Yeah, but then you have to redo all your widgets, re-add users, etc etc. Moving from one DB to another is (normally) painless. And none of that was needed here, the OP could have used a subfolder install just fine.

  6. hattendesign
    Member
    Posted 2 years ago #

    ipstenu, I agree. DB migrations are relatively painless BUT not a db from a stand alone wp to a NETWORK wp. Plugins and themes need to be installed post network setup to avoid conflicts and make them available to the network. (i'm sure there are 1001 ways to do this without having to install each but that requires a little more knowledge than just getting it from a forum)

  7. Well. No. But AGAIN, the OP wasn't asking about that :) It's about listening to what people are asking, and trying to answer that SPECIFIC question.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.