Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to import more .dbf files to MYSQL

422 views
Skip to first unread message

kokookao

unread,
Aug 23, 2011, 10:35:48 PM8/23/11
to
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

J.O. Aho

unread,
Aug 23, 2011, 11:39:06 PM8/23/11
to
kokookao 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 ?

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/support_ticket/submit_ticket.html


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

--

//Aho

DBConvert.com - Database conversion solutions

unread,
Aug 25, 2011, 6:14:53 AM8/25/11
to
Hello,

Try DBConvert tool from http://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

kokookao

unread,
Aug 25, 2011, 11:24:42 PM8/25/11
to
On 8月25日, 下午6時14分, "DBConvert.com - Database conversion solutions"
<dms...@gmail.com> wrote:
> Hello,
>
> Try DBConvert tool fromhttp://www.dbconvert.com/convert-foxpro-to-mysql-pro.php

HI Dmitry :

Thank you for solution .

I will test it and feed back .

fabrice régnier

unread,
Aug 26, 2011, 3:40:24 AM8/26/11
to
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.

0 new messages