Title: BIG database problem!!! Please help!
Last modified: August 19, 2016

---

# BIG database problem!!! Please help!

 *  Resolved [darko74](https://wordpress.org/support/users/darko74/)
 * (@darko74)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/big-database-problem-please-help/)
 * I was writing a long long entry about some programming matter. It took me many
   hours to write it and explain the code.
 * But, I don’t know how, I was so idiot to change the wordpress database password
   of my hosting provider before saving or publishing it. It of course gave me an
   error when I tried to save the last changes. I got initially shocked because 
   I thought I had lost the last added text (a lot of text). Lucky me I use Firefox,
   and when I got back to the previous page, everything was still there. Then I 
   edited the **wp-config.php** file (as the error message suggested) and updated
   the password variable to the new one.
 * Now there’s no error displayed, but everytime I try to save the entry, the text
   area appears blank when the page is reloaded, and after checking the entry again,
   or previewing it etc, I can see that it’s totally empty!! even though everytime
   I paste on the text area all the text I previously saved in a text editor and
   next click on save, a message saying that the entry has been updated is displayed.
 * Please what can I do to restore WP working well with the database??

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

 *  [Mark Ratledge](https://wordpress.org/support/users/songdogtech/)
 * (@songdogtech)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/big-database-problem-please-help/#post-1276087)
 * Probably nothing wrong with your databse. Cut and save the text you want, then
   delete the problematic post/page and start a new post/page.
 *  Thread Starter [darko74](https://wordpress.org/support/users/darko74/)
 * (@darko74)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/big-database-problem-please-help/#post-1276118)
 * Thanks songdogtech!
 * I’ve done what you suggested:
    Bad posts deleted and started a new one. Saved
   it just once. The text still remains filled out, and just below the save button
   a small message says: Draft saved at 18:48:01
 * Afterwards I’ve checked the database with phpmyadmin, and the post is stored 
   in the **wp_posts** table, but these values are wrong in the record:
 * >  post_date post_date_gmt
   >  —————- ——————– 0000-00-00 00:00:00 0000-00-00 00:
   > 00:00
 * Now if I click on “save” again, the page is reloaded, the “post updated” message
   is displayed, and the editor appears blank just as I told before. After checking
   the database again, now I see a new record has been created in **wp_posts**. 
   This time it looks normal… but anyway it’s not displayed on the editor.
 * Any suggestion to add??
 * These are the values of the two records just in case this was useful:
    **ID:**
   54, 55 **post_author:** 1, 1 **post_date:** 0000-00-00 00:00:00, 2009-11-13 18:
   48:01 **post_date_gmt:** 0000-00-00 00:00:00, 2009-11-13 17:48:01 **post_content:**
   the whole text…., the whole text…. **post_title:** test, test **post_category:**
   0, 0 **post_excerpt:** -, – **post_status:** draft, inherit **comment_status:**
   open, open **ping_status:** open, open **post_password:** -, – **post_name:**-,
   54-revision **to_ping:** -, – **pinged:** -, – **post_modified:** 2009-11-13 
   18:55:11, 2009-11-13 18:48:01 **post_modified_gmt:** 2009-11-13 17:55:11, 2009-
   11-13 17:48:01 **post_content_filtered:** -, – **post_parent:** 0, 54 **guid:**
   [http://myweb/blog/?p=54](http://myweb/blog/?p=54), [http://myweb/blog/?p=55](http://myweb/blog/?p=55)**
   menu_order:** 0, 0 **post_type:** post, revision **post_mime_type:** -, – **comment_count:**
   0, 0
 *  [Mark Ratledge](https://wordpress.org/support/users/songdogtech/)
 * (@songdogtech)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/big-database-problem-please-help/#post-1276122)
 * Clear cache and cookies, delete history, restart browser. Deactivate any cache
   plugins you might be using. Publish the post, too, to see if it appears OK.
 *  Thread Starter [darko74](https://wordpress.org/support/users/darko74/)
 * (@darko74)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/big-database-problem-please-help/#post-1276126)
 * It works!!
 * I did clear the cache previously but didn’t delete any cookie. Now I’ve tried
   and it works!!
 * Thanks a lot songdogtech!! 😀

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

The topic ‘BIG database problem!!! Please help!’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [darko74](https://wordpress.org/support/users/darko74/)
 * Last activity: [16 years, 7 months ago](https://wordpress.org/support/topic/big-database-problem-please-help/#post-1276126)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics