Data loss when upgrading MySQL?
 

Apparently FC3 came with a fairly old version of MySQL and I need to upgrade to a version with better subquery support before I can continue what I am working on. But if I upgrade MySQL by installing the latest RPM package, will I lose my old data? Or will the new MySQL software "automatically" find the old files and let me use them? I believe the version that is installed right now is 3.23.58. Will the file format for 3.x be different enough that 5.1 wouldn't be able to read 3.x files?

-Brandon

I don't have much experience with MySQL, but any respectable DBMS has some way of dumping tables to text/XML/etc... Personally, I would dump and recreate just to avoid any possible headaches from format changes.

Just for anyone who might have the same question and runs across this, I went ahead and upgraded from 3.x (the one that comes with FC3) to 4.1 and had no problems at all. All of my databases, tables and data is still there and working (although I would also recommend using mysqldump before doing the upgrade - just to be safe.)