Database Upgrading
 

I was wondering (and yeah go ahead and flame me because NO I DIDNT LOOK FIRST) does anyone know a good tool for taking an existing DB and upgrading it to a newer form of MySQL?

i.e.

I run my DB on 4.0.22 MAX-NT

lets say I wanted to put it on 5.0

I know that somewhere along the 4.1 line they made abunch of changes that make it impossible for me to just source my 4.0.x DB into a 4.1.xx system

does anyone know a converter I can sluice my 4.0.xx DB through to make it compat with a different version?

http://dev.mysql.com/doc/refman/4.1/en/upgrade.html
http://dev.mysql.com/doc/refman/5.0/en/upgrade.html

Important:
"As a general rule, we recommend that when upgrading from one release series to another, you should go to the next series rather than skipping a series. For example, if you currently are running MySQL 3.23 and wish to upgrade to a newer series, upgrade to MySQL 4.0 rather than to 4.1 or 5.0."

Oh, and consider yourself flamed to ashes. :grin:

Shrug, I bounce back and forth from 4.0, 4.1 and 5.0 SQL all the time with no issue. Or at least nothing obvious. I imagine the only place you'd run into problems is new functionality that older source files do not have... or deprecated functions (which is rare).

Naturally, following MySQL site documentation is always a great idea /flame flame.