Forums
This topic is locked
newbie to mySQL needs a little guidance
Posted 08 Jan 2002 17:14:47
1
has voted
08 Jan 2002 17:14:47 Michael Rudge posted:
I'm looking for a tutorial that will give me some info on how to use mySQL. I have an Access DB that I am cotemplating migrating over and wonder if it is possible. Also I'm not sure if I have properly set up mySQL on my machine. It runs but the SQL is not creating the tables.TIA
Mike
Michael Rudge
Replies
Replied 16 Jan 2002 17:31:09
16 Jan 2002 17:31:09 Joe Scully replied:
Mike
Is is definitly possible to migrate from Access to MySQL. There are lots of tutorials if you search the Internet.
A few months ago, I converted by doing ...
(1) Setup MySQL database on Webserver
(2) Setup DSN connection to the MySQL database
(3) Open up your Access database
(4) Open each table individually and choose export it as "File Type - ODBC Database"
(5) Repeat step 4 until all tables have been exported
(6) Open your MySQL database and you will see the exported tables.
Regards
Joe
Is is definitly possible to migrate from Access to MySQL. There are lots of tutorials if you search the Internet.
A few months ago, I converted by doing ...
(1) Setup MySQL database on Webserver
(2) Setup DSN connection to the MySQL database
(3) Open up your Access database
(4) Open each table individually and choose export it as "File Type - ODBC Database"
(5) Repeat step 4 until all tables have been exported
(6) Open your MySQL database and you will see the exported tables.
Regards
Joe