RE: [PHP-DB] Access to Mysql

Funnily enough, I had to do something similar last week... Command line utility which will create a sql file to create the MySQL database. 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... HTH, Richy ========================================== Richard Black Systems Programmer, DataVisibility Ltd - http://www.datavisibility.com Tel: 0141 435 3504 Email: rblack@datavisibility.co.uk -----Original Message----- From: Alex Francis [SMTP:afrancis@camerondesign.co.uk] Sent: 13 February 2002 09:55 To: php-db@lists.php.net 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 so can anyone point me to the required information -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 afrancis@camerondesign.co.uk http://www.camerondesign.co.uk 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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php