The MU forums have moved to WordPress.org

Importing from a dead blog (12 posts)

  1. benjancewicz
    Member
    Posted 16 years ago #

    Alrighty; you guys have been so helpful, thank you!

    I have a blog I created for my father, that sadly died.
    I can't log in (though I can see the login page), and the whole thing is blank (not even an error).

    Here it is.

    Is there a way that I can get the posts exported so that I can import it into a new Wordpress MU blog?

  2. SteveAtty
    Member
    Posted 16 years ago #

    I can't even get to it, you've got a www/none-www looping redirect

  3. andrea_r
    Moderator
    Posted 16 years ago #

    Can you get the database? You can get the posts from that. Rename the tables for MU.

    More details here:
    http://bavatuesdays.com/importing-a-single-wp-blog-to-a-wpmu-installation/

  4. benjancewicz
    Member
    Posted 16 years ago #

    Alrighty. I followed his example, and I got the following error when I tried to import my old database into my new one:

    SQL query:
    
    --
    -- Database: <code>billjancewicz</code>
    --
    CREATE DATABASE <code>billjancewicz</code> DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    
    MySQL said: Documentation
    #1044 - Access denied for user 'zerflinu'@'localhost' to database 'billjancewicz'

    Do you know what that means?

  5. SteveAtty
    Member
    Posted 16 years ago #

    Yes, the script is trying to create a new database but the user you are connected as does not have the rights to create one.

  6. andrea_r
    Moderator
    Posted 16 years ago #

    You don't want to create a new database. you want to *import* the database tables into your MU database.

    And you have to rename tables. Are you *sure* you followed all the steps? :)

  7. benjancewicz
    Member
    Posted 16 years ago #


  8. benjancewicz
    Member
    Posted 16 years ago #

    Wow, it totally rejected my post.

    I tried to copypasta my two codes so you could see them.

    I did hit import, and I changed all instances of wp_ to wp_8_ (this is my 8th MU blog).
    The only thing I consciously didn't do from his tutorial was the removing the Kipple part. I didn't know what I should be deleting, so I didn't.

  9. andrea_r
    Moderator
    Posted 16 years ago #

    At the top of the SQL file, you can delete the CREATE DATABASE line.

    Cod in the forum has to be pasted in between backticks: `

    Large code should be linked to from pastebin.

  10. benjancewicz
    Member
    Posted 16 years ago #

    Alrighty. Still not working. I tried deleting the first CREATE DATABASE line, then I tried deleting all of them.

    And pastebin is rejecting them because they're too big, so I uploaded them to my server.

    Here's the original.
    Here's the modified one.

  11. benjancewicz
    Member
    Posted 16 years ago #

    Is it too complicated?

  12. andrea_r
    Moderator
    Posted 16 years ago #

    the links were borked. :)

    It *is* complicated, so you may have to do it in smaller chunks of data.

    For example, just concentrate on the wp_8_post table. Get that one imported. Go to the next one.

About this Topic

  • Started 16 years ago by benjancewicz
  • Latest reply from andrea_r