Move Existing Old Multisite But Tables Are Missing

  • Resolved sammond7

    (@sammond7)


    11 years, 10 months ago

    Refering to: http://codex.wordpress.org/Moving_WordPress#Moving_WordPress_Multisite

    I need to move an existing, old multisite to a dev domain. Using the instructions above, and other info elsewhere, I attempt to find:

    • wp_site
    • wp_blogs
    • wp_x_posts
    • wp_x_options

    But they aren’t there?

    There are some very strange naming conventions included in this database, for example:

    • St4aARcKwnK0wp_12_posts
    • hc_connector_text

    There are also multiple databases in existence. Is it possible for a WP Multisite to create/use more than one database. Note that none of these databases contain the missing tables above.

    Look forward to someone else’s perspective on this one!

    Cheers,

    Sam

Viewing 15 replies - 1 through 15 (of 18 total)
1 2
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    11 years, 10 months ago

    Is it possible for a WP Multisite to create/use more than one database.

    Yes.

    Are you changing the domain name, though? If not, it’s just pick it up and go.

    Thread Starter sammond7

    (@sammond7)

    11 years, 10 months ago

    Yes, changing the domain and the directory…

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    11 years, 10 months ago

    Ow. Ow. Ow.

    Open wp-config.php and see what your table prefix is. I BET it’s St4aARcKwnK0wp_

    Then look in /plugins/ and see if you have HyperDB or SharDB.

    Let’s see if we can unravel this, but you’re in for a lot of work.

    Thread Starter sammond7

    (@sammond7)

    11 years, 10 months ago

    Sounds scary! Thanks for your advice so far.

    Indeed, the table prefix is St4aARcKwnK0wp_.

    No HyperDB or SharDB in the plugns dir, though. Here is a list of all the plugins in the dir:

    /_wp-ultimate-csv-importer-pro
    /admin-menu-editor
    /admin-menu-editor-pro
    /akismet
    /all-in-one-buttons
    /amzn
    /authorsure
    /batch-category-import
    /bbpress
    /blog-copier
    /breadcrumb-navxt
    /broken-link-checker
    plugins/cms-tree-page-view
    /plugins/contact-form-7
    /custom-permalinks
    /ditty-news-ticker
    /duplicate-post
    /duplicate-widget
    /dynamic-widgets
    /easy-google-fonts
    /easy-pricing-tables
    /eazyest-gallery
    /event-espresso-decaf
    /express-login-for-wordpress
    /foobar
    /genesis-club-lite
    /genesis-connect-woocommerce
    /genesis-custom-headers
    /genesis-dashboard-news
    /genesis-layout-extras
    /genesis-palette-pro
    /genesis-post-teasers
    /genesis-printstyle-plus
    /genesis-promotion-box
    /genesis-responsive-slider
    /genesis-shortcodes
    /genesis-simple-breadcrumbs
    /genesis-simple-edits
    /genesis-simple-headers
    /genesis-simple-hooks
    /genesis-simple-sidebars
    /genesis-slider
    /genesis-sticky-menu
    /genesis-tabs
    /genesis-tabs-extended
    /genesis-title-toggle
    /genesis-toolbar-extras
    /genesis-whats-new-info
    /genesis-widgetized-footer
    /google-analytics-dashboard-for-wp
    /googleanalytics
    /gppro-google-webfonts
    /gravity-forms-toolbar
    /gravityforms
    /i2sdk2-341
    /index.php
    /infusedwooPRO
    /infusionsoft
    /InstaBuilder
    /jetpack
    /js_composer
    /learndash-propanel
    /maintenance-mode
    /media-category-library
    /memberium2
    /menu-exporter
    /metro-theme-widget-titles
    /multisite-toolbar-additions
    /newjs_composer
    /nextgen-gallery
    /nextgen-gallery-custom-fields
    /ns-cloner-site-copier
    /ns-seo-custom-fields
    /offer-your-price
    /page-tree
    /pages-order
    /really-simple-captcha
    /redirection
    /revision-removal
    /revslider
    /rps-image-gallery
    /s3-video
    /s3bubble-amazon-s3-audio-streaming
    /seo-automatic-links
    /sfwd-lms
    /simple-social-icons
    /simple-urls
    /smart-manager-for-wp-e-commerce
    /smart-offers
    /smart-reporter-for-wp-e-commerce
    /social-profiles-widget
    /stp-importer
    /utw-importer
    /wc-bulk-variations-manager
    /widget-importer-exporter
    /woocommerce
    /woocommerce-admin-bar-addition
    /woocommerce-auto-complete-virtual-orders
    /woocommerce-buy-now
    /woocommerce-smart-coupons
    /woocommerce-sold-out-products
    /woocommerce-update-variations-in-cart
    /woothemes-updater
    /wordpress-importer
    /wordpress-seo
    /wp-clone-by-wp-academy
    /wp-firewall
    /wp-media-library-categories
    /wp-most-popular
    /wp-super-cache

    Hope this offers some clues…

    Cheers,

    Sam

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    11 years, 10 months ago

    Is there a db-config.php file by your wp-config.php file?

    Thread Starter sammond7

    (@sammond7)

    11 years, 10 months ago

    No. I can’t see any db-config.php file or similar anywhere in the installation.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    11 years, 10 months ago

    In wp-config, what’s your table prefix?

    Thread Starter sammond7

    (@sammond7)

    11 years, 10 months ago

    As you suspected, it is St4aARcKwnK0wp_

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    11 years, 10 months ago

    Well… Okay, those tables HAVE to be there somewhere or nothing runs 🙁

    They’ll be this:

    St4aARcKwnK0wp_site
    St4aARcKwnK0wp_blogs
    St4aARcKwnK0wp_x_posts
    St4aARcKwnK0wp_x_options

    Thread Starter sammond7

    (@sammond7)

    11 years, 10 months ago

    OK, so this is where it get’s weird and where I get stuck. Those tables do not exist. In any of the databases within this hosting account.

    Thread Starter sammond7

    (@sammond7)

    11 years, 10 months ago

    This is a list of all the databases and tables within this account. Hopefully you might be able to see something I can’t…cheers!

    [ Redacted ]

    Thread Starter sammond7

    (@sammond7)

    11 years, 10 months ago

    Mika,

    Can you please delete my last post? Rookie error, but the hosting account has been hacked since I posted the list of tables here. Sorry for the mess around. Would appreciate your prompt assistance with this.

    Thread Starter sammond7

    (@sammond7)

    11 years, 10 months ago

    Thank you for removing the table list! Obviously the original issue still persists…

    Confirming none of those tables appear in the databases on this hosting account.

    Thread Starter sammond7

    (@sammond7)

    11 years, 10 months ago

    I’m also curious to understand how the account was hacked simply from a table list? Somehow there were extra files with malicious code installed in to directories. How is this possible without login credentials?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    11 years, 10 months ago

    OK, so this is where it get’s weird and where I get stuck. Those tables do not exist. In any of the databases within this hosting account.

    They do… somewhere. Are you sure you’re seeing ALL the tables on the DB? If you’re using PHPMyAdmin, you have have to click to the next page.

    Also I didn’t delete your post so I have no idea what went on.

Viewing 15 replies - 1 through 15 (of 18 total)
1 2

The topic ‘Move Existing Old Multisite But Tables Are Missing’ is closed to new replies.