wp_postmeta with 2,017,701 items…

  • Resolved Dru K

    (@dsgncr8or)


    7 years, 9 months ago

    Hey – backup STALLS with the following error:

    wp_postmeta has very many rows (2017701) – we hope your web hosting company gives you enough resources to dump out that table in the backup.

    Any idea of how much memory would be needed?

    Have optimized and removed duplicates and orphans… using: WP DB Cleaner but cannot get this table any smaller…

    recommendations?

    https://wordpress.org/plugins/updraftplus/

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

    (@dsgncr8or)

    7 years, 9 months ago

    LOG FILE:
    ——————————–
    0638.821 (2) Table wp_postmeta: Total expected rows (approximate): 2017701
    0638.823 (2) [Warning] Table wp_postmeta has very many rows (2017701) – we hope your web hosting company gives you enough resources to dump out that table in the backup

    Plugin Contributor DNutbourne

    (@dnutbourne)

    7 years, 9 months ago

    Hi,

    Could you ask your hosts/server admin what your site’s maximum execution time is, and if this can be increased? If so, could you try increasing this to 900 seconds (or as high as possible).

    It would also be useful to increase the memory limit (to something like 512MB if possible).

    Then could you attempt a fresh backup of the Database only?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘wp_postmeta with 2,017,701 items…’ is closed to new replies.