[GRASS-dev] db.copy gives error

[Paulo van Breugel]

On Tue, Mar 24, 2020 at 10:24 AM Luca Delucchi <lucadeluge at gmail.com> wrote:
>
> On Sat, 14 Mar 2020 at 15:27, Paulo van Breugel <p.vanbreugel at gmail.com> wrote:
> >
> > Dear devs,
> >
>
> Dear Paulo,
>
> > I have a grassgis database with in the mapset 'Permanent' a table
> > 'vegetation_lookup'. I want top copy this table to the current mapset.
> > The following used to work I think, but now gives me some errors:
> >
> > db.copy from_driver=sqlite
> > from_database=/media/grassdb/biodiv/PERMANENT/sqlite/sqlite.db
> > from_table=vegetation_lookup to_driver=sqlite
> > to_database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db
> > to_table=vegetation_lookup
> >
> > ERROR: Unable to create directory '///sqlite' for sqlite database
> > dbmi: Protocol error
> > WARNING: Unable to open database <///sqlite/sqlite.db> by driver <sqlite>
> >
> > Any idea what I am doing wrong here?
> >
>
> try to protect the to_database string value like
> '$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db' otherwise the
> variable are replaced with empty value

OK, will try that, thanks.

>
> > With kind regards,
> >
> > Paulo
> >
>
> --
> ciao
> Luca
>
> www.lucadelu.org