Importing just the posts (6 posts)

  1. Tlogmer
    Posted 11 years ago #

    I'm changing hosts; the new one has a different database setup, with different usernames, passwords, database names, etc. Copying over the whole database hasn't worked (for those reasons, I suspect), so I've just set up a new WordPress installation and I'm copying over the posts manually (there's more than 100 of them).

    Is there any way to import just the posts (not the rest of the database)? I exported the "posts" table in PHPadmin and tried loading it into the new database from telnet, but my mySQL knowledge is pretty limited and it didn't work.

    Or are there any mini-applications that'll help me copy the posts from one web form to another? Right now I have to copy from the Title field, the Post field, each of the many timestamp fields, etc. If I could just right-click and select "copy all forms" (or something) it would make the process a lot faster.

  2. James Huff
    Volunteer Moderator
    Posted 11 years ago #

    Have you tried following the tutorial here?


  3. Tlogmer
    Posted 11 years ago #

    Yep -- didn't work. ("couldn't connect to the database" error)

  4. Jinsan
    Posted 11 years ago #

    If you use CPanel, you could just back everything up and move it to your new host as a compelte backup which will preserve database and file strcutures

  5. sumeetsingh
    Posted 11 years ago #

    I think there are two ways of doing this:

    1. Export the posts to Movable Type format, and then use pre-defined import from Movable type format (using import-mt.php). I have never tried these, but they should work.
    Here is a script for exporting to movable type:

    2. Using RSS.

    Also, check this thread:

  6. Mark (podz)
    Support Maven
    Posted 11 years ago #


    The easiest way is to get the database connection going.

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.