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

  1. shadez
    Posted 3 years ago #

    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.


  2. shadez
    Posted 3 years ago #

    ok so i found this:

    a derivation of it would mean that the following are the new tables added:

    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
    Posted 3 years 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
    Posted 3 years 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:


    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
    Posted 3 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic