/usr/share/doc/gpsdrive/examples/wp2sql is in gpsdrive 2.10~pre4-6.dfsg-5ubuntu4.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | #!/bin/sh
echo put waypoints into database
echo "use geoinfo;" > wp.sql
cat ~/.gpsdrive/way-*.txt|awk '{print "insert into waypoints \
(name,lat,lon,type) values (\"" $1 "\",\"" $2 "\",\"" $3 "\",\"Own\");" }' >>wp.sql
# if you have other files (i.e. WLAN Access points in way_*) use
# the line below.
cat ~/.gpsdrive/way*.txt|awk '{print "insert into waypoints \
(name,lat,lon,type) values (\"" $1 "\",\"" $2 "\",\"" $3 "\",\"WLAN\");" }' >>wp.sql
mysql -u gast -pgast <wp.sql
|