Re: [sqlite] Does or will Sqlite provide a DUMP mechanism?
It should be easy to write your own dump feature. The table create statements are saved in sqlite_master, and likewise for the schema. Without looking at the code for sqlite3 (the command line utility) or tksqlite, I would bet that is how they implement their dump feature. On Mon, Mar 3, 2008 at 11:53 AM, Dennis Cote <[EMAIL PROTECTED]> wrote: > Abshagen, Martin RD-AS2 wrote: > > Can a backup mechanism be implemented by means of the current Sqlite-API? > > Well, no, but the database is a single file, so you can back it up by > copying the file. > > If you are concerned about other processes accessing the database while > you are copying it, have your program start an exclusive transaction > before the copy,and roll it back after the copy. > > HTH > Dennis Cote > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Does or will Sqlite provide a DUMP mechanism?
Abshagen, Martin RD-AS2 wrote: > Can a backup mechanism be implemented by means of the current Sqlite-API? Well, no, but the database is a single file, so you can back it up by copying the file. If you are concerned about other processes accessing the database while you are copying it, have your program start an exclusive transaction before the copy,and roll it back after the copy. HTH Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Does or will Sqlite provide a DUMP mechanism?
Hello all, I am new to Sqlite and I would like to backup Sqlite databases at runtime. Appearently Sqlite does not (yet?) provide a functionality such as mysqlhotcopy. My questions are: Can a backup mechanism be implemented by means of the current Sqlite-API? And if not so: Does anybody plan to add a dump functionality within the next one or two years? Best regards, Martin Abshagen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users