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
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
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
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
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
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:
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
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
8 matches
Mail list logo