Multisite DB – delete tables of dumped site

  • tvejacques

    (@tvejacques)


    1 month ago

    During an importing data process a power grid problem seems to have messed up some tables.
    We’ve done more than a week’s troubleshooting, and cannot solve the problems. So the quickest solution is to dump the problem secondary site and start again – fortunately early days in development process.
    QUESTION
    We’re weary to delete the wrong tables.
    WP seems to automatically add new tables in this kind of format:
    XXX_2_
    XXX_3_
    I’ve searched all over but cannot find how to answer:
    How do we determine which domain is mapped to which table names? – quick method (we can think of some convoluted methods, but some are scary).
    We use cPanel.
    Some pointer will be much appreciated.

    • This topic was modified 1 month ago by James Huff. Reason: moved to Networking WordPress since this is a multisite question
Viewing 6 replies - 1 through 6 (of 6 total)
  • Moderator Jose Castaneda

    (@jcastaneda)

    THEME COFFEE MONKEY

    4 weeks, 1 day ago

    Hey there!

    It’s been a really, really long time since I looked over any multisite/network site and I actually had to search for this too.

    The really interesting part was that the codex was still a bit useful but I’m sure it hasn’t changed much either. This page: https://codex.wordpress.org/Database_Description#Table:_wp_blogs

    The blog_id from what I can recall and see is what correlates to the wp_{id}_

    Hopefully that helps you out!

    Thread Starter tvejacques

    (@tvejacques)

    4 weeks, 1 day ago

    Aaah Jose Castaneda – thank you so very much.
    I’ve been searching for an answer for more than two weeks, and none of the support people on many sistes seem to know the answer.
    Fantastic.
    I will have a look.
    Have a great day!

    Moderator Jose Castaneda

    (@jcastaneda)

    THEME COFFEE MONKEY

    4 weeks, 1 day ago

    You’re welcome!

    Hope you get things sorted out

    Thread Starter tvejacques

    (@tvejacques)

    4 weeks, 1 day ago

    Jose Castaneda
    No luck.
    I went through the table list a few times.
    Of the 531 tables listed, not a single one contains the strings “wp_blogs”. In fact, only 5 start with the string “wp”.
    https://www.care4tulbagh.org.za/tables1.png
    My service host says this is a question they cannot answer, and I must get the answer here.
    I also went through found the php files to see if I could find something. network.php looks like the instruction set, but of course won’t include the mapping info.

    Moderator Jose Castaneda

    (@jcastaneda)

    THEME COFFEE MONKEY

    4 weeks, 1 day ago

    So it may not be exact wp_blogs but most likely along those lines. Do remember that the prefix can be changed from the wp-config file – so what you may be looking for is {prefix}_blogs table that will have IDs and domains listed.

    Let us know if that helps

    Thread Starter tvejacques

    (@tvejacques)

    4 weeks, 1 day ago

    Thanks.

    The only two tables with string blogs are
    * _blogmeta
    * _blogs
    without the digits _2 or _3
    thus probably that of the primary site.

Viewing 6 replies - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.