Title: wp_postmeta help
Last modified: May 8, 2018

---

# wp_postmeta help

 *  Resolved [smg101](https://wordpress.org/support/users/smg101/)
 * (@smg101)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/wp_postmeta-help/)
 * Hi,
 * I am trying to determine how to fix an issue I am having. I used the Updraft 
   Backup plugin to backup my files but I get an error saying that my wp_postmeta
   is too large (over 1.4 million). So I downloaded the WP Optimize plugin and ran
   all the suggested updates (not the lines in red options). I then tried to run
   Updraft again but I am getting the same error
    wp_postmeta is too large). Would
   this WP Optimize plugin work for what I am trying to accomplish if I purchase
   the pro version or run the options in red font? I don’t mind doing so but I want
   to be sure it will solve this specific problem before I do so.
 * Thank you in advance.

Viewing 6 replies - 1 through 6 (of 6 total)

 *  [istiakferdous](https://wordpress.org/support/users/istiakferdous/)
 * (@istiakferdous)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/wp_postmeta-help/#post-10261348)
 * [@smg101](https://wordpress.org/support/users/smg101/) It seems you have a very
   large database. You can use phpmyadmin to take database backup. Out of my curiosity
   what hosting panel you use? There should be a backup manager which you could 
   use to take database backup. I hope this helps. Ping me if any help needed. Thanks.
 *  Thread Starter [smg101](https://wordpress.org/support/users/smg101/)
 * (@smg101)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/wp_postmeta-help/#post-10264341)
 * Yes, it is large. I know I could attempt to cleanup some things in phpmyadmin
   but I wanted to use a plugin instead since I am not 100% proficient in database
   cleanup & optimization. The hosting account is on an older Godaddy plan and does
   not have cPanel access. Does anyone have a quick tutorial on how to safely delete
   and optimize the Wp_postmeta table?
 *  Plugin Author [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/)
 * (@davidanderson)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/wp_postmeta-help/#post-10268273)
 * Where WP-O gives information about orphaned post-meta data, does it say you have
   much?
 * If not, then it may be that you can’t do much by optimizing away inefficiencies.
   It may be that some plugin on your site is intentionally storing all of that 
   data. Can you post a screenshot of the display of what can be optimised? (e.g.
   use [https://snag.gy](https://snag.gy)).
 * David
 *  Thread Starter [smg101](https://wordpress.org/support/users/smg101/)
 * (@smg101)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/wp_postmeta-help/#post-10279101)
 * Hi David,
 * Here is the screenshot of the error message I am getting in Updraft when trying
   to backup. Not sure if this is what you were looking for: [https://www.dropbox.com/s/63il8oxh81k3cnm/Screen%20Shot%202018-05-14%20at%2010.08.22%20AM.png?dl=0](https://www.dropbox.com/s/63il8oxh81k3cnm/Screen%20Shot%202018-05-14%20at%2010.08.22%20AM.png?dl=0)
 * Thank you for any help you could provide.
 *  [istiakferdous](https://wordpress.org/support/users/istiakferdous/)
 * (@istiakferdous)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/wp_postmeta-help/#post-10280671)
 * You can use this option but I think it will not help that much and you can try
   contacting your hosting provider so they can increase your PHP limitations to
   dump this big table.
    [http://prntscr.com/jhz97o](http://prntscr.com/jhz97o)
 *  Plugin Author [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/)
 * (@davidanderson)
 * [8 years ago](https://wordpress.org/support/topic/wp_postmeta-help/#post-10338424)
 * smg101 no, not that. I meant the main screen in WP-Optimize which provides info
   on how much data can be deleted through supported optimisations.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘wp_postmeta help’ is closed to new replies.

 * ![](https://ps.w.org/wp-optimize/assets/icon-256x256.png?rev=1552899)
 * [WP-Optimize – Cache, Compress images, Minify & Clean database to boost page speed & performance](https://wordpress.org/plugins/wp-optimize/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-optimize/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-optimize/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-optimize/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-optimize/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-optimize/reviews/)

 * 6 replies
 * 3 participants
 * Last reply from: [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/)
 * Last activity: [8 years ago](https://wordpress.org/support/topic/wp_postmeta-help/#post-10338424)
 * Status: resolved