[GRASS-user] Database question

Adam Dershowitz, Ph.D., P.E. adershowitz at exponent.com
Mon Oct 25 14:40:45 EDT 2010


Thanks.  That is just what I needed!
(There was still a little trick that the first time I used it I used the whole path to the old db, instead of just sqlite.db.  The path failed, while just the file name worked)



--Adam



On Oct 25, 2010, at 11:30 AM, Achim Kisseler wrote:

> Hi,
> 
> try "v.db.reconnect.all" or "v.db.connect" for single vector layers.
> 
> Achim
> 
> Am 25.10.2010 18:54, schrieb Adam Dershowitz, Ph.D., P.E.:
>> This seems like it must be really easy and I am just missing something....
>> I have a project but I accidentally created the sqlite database file in the wrong location.
>> So, all of my project files are in one directory, but, in my home directory I have a file sqlite.db.
>> 
>> I just moving that file to where I want it.  Then I did:
>> db.connect driver=sqlite database=/NewLocation/test.db
>> 
>> Now if I do db.connect -p I see the correct path, but if I try to access a vector that uses that database I get an error "No such table".
>> If I move the file back to the old location then the error goes away, even if I don't use db.connect to point to the other location.  So, I am just missing something about how to have grass know the correct location of a database.
>> If I just move the file, how can I get the vector map to "know" the correct file to use, since db.connect is not doing the job?
>> 
>> Thanks.
>> 
>> --Adam
>> 
>> 
>> 
>> _______________________________________________
>> grass-user mailing list
>> grass-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/grass-user



More information about the grass-user mailing list