Title: backwpup destroyed database while optimizing
Last modified: January 16, 2018

---

# backwpup destroyed database while optimizing

 *  Resolved [perropura](https://wordpress.org/support/users/perropura/)
 * (@perropura)
 * [8 years, 4 months ago](https://wordpress.org/support/topic/backwpup-destroyed-database-while-optimizing/)
 * Hi there, i have a problem..I was almost done with the website I was working 
   on.
    So I thought I would make a backup with Backwpup,have everything clicked
   on in the overview. So I assumed that the backup was ok.. I work locally with
   Xamplite, So I saw database optimize in the overview, and clicked some of the
   files. After optimizing, the hell breaks lose. Sorry for bad english. Thing is
   i can not get in wordpress by errors, the site is broken down because of the 
   files i deleted wit Backwpup are gone! First of all there where all errors, like
   these :
 * SELECT SQL_CALC_FOUND_ROWS wp_posts etc etc
    then :wp_postmeta.meta_key = ‘ehf_template_type’
   AND wp_postmeta.meta_value >= ‘type_header’ ) AND ( ( mt1.meta_key = ‘ehf_template_type’
   AND mt1.meta_value = ‘type_header’ ) ) ) AND wp_posts.post_type = ‘elementor-
   hf’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY CAST(
   wp_postmeta.meta_value AS CHAR) ASC LIMIT 0, 10
 * Then: SELECT wp_posts.FROM wp_posts WHERE 1=1 AND wp_posts.ID = 6 AND wp_posts.
   post_type = ‘page’ ORDER BY wp_posts.post_date DESC
 * Then: [Table ‘testdbwcztn.wp_posts’ doesn’t exist]
    SELECT SQL_CALC_FOUND_ROWS
   wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.
   post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE
   1=1 AND ( ( wp_postmeta.meta_key = ‘ehf_template_type’ AND wp_postmeta.meta_value
   >= ‘type_header’ ) AND ( ( mt1.meta_key = ‘ehf_template_type’ AND mt1.meta_value
   = ‘type_header’ ) ) ) AND wp_posts.post_type = ‘elementor-hf’ AND (wp_posts.post_status
   = ‘publish’) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS CHAR)
   ASC LIMIT 0, 10
 * And much more error’s so since i work local i think i can use data recovery on
   the local site on my hard drive. And it found lots of files in this directory..
   Should i make a bet and put them back in the local site\wordpress map??
    Please
   help me out!!
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fbackwpup-destroyed-database-while-optimizing%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  [happyAnt](https://wordpress.org/support/users/duongcuong96/)
 * (@duongcuong96)
 * [8 years, 4 months ago](https://wordpress.org/support/topic/backwpup-destroyed-database-while-optimizing/#post-9873498)
 * [@perropura](https://wordpress.org/support/users/perropura/)
    ” So I saw database
   optimize in the overview”, so you are using database optimize feature of Xampp
   lite?
 *  [happyAnt](https://wordpress.org/support/users/duongcuong96/)
 * (@duongcuong96)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/backwpup-destroyed-database-while-optimizing/#post-9922578)
 * [@perropura](https://wordpress.org/support/users/perropura/)
    since we haven’t
   heard back from you, I’m going to mark it as resolved. If you’re still having
   problems, feel free to let us know ;),
 * Btw, If you find BackWPUp is useful for you, we would really appreciate if you
   leave a positive review and rating.
    This would encourage us to develop new free
   features and provide free support 😀 [https://wordpress.org/support/plugin/backwpup/reviews/](https://wordpress.org/support/plugin/backwpup/reviews/)

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

The topic ‘backwpup destroyed database while optimizing’ is closed to new replies.

 * ![](https://ps.w.org/backwpup/assets/icon-256x256.png?rev=3236141)
 * [BackWPup – WordPress Backup & Restore Plugin](https://wordpress.org/plugins/backwpup/)
 * [Support Threads](https://wordpress.org/support/plugin/backwpup/)
 * [Active Topics](https://wordpress.org/support/plugin/backwpup/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/backwpup/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/backwpup/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [happyAnt](https://wordpress.org/support/users/duongcuong96/)
 * Last activity: [8 years, 3 months ago](https://wordpress.org/support/topic/backwpup-destroyed-database-while-optimizing/#post-9922578)
 * Status: resolved