SHARE
TWEET

Untitled

a guest Jun 20th, 2019 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. $ dbf2mysql -vvv -q -h localhost -P password -U root smb/C_clist.DBF -d opera_dbf -t pricelists -c
  2. Opening dbf-file smb/C_clist.DBF
  3. dbf-file: smb/C_clist.DBF - Visual FoxPro w. DBC, MySQL-dbase: opera_dbf, MySQL-table: pricelists
  4. Number of records: 12
  5. Name         Length Display  Type
  6. -------------------------------------
  7. CL_CODE               8     0     C
  8. CL_DESC              30     0     C
  9. CL_CURR               3     0     C
  10. CL_FCDEC              1     0     N
  11. Making connection to MySQL-server
  12. Dropping original table (if one exists)
  13. Building CREATE-clause
  14. Sending create-clause
  15. CREATE 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.  
  20. fields in dbh 4, allocated mem for query 279, query size 139
  21. Inserting records
  22. Inserting record 0
  23. LOAD DATA LOCAL INFILE '/tmp/d2mygo04TM' REPLACE INTO table pricelists fields terminated by ',' enclosed by ''''
  24. Closing up....
  25.      
  26. mysql> use opera_dbf;
  27. Reading table information for completion of table and column names
  28. You can turn off this feature to get a quicker startup with -A
  29.  
  30. Database changed
  31. mysql> 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. +----------+-------------+------+-----+---------+-------+
  40. 4 rows in set (0.13 sec)
  41.  
  42. mysql> select * from pricelists;
  43. Empty set (0.00 sec)
  44.  
  45. mysql>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top