-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 12/17/2010 03:30 AM, Fabio Spadaro wrote: > I use Python's sqlite3. > it is possible to backup a database without > use the copy command file?
The pysqlite/sqlite3 module does not provide the backup API functionality, nor is its "dumper" that provides SQL mapping to the data in the database complete. Backup functionality has been added to the pysqlite developer source but there hasn't been a release of that yet, and who knows how long it will take to appear in the various Python sqlite3 modules. The APSW Python SQLite wrapper does provide both the backup API and a dumper that provides complete output. It also has a shell that you can extend from Python. (Disclosure: I am the APSW author.) http://apidoc.apsw.googlecode.com/hg/backup.html http://apidoc.apsw.googlecode.com/hg/shell.html Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk0OAJQACgkQmOOfHg372QTTDgCgs5jZYGSQDOabLV+6hGco4YoS q9YAoJbW47TC7oQnH88TZzqjBFOpnnw5 =Gz18 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users