I used 'mysqldump' to backup a database in Mysql, but failed to restore that again because it reminded me 'mysql.Time_zone' table was not found.

Then I ran 'mysql_update' but after that I could not even log in with the original username and password.

I tried to uninstall mysql with apt-get (by removing all package starts with 'mysql') and reinstall Mysql, but still , never able to login again, even i reset password for 'root'.

The last thing I tried was 'mysqld_safe' according to some sites, which reminds me 'some mysqld process is running'....


It is really killing me, I am using Ubuntu 9.04. Does anyone have some idea ? I do believe it happened because I didn't purge mysql correctly but wondering why.


Thanks,

-Kun

ubntu 9.04 has got bugs some times it fails to install in proper way. you down load text command and install or connect the hard disk to other meachine copy the data and reinstall the software. In my organization ubntu is used in client as well server side. I look after client side machine i normaly find this problem.

Please try to use 8.10 it has got less bugs and works faster also.

you can contact me in my skype id sap1536

BSrinivasashwin