Multi-site by sub-directory moving main pages to sub-directory

  • sdoss

    (@sdoss)


    14 years ago

    Quick question – I’ve been able to successfully move/recreate the pages that were created under the main site in a multi-site install to a sub-directory, and it appears I haven’t lost anything as the page(s) work. I then trashed the pages that were in the main site, replaced the default theme of twentyten.

    This was done to avoid apparent conflicts in the theme the main site was using, and thus speed up access to other sub-directory sites (hasn’t happened yet, but I’m still looking at things).

    My question is, in trashing the pages via the dashboard, I expected to see the data in the wp-* tables (not all, but most) disappear. I still have references in the following tables to things related to the site that used to be there:

    wp_postmeta
    wp_posts
    wp_term_taxonomy
    wp_terms

    I expected to retain (and I did) the data in wp_options, wp_site, and wp_sitemeta. But what about the other stuff? The above tables all seem to be site-specific, as opposed to network-specific (i.e., things that can be seen/used by all sites).

    Is it safe to remove these directly from the database?

    Thanks…..

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Did you empty the trash?

    If the tables should be EMPTY (that is, you have no more posts at all) then yes, you could, BUT make a backup first just in case!

    Thread Starter sdoss

    (@sdoss)

    Emptied trash, but all data in those tables remain. My question was, if I have NO posts at all in the main site – no comments, no pages etc., then SHOULD those tables be empty??

    Thread Starter sdoss

    (@sdoss)

    Well. Backed up the database, emptied the 4 tables mentioned above from the MAIN site (as there are NO pages, No content there any more), went to sign on to wp-admin (just to check), and found that I was redirected to domain/new-site/wp-admin. Which is NOT where I wanted to be! So, there is obviously something in one of those tables that says, hey, I’m wearing the big red S, so come to me first! and when I moved my pages from the main to the sub-directory, it followed.

    Back to square one.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Two things come to mind.

    Psts and pages are stored in the posts table (duuuuh), but so are your revisions etc. WP has to have at least one post to work (possibly one page as well, can’t remember), so on top of that, you’ll always have something in there, if you have a site.

    Thread Starter sdoss

    (@sdoss)

    well, putting it back hasn’t hurt ?? I’ll explore this further when I dig myself out of this hole I’m in. Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Multi-site by sub-directory moving main pages to sub-directory’ is closed to new replies.