Strange Database Problem

[Masamune]

I wonder if anyone has had this happen to them.

Right now my domain has three databases. One for WordPress (rarely used) two Wikis (I'm on a PHP5 server), and one empty one just sitting around.

The Wordpress one is fine, but the Wiki ones spontaneously stopped working after a week or two of no problems. The databases seem to be completely empty and in fact, in the phpMyAdmin I can't even click to see the data inside the tables. Any attempts at making any backups also reveals an empty database.

I'm already on a LiveChat with support waiting on a response, just wanted to know if this kind of thing has happened before (and just how screwed I am).

[esoterum]

I don't know if this is the same problem, but my Mediawiki sql databases suddenly started giving this error:

#1033 - Incorrect information in file: 'whatever database record'

Including some of the databases which are already backups.

I would like to know what the problem is. I hope you get some feedback. Looking at the server statistics from the cPanel, there have been all kinds of problems this afternoon.

[Masamune]

So I'm not alone in it.

I dunno if LiveChat seemed to go anywhere, the person I talked to said he would consult upper level support, so...

I've been doing my own investigating in it, since I'm getting the same 1033 error you mentioned. I found this thread at the MySQL site:

http://forums.mysql.com/read.php?22,106192,130600#msg-130600

I dunno if this will work or not, but I'm gonna try it for one of my secondary Wiki that I actually have a backup of.

[Masamune]

Looks like they fixed it overnight somehow. Good news abounds.

[esoterum]

...maybe not abundant, but definitely good. I'm interested to know what the problem was. I never got any response on my trouble-ticket. I ended up sending replies to my own message a couple of times.

After looking at your reference to mysql.com, I was looking at phpMyAdmin, and I noticed that innodb is disabled on the server (also disabled in my wiki settings), so I don't know that is was related to the innodb variable mentioned in the mysql.com post. I also don't know much about MySQL.

Anyway, it's great to have working wiki's.

[CoCoWiki]

I encounter this problem the day before yesterday(2006.2.3 Beijing time). I'm not sure what is the root cause. Finally, I reinstalled my mediawiki. But my concern is whether it will happen again.:confused: