Re: Connection ms access to mysql
Hi, I think is better to export your each table from Access to a .txt formatted file...fields separated by ',' and end_of_line by ';'.It's better to avoid Cr or CrLf. Copy the .txt files into MySQL server host in a directory where MySQL have reading rights. And after this you can import in your MySQL tables using (...this can be a way) LOAD DATA... E.g: LOAD DATA INFILE 'the_path_to_one_of_txt_files' INTO TABLE one_of_table_to_load FIELDS TERMINATED BY ',' LINES TERMINATED BY ';'; This it should be work. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: mc 02 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 18, 2003 7:51 AM Subject: Re: Connection ms access to mysql Hi Bob hall, I do apologize for being unclear in my previous message. To answer your question: Does the MySQL server run on your FreeBSD system? Yes MySQL runs prefectly with my FreeBSD 4.6 system. How are you trying to export your Jet tables? I assume that's what you mean when you refer to files. If you actually want to put your mdb files on FreeBSD, then you should be asking the freebsd-questions list about Samba. Im still unsure how im exporting the tables. What i want to do is exporting all the tables in the mdb files to mysql database and i dont know how to go about it. Thanx p.s: I'm looking into Samba as u mentioned previously. Regards MC -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup Meet Singles http://corp.mail.com/lavalife - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection ms access to mysql
On Fri, Jan 17, 2003 at 03:15:05AM -0500, mc 02 wrote: I've downloaded the necessary application MySQL 3.51 and myODBC for freeBSD. On the XP side i only downloaded myODBC. I played around the configuration but i still cant seem to export the files to my FreeBSD box. What am i doing wrong? Any help will be appreciated. I think the current port for FreeBSD is 3.23.54. If you've installed version 3.51.x, then you're using technology that's way too advanced for me. If you've installed 3.32.51, then upgrade to 3.23.54. If your port is an earlier version, cvsup the port and then upgrade. You say that you've downloaded it, but you don't mention installation and testing, so I'll ask a dumb question: Does the MySQL server run on your FreeBSD system? If the MySQL server runs on your FreeBSD system, the next question is: How are you trying to export your Jet tables? I assume that's what you mean when you refer to files. If you actually want to put your mdb files on FreeBSD, then you should be asking the freebsd-questions list about Samba. Bob Hall - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connection ms access to mysql
Christensen, Dave There doesnt seem to be any error when performed exports, however i still cant see the tables in mysql. - Original Message - From: Christensen, Dave [EMAIL PROTECTED] Date: Fri, 17 Jan 2003 07:51:28 -0600 To: 'mc 02' [EMAIL PROTECTED] Subject: RE: Connection ms access to mysql What errors are you seeing when you try to perform the export? -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup Meet Singles http://corp.mail.com/lavalife - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection ms access to mysql
Hi Bob hall, I do apologize for being unclear in my previous message. To answer your question: Does the MySQL server run on your FreeBSD system? Yes MySQL runs prefectly with my FreeBSD 4.6 system. How are you trying to export your Jet tables? I assume that's what you mean when you refer to files. If you actually want to put your mdb files on FreeBSD, then you should be asking the freebsd-questions list about Samba. Im still unsure how im exporting the tables. What i want to do is exporting all the tables in the mdb files to mysql database and i dont know how to go about it. Thanx p.s: I'm looking into Samba as u mentioned previously. Regards MC -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup Meet Singles http://corp.mail.com/lavalife - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php