<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>GRASS-MySQL embedded driver</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="grassdocs.css" type="text/css">
</head>
<body bgcolor="white">
<img src="grass_logo.png" alt="GRASS logo"><hr align=center size=6 noshade>
<h1>MySQL embedded driver in GRASS</h1>
MySQL database driver in GRASS enables GRASS to store vector
attributes in MySQL embedded database without necessity
to run MySQL server.
<p>
<h2>Driver and database name</h2>
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:
<ul>
<li> $GISDBASE - path to current GISBASE
<li> $LOCATION_NAME - name of current location
<li> $MAPSET - name of current mapset
</ul>
<p>
Examples of connection parameters:
<pre>
db.connect driver=mesql database='$GISDBASE/$LOCATION_NAME/$MAPSET/mysql'
db.connect driver=mesql database=/home/user1/db
</pre>
<h2>Data types, indexes</h2>
For more informations about supported data types and indexes
see the documentation for
<a href="grass-mysql.html">MySQL (mysql) driver</a>
<h2>Database type</h2>
Because database closing was found very slow if InnoDB was used,
the InnoDB storage is disabled by default (hardcoded
'--skip-innodb' server option).
<h2>Note</h2>
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.
<h2>SEE ALSO</h2>
<em>
<a HREF="db.connect.html">db.connect</a>,
<a HREF="sql.html">SQL support in GRASS GIS</a></em>
<h2>Credits</h2>
Development of the driver was sponsored by
<a href="http://www.faunalia.it">Faunalia</a> (Italy)
as part of a project for <a href="http://www.atac.roma.it/">ATAC</a>.
<H2>AUTHOR</H2>
Radim Blazek
<p><i>Last changed: $Date: 2007-10-28 22:04:00 +0100 (Sun, 28 Oct 2007) $</i>
<HR>
<BR><a href=index.html>Help Index</a>
</body>
</html>
