convert access db to mysql db through phpmyadmin
Posted on 2004-11-03
I am trying to convert an access database to a MySql database held on a remote ISP.
The ISP doesn't allow remote access to the MySQL database but I do have phpMyAdmin installed and linked to the MySQL database (completely empty, no table, queries or data).
As remotely linking to the SQL db from my pc isn't possible is there a way I can do this through myPHPAdmin or is there another way?
Any help greatley appreciated,
P.S it isn't so much the data held within the tables I'm worried about more the tables themslves plus their relationships and queries which I would like to convert to the mysql format.