Have you tried: http://www.lsbu.ac.uk/authoring/mysql/convert.shtml ?
MsAccess and MySQL have some differences esp on the field type so you must edit the .sql file to conform to MySQL field types.
On 1/20/06, jan gestre
<[EMAIL PROTECTED]> wrote:
On 1/19/06, Ariz Jacinto < [EMAIL PROTECTED]> wrote:here are your options:
a) use phpmyadmin to import your .sql files (yes phpmyadmin supports it).
tried doing this, but it did not show on phpmyadmin interface.
i tried to convert the access tables to txt files then insert it to the phpmyadmin, it is ok when the table has only one field, but when it is more than one, problem arise, it did not display correctly, all the data is loaded to one of the fields, is there a way around this? i forgot how to do this, can you give some pointers on how to overcome this, tried googling but not much help.
TIAb) use your windows/mysql client (console) to connect to the linux/mysqld
server and then create/use the database then execute the command:
mysql> source drive:/location/of/sql/files
* take note of the drive:
c) use your windows/mysql client (mysql admin / query browser,etc) to
connect to the linux/mysqld server and navigate its GUI to import your
sql files.
d) copy your .sql files to the linux box either thru scp, ftp, samba, etc.
and then run the mysql client console, create/use the database then
execute the command:
mysql> source /location/of/sql/files
On 1/18/06, jan gestre < [EMAIL PROTECTED]> wrote:i did find the location, my follow up question is how do i copy the database i've converted to .sql format to my linux box from my windoze client? do i just copy the sample.sql file? from what i saw from the directory there is no .sql file, all i can see is the .frm and .MYI files._________________________________________________On 1/19/06, jan gestre < [EMAIL PROTECTED]> wrote: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
_________________________________________________
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
_________________________________________________
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
