I want to transfer my large MySQL database from OSX Server 10.3.9 (MySQL 4.0.24-log) to OSX Server 10.6.3 (MySQL 5.0.88-log)
I'm using mysqldump to generate an SQL file, and then importing it with mysql < xxx.sql. My sql file is 600 megs and contains 186 tables.
The problem is that I have many illegal characters in my column names. Most of the illegal characters are spaces and question marks. It wouldn't take too long to adjust the sql backup file to new names, but that's not the heart of the problem.
The problem is that I have years of custom applications with hard coded field names. We're talking php, vb, and many many access tables, forms, reports and vba code. It would take us a month or more to track down every field name.
Obiviously MySQL 4 has no problem with illegal characters. It's when I transfer that info into SQL that the problem arises.
Any suggestions as to how I can transfer my database without having to rename each column?