2XeH4nS3

1$ dbf2mysql -vvv -q -h localhost -P password -U root smb/C_clist.DBF -d opera_dbf -t pricelists -c
2Opening dbf-file smb/C_clist.DBF
3dbf-file: smb/C_clist.DBF - Visual FoxPro w. DBC, MySQL-dbase: opera_dbf, MySQL-table: pricelists
4Number of records: 12
5Name         Length Display  Type
6-------------------------------------
7CL_CODE               8     0     C
8CL_DESC              30     0     C
9CL_CURR               3     0     C
10CL_FCDEC              1     0     N
11Making connection to MySQL-server
12Dropping original table (if one exists)
13Building CREATE-clause
14Sending create-clause
15CREATE TABLE pricelists (CL_CODE varchar(8) not null,
16    CL_DESC varchar(30) not null,
17    CL_CURR varchar(3) not null,
18    CL_FCDEC int not null)
19
20fields in dbh 4, allocated mem for query 279, query size 139
21Inserting records
22Inserting record 0
23LOAD DATA LOCAL INFILE '/tmp/d2mygo04TM' REPLACE INTO table pricelists fields terminated by ',' enclosed by ''''
24Closing up.... 
25     
26mysql> use opera_dbf;
27Reading table information for completion of table and column names
28You can turn off this feature to get a quicker startup with -A
29
30Database changed
31mysql> describe pricelists;
32+----------+-------------+------+-----+---------+-------+
33| Field    | Type        | Null | Key | Default | Extra |
34+----------+-------------+------+-----+---------+-------+
35| CL_CODE  | varchar(8)  | NO   |     | NULL    |       |
36| CL_DESC  | varchar(30) | NO   |     | NULL    |       |
37| CL_CURR  | varchar(3)  | NO   |     | NULL    |       |
38| CL_FCDEC | int(11)     | NO   |     | NULL    |       |
39+----------+-------------+------+-----+---------+-------+
404 rows in set (0.13 sec)
41
42mysql> select * from pricelists;
43Empty set (0.00 sec)
44
45mysql>