Rechercher une page de manuel
grass-mesql.1grass
Langue: en
Version: 336181 (ubuntu - 24/10/10)
Section: 1 (Commandes utilisateur)
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 informations about supported data types and indexes see the documentation for MySQL (mysql) driverDatabase 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 GISCredits
Development of the driver was sponsored by Faunalia (Italy) as part of a project for ATAC.AUTHOR
Radim BlazekLast changed: $Date: 2007-10-28 22:03:29 +0100 (dom, 28 ott 2007) $
Help Index
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre