• I am trying to export all blog posts via Tools > Export, but I am getting an Internal Server Error (500). I’ve tried it again after disabling my plugins and deleting my .htaccess file.

    Is it possible to export the relevant WordPress database tables and import those into a blank WordPress installation by importing them directly into the MySQL-database?

    Which tables do I need to do this?

    Or is there maybe another way to get the posts from one blog and import them into a new WordPress blog?

Viewing 4 replies - 1 through 4 (of 4 total)
  • You could export the whole database into an sql file, and then import it into a new db through the command line or something like phpMyAdmin. However, you may run into problems, especially if the URL for the new installation is different. I would advise against it. The 500 error is a problem with the sever, and not necessarily wordpress.

    Thread Starter bartdg

    (@bartdg)

    Thanks, keighl.

    Do you think I also get problems when only exporting the posts and post-meta tables? And are those enhough? I just need the posts, dates and tags really.

    (I guess it has something to do with writing temporary files, because I cannot upgrade to a newer version from inside WordPress either. Is there maybe a way to get a more descriptive error message at a failing export? I would really like to know what goes wrong, so I can fix that.)

    Yeah, the more specific your sql export is, the fewer chances of a logistical bird’s nest.

    If you have access to your server log, or php log, they can give you more on what went wrong.

    Thread Starter bartdg

    (@bartdg)

    Thanks. I’ll have a go at exporting and importing only the posts and the posts metadata.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Export alternatives’ is closed to new replies.