|
Replies:
4
-
Pages:
1
-
Last Post:
Feb 9, 2011 9:45 AM
by: rossno
|
|
|
Posts:
3
Registered:
2/8/11
|
|
|
|
Corrupt database when using beta (possibly a coincidence though!)
Posted:
Feb 8, 2011 4:02 AM
|
|
|
Hi. This may be a coincidence, but I installed the latest beta version yesterday (prior to this I was using 5.0). Since then I've had database corruption twice (I think it's corruption anyway). The errors in mysql.log is:
110208 11:22:29 [ERROR] Column count of mysql.db is wrong. Expected 22, found 15. The table is probably corrupted
110208 11:22:29 [ERROR] mysql.user has no `Event_priv` column at position 29
110208 11:22:29 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
I'm using WAMP. When I hit the problem yesterday, I reinstalled WAMP and reverted to backups of my database. The same thing has happened again today.
As I say - it could well be a coincidence. I just thought I'd mention it just incase it isn't. I'm going to go back to using 5.0, and will let you know if it happens again or stops happening.
Cheers,
Dan.
|
|
|
Posts:
3
Registered:
2/8/11
|
|
|
|
Re: Corrupt database when using beta (possibly a coincidence though!)
Posted:
Feb 8, 2011 8:57 AM
in response to: Dracan
|
|
|
I've just had it happen again and I've only been using 5.0 since. So I guess it was just a coincidence, and there's something else afoot! Sorry for the false accusation! Not that it was actually an accusation 
Cheers,
Dan.
|
|
|
Posts:
2
Registered:
5/8/10
|
|
|
|
Re: Corrupt database when using beta (possibly a coincidence though!)
Posted:
Feb 9, 2011 2:48 AM
in response to: Dracan
|
|
|
Which MySQL Server version are you using? You can check it out by just quering
SELECT version();
The error message is shown generally after MySQL version upgrades.
|
|
|
Posts:
3
Registered:
2/8/11
|
|
|
|
Re: Corrupt database when using beta (possibly a coincidence though!)
Posted:
Feb 9, 2011 5:15 AM
in response to: ygozudeli
|
|
|
I think it was my graphics card messing up my machine. This morning I got to it, and it had rebooted and was showing a bootup message saying that it couldn't boot and was asking me if I wanted to recover from the recovery disk. After a bit of trial and error this morning with taking parts from different machines, I finally managed to boot up my system by changing the graphics card. It all seems to be working fine again now. Probably related to power usage, causing dodgy HDD/memory read/writes.
Sorry again about the false presumption.
|
|
|
Posts:
2
Registered:
2/9/11
|
|
|
|
Re: Corrupt database when using beta (possibly a coincidence though!)
Posted:
Feb 9, 2011 9:45 AM
in response to: Dracan
|
|
|
Yesterday, I downloaded and installed Toad for MySQL V 6.0.0.296.
I did NOT uninstall the 5.0 beta version first. Apparently the 6 install
did not update the version. Today, Toad thinks I am still trying to use
V 5, and directs me to the download page. Nuts.
I am afraid that if I completely uninstall V 5, I will lose all DB information
that Toad has stored.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
