Split 3 Blogs From 1 MySQL DB

  • When I build my 3 blogs, I only had permission to use 1 MySql DB on my host webspace. Now I can use more. I originally built the 3 blogs with separage WP installs. How hard will it be to pull 2 of the blogs out into their own MySql DBs?

Viewing 4 replies - 1 through 4 (of 4 total)

  • Just export the tables of one blog and then import it into the new location. Repeat the operation with the second blog.
    For export/import see the Codex: Backup and Restoring data. I guess it is the Moving_WordPress section or, at least, available from there.

    I have a related question – moving WordPress to another URL.

    I’m new to WP and am not familiar with the different files contained in it.

    I was reading the documentation and read something about ‘htaccess file’.

    Recently I uninstalled FrontPage (FP) extensions. I was warned that, if uninstalled, FP deletes all htaccess files in sub-directories.

    At the time I wasn’t aware WP had a htaccess file. I notice I don’t have an htaccess file in my copy of WP!

    Question 1
    Can someone tell me the contents of the htaccess file for V2.0? – so I can recreate it. And exactly which folder it’s supposed to be in.

    I’m also about to upgrade to v2.0.2 and am in the process of trying to figure out what I need to save/backup etc.

    Question 2
    I read somewhere on this site that we should upgrade to v2.0.1 and then v2.0.2. Is that right?

    I don’t have that option – as my host provides the upgrades and the only one available at the moment is v2.0.2. Is it really necessary?

    Thanks in advance

    1. Just upoload an empty file called .htacces to the root of your WP install = the main directory where the WP files are. Make it writable (chmod 666) and go admin > Options > Permalinks > set your permalink options and WP will write the rules to the .htaccess file.
    Note! If you do NOt use the so-called nice permalinks, but the default settings – you don’t need to do anything, you don’t need a ,htaccess file.

    1a. For upgrade, backup see detailed instructions: Upgrading_WordPress.

    2. No. That’s not true. Go from 2.0 > to 2.0.2.

    Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Split 3 Blogs From 1 MySQL DB’ is closed to new replies.