WordPress to WordPress

  • ryanozawa

    (@ryanozawa)


    21 years, 1 month ago

    Since an export function seems to be the elephant in the living room (“we won’t help you leave!” and “why don’t you just follow these 11,435 steps to do it via MySQL!”), I’m glad I’m not asking for a way to get a simple text export of my WordPress blog to move to another CMS. What I am asking for is an easy way to move a WordPress blog on one server to another.

    On the originating server, the blog has its own MySQL database. On the new server, I want the blog to share its database with other users (which I managed using the built in prefix feature of the install script).

    How can I get the old blog’s content into a format that will be accepted on the new server and folded into the existing database – via MySQL or otherwise?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Mark (podz)

    (@podz)

    21 years, 1 month ago

    I would imagine that this will be very very tricky, if not impossible – but I stand to be corrected on this.

    Once you have an active blog (in ANY system, not just WP) that uses a database, many many links are generated between different tables and elements within those tables. One post generates a fair amount of data. Add into that comments, trackbacks, pingbacks … gets very complex very quickly.
    So to try and combine the two in a way that does not disturb any data at all is something that would be a huge task.
    For instance, if blog1 has a post with an ID of 6, and that has 3 comments, but so does blog2 have a post with an id of 6 but it has no comments, how does anything know what’s what ? If you see what I mean.
    This is not a complexity that only WP has – databases are like this, that’s why they are used.

    And the export function ? I’m sure someone has figured it out, but until they say so and offer to help others by spilling the beans……

    Nick Momrik

    (@mtdewvirus)

    21 years, 1 month ago

    ryan,
    Does this other DB has a WordPress install with the same prefix as your current one?

    If not, this is rather simple. You just need to export all of your tables/data from the old database and import them into the new one. To do this you can use PHPMyAdmin or the backup/restore plugin.

    If so, then like podz mentioned, I imagine it would be a little tricky.

    jalal

    (@jalal)

    21 years, 1 month ago

    podz is right… unless you want to put the old blog into a separate set of tables, in which case it should be straight-forward.
    I mention that because you do say that you have been using the prefix feature of WP so maybe you have each blog with a different prefix.

    jalal

    (@jalal)

    21 years, 1 month ago

    Hah, MDV beat me by 80 secs… 🙂

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

The topic ‘WordPress to WordPress’ is closed to new replies.