NAME

       grass-mesql - MySQL embedded driver

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

Driver and database name

       GRASS  modules  require  2  parameters  to  connect  to  a database.  Those parameters are
       'driver' and 'database'. For MySQL embedded driver the parameter 'driver' should be set to
       value  'mesql'.   The  parameter 'database' is a full path to the directory where database
       tables are stored. The best place is a directory in the  mapset.  The  directory  must  be
       created  before  use  of  the  driver.  In  the  name  of database it is possible to use 3
       variables:

                      $GISDBASE - path to current GISBASE

                      $LOCATION_NAME - name of current location

                      $MAPSET - name of current mapset

       Examples of connection parameters:
       db.connect driver=mesql database='$GISDBASE/$LOCATION_NAME/$MAPSET/mysql'
       db.connect driver=mesql database=/home/user1/db

Data types, indexes

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

Database type

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

Note

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

SEE ALSO

        db.connect, SQL support in GRASS GIS

Credits

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

AUTHOR

       Radim Blazek

       Last changed: $Date: 2012-09-07 01:20:29 -0700 (Fri, 07 Sep 2012) $
       Main index - database index - full index