Hi Eko!
It shouldn't be an issue with table size. More likely, it is due to
duplicate records in the import file. Can you post the SHOW CREATE
TABLE for your table in full (including primary key information)? Also,
any output from your import run would be useful.
Thanks!
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED] mob: +1 614 406 1267
Are You MySQL Certified? http://www.mysql.com/certification
Got Cluster? http://www.mysql.com/cluster
Eko Budiharto wrote:
hi,
I have a database from dbf file that has almost 100 thousands records, when I
import them into mysql, it is only imported 13359 records.
my table structure is like this:
`faktur` varchar(10) NOT NULL,
`tgl` date default NULL,
`tgl_terima` date default NULL,
`kontan` varchar(1) default NULL,
`cust` varchar(10) default NULL,
`slm` varchar(3) default NULL,
`term` bigint(3) default NULL,
`muka` decimal(8,2) default NULL,
`disc1` decimal(4,2) default NULL,
`ndisc1` decimal(10,2) default NULL,
`ppn` decimal(4,2) default NULL,
`mtr` decimal(8,2) default NULL,
`netto` decimal(12,2) default NULL,
`ket` varchar(30) default NULL,
`total` decimal(12,2) default NULL,
`f_pajak` varchar(10) default NULL,
`tgl_pajak` date default NULL,
`ncust` varchar(30) default NULL,
`wil` varchar(3) default NULL,
`so` varchar(10) default NULL,
`satuan` varchar(1) default NULL,
`post` varchar(1) default NULL,
`vlt` varchar(3) default NULL,
`tukar` decimal(4,2) default NULL,
`sj1` varchar(10) default NULL,
`sj2` varchar(10) default NULL,
`sj3` varchar(10) default NULL,
`sj4` varchar(10) default NULL,
`sj5` varchar(10) default NULL,
`disc2` decimal(4,2) default NULL,
`ndisc2` decimal(10,2) default NULL,
`disc3` decimal(4,2) default NULL,
`ndisc3` decimal(10,2) default NULL,
I am wondering how I can enlarge the capacity of the table.
I am looking forward to a favorable reply from you. Thank you.
---------------------------------
Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
