Support » Fixing WordPress » Multiple wordpress installs under one DB?

Viewing 15 replies - 1 through 15 (of 18 total)
  • http://wordpress.org/extend/plugins/super-categories/

    The Super Category plugin allows you to have multiple websites running off of one install and one database (one set of tables). The websites can share content if you wish it, and can have different titles, descriptions and themes.

    Moderator Jan Dembowski

    (@jdembowski)

    Brute Squad and Volunteer Moderator

    Yes. Just use a different table prefix for each install, that will keep them separate.

    Yes that’s true. That would create a separate set of tables for each site within the same database. I have no idea what the plugin *really* does. I have never used it myself.

    but on a normal install, can I simply point the config file to a database with another wordpress site already using it?

    Yes if you use a different table prefix.

    Ok, so I understand that the table prefix in the config file must be changed. Do i need to change the mysql database at all to accomodate these new table prefixes?

    No. The database will handle any number of prefixes–actually the database (MySQL) knows nothing about the table prefix. The table_prefix is just a way to keep file names unique when you put more than one installation of WordPress in a database.

    These pefixes.how would i go about changing them? open the sql file and edit it by hand? OR if i merely want to mirror the site with a second domain can that be done on the same server and how would I go about this?
    I did this successfully several years ago, but have forgotten what i did. Old age yanno..;)

    Thanks

    You change the table prefix in the individual wp-config.php files

    I’ve tried this, but with the second installation it won’t connect to the database. I have the exact same settings and tried to use the install feature, but no go. Do I need now to copy the database to a new location? That makes no sense to me. I tried also to use wp-admin/install.php and that won’t connect either.

    Is the second install on the same site or hosting package?

    Yes..same host. All I really want is to mirror the other with a domain instead of where it’s at now with a subdomain.

    You’re not going to be able to mirror a WordPress site like that unless you literally post everything twice – once in each site. Have you looked at Giving_WordPress_Its_Own_Directory as an alternative?

    How about this since i don’t really care all that much about the older version..Can I instead just copy everything over to the new location and keep the sql files intact save for the URLs listed in them? It’s all on the same server and the only thing I really want to change is the address

Viewing 15 replies - 1 through 15 (of 18 total)
  • The topic ‘Multiple wordpress installs under one DB?’ is closed to new replies.