File: FAQ

package info (click to toggle)
dbtcp 0.1.17-4.2
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 664 kB
  • ctags: 556
  • sloc: ansic: 4,134; perl: 414; makefile: 229; php: 69; sh: 68
file content (10 lines) | stat: -rw-r--r-- 430 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
 
1.1 - Can I run dbtcp as a NT service ?

Yes, you can run dbtcp as a service using firedaemon ( http://www.firedaemon.com ).

1.2 - Dump a DSN into MySQL

To dump a windows DSN into a MySQL table do something like this:
echo "SELECT * FROM mytable" | dbtcp DSN=mydsn myserver > /export/data.sql
echo "LOAD DATA INFILE '/export/data.sql' INTO TABLE mytable FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\''" | mysql mydatabase