joined:Aug 5, 2003
Our website has been chugging along nicely for years running mysql 4.0.27 when I suddenly thought it might be high time to upgrade into the present.
Of course the suggested upgrade path to 5.x from 4.0.x is to upgrade to 4.1 first and then to 5.x
But of course mysql just ended support for 4.x and I can't find its downloads on their site.
Is it safe to assume that since my database is just being used to serve up content and not handling stuff like ecommerce transactions or, I dunno, air traffic control, that my upgrade path would be like this:
Take the site down for maintenance (returning search engine friendly 503 error codes).
Export my site's content tables with mysqldump.
Eradicate mysql 4.0.27 from the server.
With no mysql around, do a clean install of mysql 5.x.
Create the users and then import my site's tables?