Utilezez o aplicatie in php ( facuta de un coleg ) pentru conversie, scrisa in php cu documentatie de XBase. Am facut teste pe un dbf cu 2 milioane de inregistrari pe un dual P3/1.266 GHz cu 1GB memorie cu discuri RAID 5. Conversia din dbf in MySQL aprox. 20 min.
Cu utilitarul "dbf" ...maxim 2 minute ( DBF->csv-> MySQL ...are buguri daca vrei sa faca dump structura sql ...csv e ok !) . +++++++ -rwxr-xr-x 1 root root 322771299 Jan 6 09:35 ANEXAP.DBF -rw-r--r-- 1 root root 186062765 Feb 24 11:49 ANEXAP.csv -rw-r--r-- 1 root root 285781580 Feb 24 12:02 ANEXAP.sql +++++++ Mod de folosinta: /usr/local/bin/dbf --csv out.csv in.dbf mysql --local -e"LOAD DATA LOCAL INFILE 'out.csv' INTO TABLE my_table FIELDS TERMINATED BY ',' ENCLOSED BY '\"' IGNORE 1 LINES;" -umy_user my_database rpm -qil dbf Name : dbf Relocations: (not relocateable) Version : 0.8.1 Vendor: PLD Release : 2 Build Date: Thu Jan 22 10:56:10 2004 Install date: Fri Feb 20 09:19:54 2004 Build Host: i386-ac.pld.org.pl Group : Applications/System Source RPM: dbf-0.8.1-2.src.rpm Size : 26527 License: GPL Packager : PLD bug tracking system ( http://bugs.pld.org.pl/ ) URL : http://anubisnet.sf.net/products/dbf/ Summary : Tool to show and convert dBASE III, IV, and 5.0 files Description : Tool to show and convert the content of dBASE III, IV, and 5.0. Distribution: PLD 2.0 (Ac) /usr/bin/dbf /usr/share/doc/dbf-0.8.1 /usr/share/doc/dbf-0.8.1/BUGS.gz /usr/share/doc/dbf-0.8.1/ChangeLog.gz /usr/share/doc/dbf-0.8.1/FAQ.gz /usr/share/doc/dbf-0.8.1/README.gz +++++++++++++ On Mon, 2004-03-08 at 11:42, George M. wrote: > dbf2mysql > Eu l-am folosit cu succes acum vreo 4 ani. Din 2001 nu cred ca mai e > suportat. > > http://sourceforge.net/projects/dbf2mysql/ > > > Radu Bighiu wrote: > > Va salut, > > stie cineva un tool sau o modalitate da a importa bazele de date in > > format DBF in baze de date MySQL via MyODBC sau pe alta cale? > > > > Facea asta cu deficiente MySQL-Front dar acum nu mai e freeware iar > > versiunea shareware nu are aceasta optiune. > > > > Multumesc Anticipat! > > > > > > --- > > Detalii despre listele noastre de mail: http://www.lug.ro/ > > > > -- Laurentiu Negrisan --- Detalii despre listele noastre de mail: http://www.lug.ro/
