WP Hive » Installation and Configuration

More Existing Blog Import Questions

(6 posts)
  • Started 3 years ago by avaxcontrol
  • Latest reply from ikailo
  • 1 Members Subscribed To Topic

  1. avaxcontrol
    Member

    I have a large site that currently uses three different installs of WP (2.6ish). I'd really like to use WP Hive to make my life easier, but I'm fuzzy on how to set it up with existing blogs. I read this topic http://wp-hive.com/forums/topic.php?id=24, but it just confused me. Basically, I need more details on how to do it. I'm reasonably experienced with web stuff but from that one post I cannot for the life of me even begin to figure out what to do. Could anyone possibly help with more detailed instructions? I can't be the only person to ever have this problem...

    Thanks in advance.

    AX

    Posted 3 years ago #

  2. ikailo
    Developer

    Upgrade all the sites so they are all using the same version of WordPress. Be sure to log in to the admin for each so the database tables are updated correctly.

    Ensure all the sites share the same database. If they don't, then one way to do this is to dump the db tables to a text file and do a find/replace for the prefix. The important thing is that all the tables for each site has a unique prefix. Then import the tables into the shared database.

    Create your hive folder with a fresh install of WordPress, and add in all the plugins and themes that are used in all the sites. If any themes are edited, then I recommend you put them in separate folders. You might want to edit the style.css file to change the name so it can be distinguished for the appropriate site. Edit wp-config.php to add the database info, etc.

    Point your domains to the folder. From this point, you should be able to install WP-Hive according to the directions.

    You will probably want to edit the wphive_hosts table after the hive is initially set up. Add the unique table prefix set in the 2nd step above along with the corresponding hostname. This prevents wp-hive from trying to auto-create the prefix (and probably getting it wrong).

    I think this should do it. Let me know what the result is. Good Luck!!

    Posted 3 years ago #

  3. wwday3
    Member

    Hmmm. New to WP-Hive (just found it today, actually). I really wasn't thinking about the possibility of importing current installs into the "framework", but now you've got me intrigued.

    So, does this post mean the "wp_" tables are replicated for each "prefix"? I was under the impression WP-Hive blogs shared the "core" files somehow. Or, amd I misinterpreting something here?

    Posted 3 years ago #

  4. wwday3
    Member

    OK, dummy me. After thinking about it I realized that I was thinking in terms of files as "data files" rather than "script files". (I'm an *old* programmer who still thinks of tables as files :).

    So, never mind my prior question.

    Instead, let me ask this. Would it be a good idea to trname the tables in a blog's current database (with "wp_" as the current prefix) to the new prefix first, let it run for awhile to make sure nothing really weird happens, and then do the import steps as listed?

    Boy, it sure would be nice to rename the tables, and then somehow just "move" them.

    Posted 3 years ago #

  5. ikailo
    Developer

    You could certatinly rename the tables prefixes first - just ensure they will be unique in the new database. You'd also have to edit the wp-config.php file with the new prefix.

    Some MySQL DB tools are more functional than others, so it might be possible to just 'move' them depending on what you are using.

    Posted 3 years ago #

  6. ikailo
    Developer

    Found out some more useful info to add to this topic:

    If the database prefix changes (ie. wp1_ to wp2_), then users will also lose their defined roles. To work around that, rename the usermeta options from wp1_capabilities to wp2_capabilites. Also, I believe there is a reference to wp1_user_roles in the options table that needs to be updated also.

    Also, some plugins may depend on the table prefix as well, so do lots of testing. :)

    Posted 2 years ago #

RSS feed for this topic

Reply

You must log in to post.