dbTalk Databases Forums  

How to import more .dbf files to MYSQL

comp.databases.mysql comp.databases.mysql


Discuss How to import more .dbf files to MYSQL in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
kokookao
 
Posts: n/a

Default How to import more .dbf files to MYSQL - 08-23-2011 , 09:35 PM






hi:

I need to import more .dbf files to MYSQL with Collation
big5_chinese_ci .

Navicat can make .dbf to MYSQL , but only 1 file one time. I have more
than 1000 files need to transfer.

Anyone know how to do ?

--
Best Regards
--------------------------------------------------------------
kokoo KAO

Reply With Quote
  #2  
Old   
J.O. Aho
 
Posts: n/a

Default Re: How to import more .dbf files to MYSQL - 08-23-2011 , 10:39 PM






kokookao wrote:
Quote:
hi:

I need to import more .dbf files to MYSQL with Collation
big5_chinese_ci .

Navicat can make .dbf to MYSQL , but only 1 file one time. I have more
than 1000 files need to transfer.

Anyone know how to do ?
This is a navicat specific format and a navicat specific question, think it's
better for you to ask their support:

http://www.navicat.com/en/support/su...it_ticket.html


OT: don't use "--" in your signature, use "-- ".

--

//Aho

Reply With Quote
  #3  
Old   
DBConvert.com - Database conversion solutions
 
Posts: n/a

Default Re: How to import more .dbf files to MYSQL - 08-25-2011 , 05:14 AM



Hello,

Try DBConvert tool from http://www.dbconvert.com/convert-fox...-mysql-pro.php
It is able to convert bunch of DBFs to MySQL and it supports chinese
as well.

regards,
Dmitry

On 24 авг, 06:35, kokookao <kokoo... (AT) gmail (DOT) com> wrote:
Quote:
hi:

I need to import more .dbf files to MYSQL with Collation
big5_chinese_ci .

Navicat can make .dbf to MYSQL , but only 1 file one time. I have more
than 1000 files need to transfer.

Anyone know how to do ?

--
Best Regards
--------------------------------------------------------------
kokoo KAO

Reply With Quote
  #4  
Old   
kokookao
 
Posts: n/a

Default Re: How to import more .dbf files to MYSQL - 08-25-2011 , 10:24 PM



On 8月25日, 下午6時14分, "DBConvert.com - Database conversion solutions"
<dms... (AT) gmail (DOT) com> wrote:
Quote:
Hello,

Try DBConvert tool fromhttp://www.dbconvert.com/convert-foxpro-to-mysql-pro.php
It is able to convert bunch of DBFs to MySQL and it supports chinese
as well.

regards,
Dmitry

On 24 авг, 06:35, kokookao <kokoo... (AT) gmail (DOT) com> wrote:







hi:

I need to import more .dbf files to MYSQL with Collation
big5_chinese_ci .

Navicat can make .dbf to MYSQL , but only 1 file one time. I have more
than 1000 files need to transfer.

Anyone know how to do ?

--
Best Regards
--------------------------------------------------------------
kokoo KAO
HI Dmitry :

Thank you for solution .

I will test it and feed back .

Reply With Quote
  #5  
Old   
fabrice rgnier
 
Posts: n/a

Default Re: How to import more .dbf files to MYSQL - 08-26-2011 , 02:40 AM



Hi,

If you use a unix server, did you give a try to dbf2mysql ? I've been
using it for years as command line for hundreds files and it works
perfect. I don't know if chinese language is supported though.

regards,

f.


Le 24/08/2011 04:35, kokookao a crit :
Quote:
hi:

I need to import more .dbf files to MYSQL with Collation
big5_chinese_ci .

Navicat can make .dbf to MYSQL , but only 1 file one time. I have more
than 1000 files need to transfer.

Anyone know how to do ?

--
Best Regards
--------------------------------------------------------------
kokoo KAO

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.