Re: [sqlite] archive of database

2014-08-10 Thread Levente Kovacs
Simon, Tony, Thank you very mucj r your answer! It was helpful. All the best! 73 de HA5OGL -- Levente Kovacs CTO, CSO http://levente.logonex.eu ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] archive of database

2014-08-09 Thread Tony Papadimitriou
to convert the binary to a compatible format is not necessarily a trivial job, assuming you no longer have access to the needed version of SQLite. -Original Message- From: Levente Kovacs Sent: Saturday, August 09, 2014 2:18 PM To: sqlite-users@sqlite.org Subject: [sqlite] archive

Re: [sqlite] archive of database

2014-08-09 Thread Simon Slavin
On 9 Aug 2014, at 12:18pm, Levente Kovacs wrote: > I mean... is SQLite designed to support the move of the sqlite file? Yes. If the database was closed properly, all your data is in one file. SQLite does not care where file is: you can move it from one folder or disk

[sqlite] archive of database

2014-08-09 Thread Levente Kovacs
Dear List, Is it a recommended method to archive or copy a database just copying the sqlite file, or should I make a dump of the database, and move the SQL statements? I mean... is SQLite designed to support the move of the sqlite file? What if a new version of the library comes out? Will it be

Re: [sqlite] Archive SQLite Database?

2013-01-09 Thread Michael Black
You can also just copy the entire file (best to do when app is not running). So you'd only be down for as long as it takes to copy it. If your database is updated frequently .backup may never finish. Then you can archive from the copy and delete the archived rows from the active DB in a

Re: [sqlite] Archive SQLite Database?

2013-01-09 Thread Simon Slavin
On 8 Jan 2013, at 2:05pm, "Jimmy Martin" wrote: >I have recently taken over a position that uses a SQLite > database. The database is currently 24GB and running extremely slow. Your best friend here might be the SQLite shell tool:

Re: [sqlite] Archive SQLite Database?

2013-01-09 Thread Michael Black
lto:sqlite-users-boun...@sqlite.org] On Behalf Of Jimmy Martin Sent: Tuesday, January 08, 2013 8:05 AM To: sqlite-users@sqlite.org Subject: [sqlite] Archive SQLite Database? Hello, I have recently taken over a position that uses a SQLite database. The database is currently 24GB a

[sqlite] Archive SQLite Database?

2013-01-09 Thread Jimmy Martin
Hello, I have recently taken over a position that uses a SQLite database. The database is currently 24GB and running extremely slow. Is there a quick way to archive data and free-up some space? Also, are there any risks to running the "vacuum" command...such as losing data? I