WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Database differences between Single and Multisite installation (7 posts)

  1. shadez
    Member
    Posted 1 year ago #

    Hi,
    I wanted to know if any new entries/tables/etc are created automatically while upgrading a single WP installation to Multisite?

    Reason: i just upgraded my website to multisite, only to realize later on that i am running on shared server and hence cant use subdomains! yeah dumb me for not remembering it then!
    Now all my posts have gone corrupt post upgrade and has some unicodes(i guess) like 'Â' and 'â€' in all of them! :(
    you can see for yourselves at http://www.iamabiker.com
    i wish to rollback my DB(backup taken prior upgrade) asap. but am skeptical in updating the MS DB with a Non-MS one.

    Thanks...

  2. shadez
    Member
    Posted 1 year ago #

    ok so i found this:
    http://wpmututorials.com/how-to/how-to-disable-multisite/

    a derivation of it would mean that the following are the new tables added:
    wp_blogs
    wp_blog_versions
    wp_registration_log
    wp_signups
    wp_site
    wp_sitemeta

    so... there are 'NO' other changes/new-entries in DB???

    like i said, i dont want to rollback my multisite installation. just update the DB to previous single-site one.

    could somebody pls help confirm?

  3. Those directions are correct.

    The only addition to those tables are if you added a subsite (then you'd have wp_2_posts etc etc)

  4. ancawonka
    Member
    Posted 1 year ago #

    You can turn off multisite by restoring the database to a previous version, but you should also clean up the .htaccess file. You'll get database errors otherwise.

  5. shadez
    Member
    Posted 1 year ago #

    thanks ladies.
    strangely, reverting back htaccess and wp-config itself solved my problem of data corruption. and only other thing added extra into wp-config were these for security:

    [deleted]

    and yeah, thanks Mika for your books on WPMS. downloaded from halfelf.org and going thru it now...

  6. Those are your Secret keys: https://api.wordpress.org/secret-key/1.1/salt/

    SECRET is the key word ;) Don't share 'em. And yes, you should always have them. They make logging in more secure.

  7. shadez
    Member
    Posted 1 year ago #

    yikes! didnt know that. thanks again.. :)

Topic Closed

This topic has been closed to new replies.

About this Topic