#1
  1. No Profile Picture
    spaceman
    Guest
    Devshed Newbie (0 - 499 posts)
    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?!
  2. #2
  3. No Profile Picture
    scollo
    Guest
    Devshed Newbie (0 - 499 posts)
    I doubt it's an "idiot's" guide, but O'Reilly has a new book out on MySQL and mSQL:

    http://www.oreilly.com/catalog/msql/
  4. #3
  5. No Profile Picture
    moderator
    Guest
    Devshed Newbie (0 - 499 posts)
    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:
    http://www.devshed.com/Server_Side/M...html#LOAD_DATA

Similar Threads

  1. Can't connect to mysql
    By pacman in forum MySQL Help
    Replies: 2
    Last Post: February 28th, 2003, 01:46 AM
  2. Problems converting MySQL to MS SQL with your scripts?
    By -=-steve-=- in forum PHP Development
    Replies: 0
    Last Post: August 15th, 2002, 02:22 PM
  3. Converting dates from mySQL?
    By misteraven in forum PHP Development
    Replies: 4
    Last Post: August 14th, 2002, 04:55 PM
  4. Converting MySQL database to MicrosoftSQL 2000
    By hotatom in forum MySQL Help
    Replies: 0
    Last Post: December 5th, 2000, 03:17 PM
  5. Replies: 3
    Last Post: April 22nd, 2000, 07:07 AM

IMN logo majestic logo threadwatch logo seochat tools logo