1grass-mesql(1)              GRASS GIS User's Manual             grass-mesql(1)
2
3
4
5MySQL embedded driver in GRASS
6

KEYWORDS

8       database, attribute table, driver
9

DESCRIPTION

11       MySQL database driver in GRASS enables GRASS to store vector attributes
12       in MySQL embedded database without necessity to run MySQL server.
13

Driver and database name

15       GRASS modules require 2 parameters to connect to a database.  Those pa‐
16       rameters are ’driver’ and ’database’. For MySQL embedded driver the pa‐
17       rameter ’driver’ should be set to value ’mesql’.  The parameter  ’data‐
18       base’ is a full path to the directory where database tables are stored.
19       The best place is a directory in the mapset. The directory must be cre‐
20       ated  before  use of the driver. In the name of database it is possible
21       to use 3 variables:
22
23           •   $GISDBASE - path to current GISBASE
24
25           •   $LOCATION_NAME - name of current location
26
27           •   $MAPSET - name of current mapset
28
29       Examples of connection parameters:
30       db.connect driver=mesql database=’$GISDBASE/$LOCATION_NAME/$MAPSET/mysql’
31       db.connect driver=mesql database=/home/user1/db
32

Data types, indexes

34       For more information about supported data types  and  indexes  see  the
35       documentation for MySQL (mysql) driver.
36

Database type

38       Because  database  closing  was found very slow if InnoDB was used, the
39       InnoDB storage is disabled by default (hardcoded ’--skip-innodb’ server
40       option).
41

Note

43       The  embedded  server is started with hardcoded ’--bootstrap’ option to
44       avoid warning about missing "mysql.time_zone_leap_second  table".  This
45       can be fixed in future.
46

Troubleshooting: SQL syntax error

48       Attempting  to use a reserved SQL word as column or table name will re‐
49       sult in a "SQL syntax" error. The list of reserved words for MySQL  can
50       be found in the MySQL manual.
51

SEE ALSO

53        db.connect, SQL support in GRASS GIS
54

AUTHOR

56       Radim Blazek
57
58       Credits: Development of the driver was sponsored by Faunalia (Italy) as
59       part of a project for ATAC.
60
61       Main index - Database index - Topics index - Keywords Index - Full  in‐
62       dex
63
64       © 2003-2022 GRASS Development Team, GRASS GIS 8 Reference Manual
65
66
67
68GRASS 8.3.1                                                     grass-mesql(1)
Impressum