What I did is install MyODBC on my Windows machine where access database is located. In phpmyadmin, create a user that allows connection from your windows machine. Create a DSN in windows that connects to your MySQL server. From access, export your database using the DSN you’ve just created.

 

 


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jan gestre
Sent: Thursday, January 19, 2006 4:50 AM
To: Philippine Linux Users' Group (PLUG) Technical Discussion List
Subject: [plug] mysql database location question (mysql newbie)

 

im new to mySQL, i recently installed LAMP in my debian box, we have an existing access database that i want to transfer to mySQL, problem is how will i import the said database to my linux box, i dont know the location or directory where to copy the database assuming i've already converted the tables to mySQL format. i'm using phpmyadmin for my mySQL and there is no option there that says import existing database.
any ideas or suggestions?

TIA

_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph

Reply via email to