MySQL 4 Dbs -> MySQL 5?

[brownie124]

Hi,

I have a machine that has MySQL 4. something on it. Can I just copy those databases to another machine that has MySQL 5 on it and have them work properly?

Thanks,
- Brownie

 

[Kozusnik]

I would recommend using mysqldump. Dump the tables to a text file and import them on the new box.

I have moved files (mysqlhotcopy) from 4.0 to 4.1 (Linux only) without a problem, but I haven't played with 5 yet.

Mark