Accessing MySQL tables
So we're running into a somewhat perplexing issue on one of the servers at school right now. There have been a couple of power outages that brought the system down abruptly, and the servers are not very happy about it, particularly mysql. In order to get it to respond at all, we have to reinstall the mysql server. Meanwhile, I no longer know what version of mysql the existing databases were created with, and they can't be read by another version. Is there a way to determine the creating version for a mysql table that anyone knows of? Alternatively, is there a way to dump the tables to some useful format separate from the mysql command line? There are table files, but I'm not sure how useful that is. I'm hoping that at some point we'll be able to re-install this server from scratch, since it's still running Fedora 4, and that's causing a fair bit of headaches from no longer being supported. Who knows, maybe I'll be able to talk them into replacing it with Ubuntu instead. :P
(On a side note, I found out today that Ubuntu 8.04 and Fedora 9 will be releasing within a few days of each other.)
Delicious
Digg
StumbleUpon
Reddit
Facebook
Google
Technorati
Comments
two solutions
1) delete the mysql tables, and then run mysql_install to recreate them. you will lose stored procedures, and user permissions but pretty much everything else will be ok.
2) run mysql_upgrade_db on it -- if it's a newer version it will upgrade from the older version to the newer one. If that fails, install an even newer version of mysql and run mysql_upgrade_db on that.
Also check your permissions first, just in case. :-)