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
--
Fight against proverty, join ROCK'Ed - http://www.rockedphilippines.org
- Help Opensource Mobile Technology advance, be a wiki editor at http://www.fingerapps.com/wiki
----
Roger P. Filomeno
*PGP IDs: 0xCB5F3FF7 / 0xBC0BFBA2 (http://keyserver.pgp.com)
Mobile Specialist / R&D
Finger Apps Inc, http://fingerapps.com
LBS eBusiness, http://www.lbsebusiness.com/
MyAyala, http://myayala.com
??(surprise)??, http://txtdomain.com
Friendster Mobile Philippines, http://friendster.com
KayaMoney e-Commerce, http://kayamoney.com/
KayaShop e-Market, http://kayamoney.com/shop/
*Registered Linux User # 367694
*VOIP # 6539822 (InPhonex)
_________________________________________________ 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
