[GRASS-user] change sqlite.db problems

[Rich Shepard]

On Fri, 13 Jul 2012, Johannes Radinger wrote:

> any suggestions?
> What Is the best way to reset the database without destroying it...?

Johannes,

   I would work directly with sqlite3. From the command line, 'sqlite3
<databasename>' will open the database editor. You can use the .h (help)
command to see the tools available to you. For example, .tab will show you a
list of tables and .schema shows the schema of a specified table.

   The location of the database should not be embedded within it. Copying the
database to the new location may work. Or, you can dump it to an ASCII file
at the old location and re-create it in the new location.

HTH,

Rich