Of course, the command is *sqlite3* and it is even included with SSODS.

/volume1/SSODS/bin/sqlite3 /volume1/SSODS/var/cache/.slimserversql.db

should open a console to the databse (i may be wrong with the path to
the database file above, i don't remember it..).

Then you can issue all usual SQL commands. See www.sqlite.org ->
Documentation for a complete reference of SQL commands understood by
sqlite3.

You can also transfer the database file to another computer and use it
there. There are even ODBC and JDBC drivers for Sqlite! And there exist
some GUI tools, at least for windows. See sqlite.org.

flip


Edit: This single file _is_ the whole database. So just backup this
file. Or if you prefer ASCII, dump the database to a file, e.g. with:

echo ".dump" | sqlite3 databasefilename > databasedump.sql

With some modifications (mainly quoting) this file can then be imported
into any other SQL database (postgresql, mysql etc.).


-- 
flipflip

Check out flipflip's 'SlimServer On DiskStation (SSODS)'
(http://oinkzwurgl.org/software/ssods/)!
------------------------------------------------------------------------
flipflip's Profile: http://forums.slimdevices.com/member.php?userid=5223
View this thread: http://forums.slimdevices.com/showthread.php?t=28743

_______________________________________________
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/discuss

Reply via email to