[ gpsdrive ] Upgrading gpsdrive - Questions about psql vs mysql

[Guenther Meyer]

Am Samstag 18 Juli 2009 schrieb Cord Beermann:
> Hello,
>
> I'm tried to move my old (2.9?) mysql-Database with > 100000 Waypoints
> into the new database-schema of GPSdrive 2.10pre4 from Debian.
>
> There is a Script which dumps the content of the old database into a
> gpx-file and a perl-script called poi-manager for importing it.
> Running the latter leads to a 'Segementation Fault' of perl, and no
> Waypoint is inserted into the Database.
>
> Running GPSdrive 2.10pre4 doesn't show anything about the data in the
> MySQL-Database, or an indication that it tries to use the database.
>
> So, i started to look around and found that you are now on 2.10pre7
> and installed the debian-package (2.10svn2448).
>
> (btw: your versioned dependencies are broken:
> gpsdrive: gpsdrive-utils (> 2299) but 2.10svn2448 is to be installed
> same applies for openstreetmap-utils)
>
> I also want to use OSM, and in the old Debian-Package was a script
> which downloaded and inserted OSM-data in the MySQL-Database.
>
> While wading through the documentation i wondered if gpsdrive really
> needs a MySQL-Database for POIs and a Postgres for OSM.
>
> I don't want to run two databases, is it possible to have only one
> database for POIs AND OSM-data to use by gpsdrive?
>
> Which one is that and how do i have to set it up so gpsdrive
> recognizes it?
>
mysql isn't used anymore.

we have sqlite for POI data, which is part of gpsdrive.
if your gpsdrive runs, the POI database should also work.

to fill the new empty POI database with your exported data from the gpx-file 
you should use poi-import.pl, but take care, there is no dupe checking.

to use osm POI data, you have to create a sqlite poi database from a planet 
file with osm2poidb.


furthermore we make use of a postgis database to provide the osm data for the 
mapnik map rendering. this is not really needed to run gpsdrive, but can be a 
nice feature.
if you have the postgis database installed, the script mapnik-osm-updater.sh 
should do all the necessary steps to do the setup.


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.gpsdrivers.org/pipermail/gpsdrive/attachments/20090718/0bba769d/attachment.bin>