Title: Severe Database Corruption.
Last modified: August 19, 2016

---

# Severe Database Corruption.

 *  [Klark0](https://wordpress.org/support/users/klark0/)
 * (@klark0)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/severe-database-corruption/)
 * I’m trying to help a friend through this one, but it’s stumping me.
 * He’s got a pretty large wordpress install -> 46,000 posts, 120,000 comments, 
   12,000 subscribers, 20 cateogies, no tags. The database itself is 450MB at the
   moment.
 * About a week ago, he tried to optimise the database using cpanel. The command
   failed or stalled, and he had to restart the server to get it back online. On
   the front-end, everything is working fine and no errors are encountered. On the
   backend, these things happen:
 * – ALL Categories, Comments, Users, and Posts disappear and reappear randomly!
   This doesnt happen simultaneously. On Dashboard for example, you might see how
   many comments, but no posts. If you go to edit-comments.php, you see no comments
   but when you refresh the page they appear. The most annoying effect is probably
   when Writing Posts, and the categories don’t appear.
 * – The WordPress “Database Upgrade” notice appears like twice per day when visiting
   the wp-admin pages. No upgrades is necessary he’s already running 2.7. Of course,
   clicking Upgrade does nothing. Only way to get rid of this is to restart mysql.
 * I have tried repairing and optimising mysql via Cpanel and from ssh with ‘mysqlcheck’
   and ‘myisamchk’ with no success.
 * Any suggestions please ?

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

 *  [Saurus](https://wordpress.org/support/users/saurus/)
 * (@saurus)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/severe-database-corruption/#post-974251)
 * Can we assume he has never backed up his database?
 *  Thread Starter [Klark0](https://wordpress.org/support/users/klark0/)
 * (@klark0)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/severe-database-corruption/#post-974269)
 * His last backup was 2 years ago 😀
 * *sigh*

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

The topic ‘Severe Database Corruption.’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [Klark0](https://wordpress.org/support/users/klark0/)
 * Last activity: [17 years, 4 months ago](https://wordpress.org/support/topic/severe-database-corruption/#post-974269)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics