1grass-mesql(1)                Grass User's Manual               grass-mesql(1)
2
3
4
5MySQL embedded driver in GRASS MySQL database driver in GRASS enables GRASS to
6store vector attributes in MySQL embedded database without  necessity  to  run
7MySQL server.
8

Driver and database name

10       GRASS  modules  require  2  parameters to connect to a database.  Those
11       parameters are 'driver' and 'database'. For MySQL embedded  driver  the
12       parameter  'driver'  should  be  set  to  value 'mesql'.  The parameter
13       'database' is a full path to the directory where  database  tables  are
14       stored. The best place is a directory in the mapset. The directory must
15       be created before use of the driver. In the name of database it is pos‐
16       sible to use 3 variables:
17
18                      $GISDBASE - path to current GISBASE
19
20                      $LOCATION_NAME - name of current location
21
22                      $MAPSET - name of current mapset
23
24       Examples of connection parameters:
25         db.connect           driver=mesql          database='$GISDBASE/$LOCA‐
26       TION_NAME/$MAPSET/mysql'
27         db.connect driver=mesql database=/home/user1/db
28
29

Data types, indexes

31       For more informations about supported data types and  indexes  see  the
32       documentation for MySQL (mysql) driver
33

Database type

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

Note

40       The  embedded  server is started with hardcoded '--bootstrap' option to
41       avoid warning about missing mysql.time_zone_leap_second table. This can
42       be fixed in future.
43

SEE ALSO

45        db.connect, SQL support in GRASS GIS
46

Credits

48       Development  of the driver was sponsored by Faunalia (Italy) as part of
49       a project for ATAC.
50

AUTHOR

52       Radim Blazek
53
54       Last changed: $Date: 2007-10-28 22:04:00 +0100 (Sun, 28 Oct 2007) $
55       Help Index
56
57
58
59GRASS 6.3.0                                                     grass-mesql(1)
Impressum