Custom posts fails to export – too many entries?

  • steeped

    (@steeped)


    8 years, 10 months ago

    I am trying to export a custom post type which has around 500,000 entries.

    The second I export the post type (by going to Tools->Export), I receive the following error:

    This webpage is not available
    ERR_INVALID_RESPONSE

    When I export another custom post type that has just a few entries, it exports successfully.

    Firefox can’t find the file at

    http://website.com/wp-admin/export.php?download=true&cat=0&post_author=0&post_start_date=0&post_end_date=0&post_status=0&page_author=0&page_start_date=0&page_end_date=0&page_status=0&content=card&submit=Download+Export+File.

    This is resulting from a 500 error from WordPress:

    [12/Jun/2015:10:51:47 -0400] "GET /wp-admin/export.php?download=true&cat=0&post_author=0&post_start_date=0&post_end_date=0&post_status=0&page_author=0&page_start_date=0&page_end_date=0&page_status=0&content=card&submit=Download+Export+File HTTP/1.1" 500 20 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.81 Safari/537.36"

    I’ve tried increasing the upload_max_filesize but unfortunately this has no effect. I’m also not able to find any useful information in the normal logs. I temporarily enabled debug logging within WordPress and the following errors were logged when I tried to export:

    [12-Jun-2015 14:56:40 UTC] PHP Notice: Undefined index: rewrite_withfront in /home/account/public_html/wp-content/plugins/custom-post-type-ui/custom-post-type-ui.php on line 265
[12-Jun-2015 14:56:40 UTC] PHP Notice: Undefined index: rewrite_hierarchical in /home/account/public_html/wp-content/plugins/custom-post-type-ui/custom-post-type-ui.php on line 266
[12-Jun-2015 14:56:40 UTC] PHP Notice: has_cap was called with an argument that is deprecated since versiaccounton 2.0! Usage of user levels by plugins and themes is deprecated. Use roles and capabilities instead. in /home/account/public_html/wp-includes/functions.php on line 3508
[12-Jun-2015 14:56:40 UTC] PHP Notice: Undefined index: page in /home/account/public_html/wp-content/plugins/order-categories/category-order.php on line 20

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter steeped

    (@steeped)

    8 years, 10 months ago

    Anyone have this issue or know a fix?

    Moderator Jose Castaneda

    (@jcastaneda)

    THEME COFFEE MONKEY

    8 years, 10 months ago

    First off:

    custom post type which has around 500,000 entries.

    That’s a lot of entries!

    Second, have you tried exporting them in partials? Do them in timeframes of course. From like, Jan-Apr, then Mar-Jul and so on? That’s one way I can think of but it is a long, pain-staking process.

    🙁 sighs.

    A lot of it does depend on how big the export file is and how your server is setup as well. So, please do keep those things in mind. You may be able to ask your hosting company to help but it is just an idea. 🙂

    I’ve come across a site that needed 4 export files because the amount of content they had just on regular posts was that much. I think in total it was about 20G of data.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Custom posts fails to export – too many entries?’ is closed to new replies.