August 24th, 1999, 12:23 AM
Can anyone point me to an idiot's guide for converting mSQL databases to MySQL databases? The ISP I work for has recently upgraded the services it offers from PHP/F1 & mSQL (which I'm very familiar with) to PHP3 & MySQL and I badly want to get stuck into the new combination. I'm a relatively experienced (relative to what, one might ask) web developer/Internet consultant, but my problem is that I'm a product of the GUI era and don't get on at all well with UNIX command lines and vi editors. I know of the msql2mysql utility, but the entire 'user manual' reads something like "run it on the msql source, compile it, and then fix all remaining problems". Hmmm. Surely someone can offer a better, friendlier, utility?!
August 25th, 1999, 12:53 PM
I doubt it's an "idiot's" guide, but O'Reilly has a new book out on MySQL and mSQL:
August 26th, 1999, 10:21 AM
Can you export a tab-delimited or a comma-delimited file from mSQL?
If so do that, then you'd be able to import that file into MySQL using the LOAD DATA INFILE command.
The documentation on LOAD DATA INFILE can be found at: