return FALSE; $r = well_tag_thread__update(array('id' => $id), $update); return $r; } function well_tag_thread_find($tagid, $page, $pagesize) { $arr = well_tag_thread__find(array('tagid' => $tagid), array('id' => -1), $page, $pagesize); return $arr; } function well_tag_thread_find_by_tid($tid, $page, $pagesize) { $arr = well_tag_thread__find(array('tid' => $tid), array(), $page, $pagesize); return $arr; } ?>WordPress Multisite - How to backup only 1 child website database (not everything)?

科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

    最新消息：雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客
    你的位置： 首页>programmer>WordPress Multisite - How to backup only 1 child website database (not everything)?

    WordPress Multisite - How to backup only 1 child website database (not everything)?

    programmeradmin1浏览0评论

    I have a WordPress Multisite which includes a Demo website. The demo website database has to be restored hourly to a snapshot.

    It's easy to do for the whole Multisite, I just export the whole database as an SQL. How can I export only the specific demo site?

    I see that some WordPress tables like Users and Posts are mixed, which seems to be an issue.

    I have a WordPress Multisite which includes a Demo website. The demo website database has to be restored hourly to a snapshot.

    It's easy to do for the whole Multisite, I just export the whole database as an SQL. How can I export only the specific demo site?

    I see that some WordPress tables like Users and Posts are mixed, which seems to be an issue.

    • multisite
    Share Improve this question edited May 11, 2020 at 13:28 bueltge 17.1k7 gold badges62 silver badges97 bronze badges asked May 11, 2020 at 13:10 Stefan SStefan S 192 bronze badges
    Add a comment  | 

    1 Answer 1

    Reset to default 0

    ID of a site

    The data from a site inside a Multisite network are stored in separate tables of the database. Check the ID of the site in your back-end:

    Network --> Websites

    Now mouse over, hover effect, about a edit link and you find the ID of the site inside the link /wp-admin/network/site-info.php?id=123

    Tables

    Each table with this ID inside the name is for this site, like wp_123_posts.

    Plugin hint

    It gives also several plugins there have this as solution for easy to use, like 'BackWPup' or similar. The ID of the site is also easier to find with a helping tool. Also, here you should find plugins, like 'Multiste Enhancements'.

    Multisite Only Tables

    The following tables are created during the network installation to help manage the network:

    • wp_site
    • wp_sitemeta
    • wp_blogs
    • wp_blog_versions
    • wp_signups
    • wp_registration_log

    Updated tables

    The wp_users and wp_usermeta tables become global across the subsites in the network

    Site specific tables

    After the prefix you find the ID if the site inside the table name, like wp_123_posts.

    • wp_commentmeta
    • wp_comments
    • wp_links
    • wp_options
    • wp_postmeta
    • wp_posts
    • wp_terms
    • wp_termmeta
    • wp_term_relationships
    • wp_term_taxonomy

    与本文相关的文章

    发布评论

    评论列表(0)

    1. 暂无评论