Forums

Split 3 Blogs From 1 MySQL DB (5 posts)

  1. nmallory
    Member
    Posted 6 years ago #

    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?

  2. moshu
    Member
    Posted 6 years ago #

    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.

  3. word21
    Member
    Posted 6 years ago #

    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

  4. moshu
    Member
    Posted 6 years ago #

    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.

  5. word21
    Member
    Posted 6 years ago #

    Thanks

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.