Funnily enough, I had to do something similar last week...

Command line utility which will create a sql file to create the MySQL 

No guarantees that it works for everything, but it fulfilled my purposes...

Syntax is:

php -q odbc2mysql.php new_db output_file dsn [user] [password]

And will create a file which contains statements to set up the structure 
(creating <new_db>), and import the data.

DOESN'T bring across any indexes, or primary keys, cos I couldn't get the 
php odbc commands to work against Access. Dunno why. But you'll have to set 
those up yourself...



Richard Black
Systems Programmer, DataVisibility Ltd -
Tel: 0141 435 3504

-----Original Message-----
From:   Alex Francis [SMTP:[EMAIL PROTECTED]]
Sent:   13 February 2002 09:55
Subject:        [PHP-DB] Access to Mysql

I am a complete newbie at this so please excuse me if I seem stupid.

I have a guestbook on one site which was created using ASP and an Access
database. I have created a new site using the much more friendly PHP and
wish to get the data into my mysql database. Can I do this easily, and if 
can anyone point me to the required information

Alex Francis
Cameron Design
35, Drumillan Hill
Greenock PA16 0XD

Tel 01475 798106

This message is sent in confidence for the addressee only. It may contain
legally privileged information.
Unauthorised recipients are requested to preserve this confidentiality and
to advise the sender
immediately of any error in transmission.

PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to