[GRASSLIST:7721] importing with v.in.ascii into mysql db gives error
Jason Horn
jhorn at bu.edu
Tue Jul 26 10:17:56 EDT 2005
I have successfully set up mysql to store attribute data for several
point coverages for my project. However when I use v.in.ascii to
import new files, I get the following error:
dbmi: Protocol error
ERROR: Cannot describe table stations
Does anyone know what this means? Below is the full text of the
command I am using, and the error. The text file with the
coordinates is properly formatted.
GRASS 6.1.cvs (Texas_ll_WGS84):~ > cat coordinates.csv | v.in.ascii
out=stations fs="," x=2 y=3 cat=1 columns='cat int, x double, y
double, station_id varchar(10), name varchar(50), state varchar(10),
elev int, height int, lat_deg int, lon_deg int'
Maximum input row length: 78
Maximum number of columns: 10
Minimum number of columns: 10
column: 1 type: integer
column: 2 type: double
column: 3 type: double
column: 4 type: string length: 4
column: 5 type: string length: 22
column: 6 type: string length: 7
column: 7 type: integer
column: 8 type: integer
column: 9 type: integer
column: 10 type: integer
dbmi: Protocol error
ERROR: Cannot describe table stations
More information about the grass-user
mailing list