Re: How to import data from Dbase3?
BG Mahesh wrote: Actually I prefer to dump the dbase file on a Linux machine and directly import it into MySQL. Yap, it is posible to dump the file in a linux machine but you must import it first into a windows mysql and later you dump it to a linux macine mysql. - Original Message - From: Peter Brawley [EMAIL PROTECTED] To: Ehrwin Mina [EMAIL PROTECTED] Subject: Re: How to import data from Dbase3? Date: Wed, 23 Mar 2005 02:21:48 -0600 Ehrin, If you have dBase III or later, Clipper or FoxPro, you can export the data comma-separated, then use a free csv-to-mysql utility eg http://sourceforge.net/projects/csv-mysql/ to get it into mysql. If you don't have an xbase executable, it's a little harder, but not much provided there's no memo file. A dbase data file is an ASCII file with a binary header. You can read the header in any file viewer, observe the header size, and find the field names lengths. The data is entirely ASCII, padded to exact col lengths, thus simple to parse with a perl or php script. If there's a memo file, you need an xbase executable. PB - Ehrwin Mina wrote: BG Mahesh wrote: hi How do I import data from Dbase3 into MySQL? -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ BG, There are tools you can use to migrate it to mysql, i use it before that i get it in the forum. You can search some forum indicating the migration tools for DB3, Foxpro, access. thanks, -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005 -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ -- *Ehrwin C. Mina* */Chikka Asia, Inc. /* *9/F RCBC Plaza Tower 2 6819 Ayala Avenue Makati City, Philippines hp1: +639189304383 hp2: +639178452102* *tel: +63-2-757-2630 fax: +63-2-757-2633 email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] *URL: **http://www.chikka.com* mailto:[EMAIL PROTECTED] *This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith.* -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to import data from Dbase3?
Hi there's a free utility name dbf2mysql I assume you are running dbase3 plus under windows/dos Look for it in google or ask me and I would send it to you. I´ve used it under windows with dbf tables from Clipper, dBase and Fox It doesn't require ODBC drivers at all. greetings Mauricio On Wed, 2005-03-23 at 17:34, Karam Chand wrote: If Dbase3 has an odbc driver then you can use SQLyog (www.webyog.com) to import data to MySQL. Karam --- Peter L. Berghold [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 BG Mahesh wrote: Actually I prefer to dump the dbase file on a Linux machine and directly import it into MySQL. There are a bunch of ways of skinning that cat. The easiest of which IMHO is to convert the data to comma separated files first and then use any one of a number of means to get it into the database. - -- Peter L. Berghold [EMAIL PROTECTED] Those who fail to learn from history are condemned to repeat it. AIM: redcowdawgYahoo IM: blue_cowdawg ICQ: 11455958 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCQW7WUM9/01RIhaARArhEAJ9ukrn8JSmmwmtdy9y86TVTcIx6vQCfQwZB G3BfaZB+So4iX6kbPlQCkOA= =cQYJ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to import data from Dbase3?
Do you want to do a one time import ? Create an ODBC source that maps to the dBase datasource and write an application to read it from there and import into mysql. - Navneet BG Mahesh wrote: hi How do I import data from Dbase3 into MySQL? -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to import data from Dbase3?
Ehrin, If you have dBase III or later, Clipper or FoxPro, you can export the data comma-separated, then use a free csv-to-mysql utility eg http://sourceforge.net/projects/csv-mysql/ to get it into mysql. If you don't have an xbase executable, it's a little harder, but not much provided there's no memo file. A dbase data file is an ASCII file with a binary header. You can read the header in any file viewer, observe the header size, and find the field names lengths. The data is entirely ASCII, padded to exact col lengths, thus simple to parse with a perl or php script. If there's a memo file, you need an xbase executable. PB - Ehrwin Mina wrote: BG Mahesh wrote: hi How do I import data from Dbase3 into MySQL? -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ BG, There are tools you can use to migrate it to mysql, i use it before that i get it in the forum. You can search some forum indicating the migration tools for DB3, Foxpro, access. thanks, -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to import data from Dbase3?
Actually I prefer to dump the dbase file on a Linux machine and directly import it into MySQL. - Original Message - From: Peter Brawley [EMAIL PROTECTED] To: Ehrwin Mina [EMAIL PROTECTED] Subject: Re: How to import data from Dbase3? Date: Wed, 23 Mar 2005 02:21:48 -0600 Ehrin, If you have dBase III or later, Clipper or FoxPro, you can export the data comma-separated, then use a free csv-to-mysql utility eg http://sourceforge.net/projects/csv-mysql/ to get it into mysql. If you don't have an xbase executable, it's a little harder, but not much provided there's no memo file. A dbase data file is an ASCII file with a binary header. You can read the header in any file viewer, observe the header size, and find the field names lengths. The data is entirely ASCII, padded to exact col lengths, thus simple to parse with a perl or php script. If there's a memo file, you need an xbase executable. PB - Ehrwin Mina wrote: BG Mahesh wrote: hi How do I import data from Dbase3 into MySQL? -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ BG, There are tools you can use to migrate it to mysql, i use it before that i get it in the forum. You can search some forum indicating the migration tools for DB3, Foxpro, access. thanks, -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005 -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ -- __ IndiaInfo Mail - the free e-mail service with a difference! www.indiainfo.com Check out our value-added Premium features, such as an extra 20MB for mail storage, POP3, e-mail forwarding, and ads-free mailboxes! Powered by Outblaze -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to import data from Dbase3?
I remember seeing some JDBC drivers for Java to read dbase 3 files. So it might be a good idea to use that to understand the files and import the data using the mysql jdbc drivers into the mysql database. We can help you do it (provided you pay) since we have already done similar exercise for a customer using VB.NET. - Navneet BG Mahesh wrote: Actually I prefer to dump the dbase file on a Linux machine and directly import it into MySQL. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to import data from Dbase3?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 BG Mahesh wrote: Actually I prefer to dump the dbase file on a Linux machine and directly import it into MySQL. There are a bunch of ways of skinning that cat. The easiest of which IMHO is to convert the data to comma separated files first and then use any one of a number of means to get it into the database. - -- Peter L. Berghold [EMAIL PROTECTED] Those who fail to learn from history are condemned to repeat it. AIM: redcowdawgYahoo IM: blue_cowdawg ICQ: 11455958 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCQW7WUM9/01RIhaARArhEAJ9ukrn8JSmmwmtdy9y86TVTcIx6vQCfQwZB G3BfaZB+So4iX6kbPlQCkOA= =cQYJ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to import data from Dbase3?
If you have ms access you can import the db3 into access and then export thru odbc to MySql Osvaldo Sommer -Original Message- From: BG Mahesh [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22, 2005 10:33 PM To: mysql@lists.mysql.com Subject: How to import data from Dbase3? hi How do I import data from Dbase3 into MySQL? -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ -- __ IndiaInfo Mail - the free e-mail service with a difference! www.indiainfo.com Check out our value-added Premium features, such as an extra 20MB for mail storage, POP3, e-mail forwarding, and ads-free mailboxes! Powered by Outblaze -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to import data from Dbase3?
Hi, How do I import data from Dbase3 into MySQL? My software, libmygis, is mainly designed for loading a set of Shapefiles into MySQL (.SHP, .SHX, .DBF) but it's perfectly well capable of loading just the dBase III/IV component. Grab libmygis-0.5.1 from: http://jcole.us/software/libmygis/ You should be able to load a file, e.g. foo.dbf, by doing: tools/mysqlgisimport -S foo | mysql -u myuser -p mydb It will automatically create a table suitable for the dBase file and load the records in with the above command. Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to import data from Dbase3?
If Dbase3 has an odbc driver then you can use SQLyog (www.webyog.com) to import data to MySQL. Karam --- Peter L. Berghold [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 BG Mahesh wrote: Actually I prefer to dump the dbase file on a Linux machine and directly import it into MySQL. There are a bunch of ways of skinning that cat. The easiest of which IMHO is to convert the data to comma separated files first and then use any one of a number of means to get it into the database. - -- Peter L. Berghold [EMAIL PROTECTED] Those who fail to learn from history are condemned to repeat it. AIM: redcowdawgYahoo IM: blue_cowdawg ICQ: 11455958 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCQW7WUM9/01RIhaARArhEAJ9ukrn8JSmmwmtdy9y86TVTcIx6vQCfQwZB G3BfaZB+So4iX6kbPlQCkOA= =cQYJ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to import data from Dbase3?
BG Mahesh wrote: hi How do I import data from Dbase3 into MySQL? -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ BG, There are tools you can use to migrate it to mysql, i use it before that i get it in the forum. You can search some forum indicating the migration tools for DB3, Foxpro, access. thanks, -- *Ehrwin C. Mina* */Chikka Asia, Inc. /* *9/F RCBC Plaza Tower 2 6819 Ayala Avenue Makati City, Philippines hp1: +639189304383 hp2: +639178452102* *tel: +63-2-757-2630 fax: +63-2-757-2633 email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] *URL: **http://www.chikka.com* mailto:[EMAIL PROTECTED] *This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith.* -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]