Re: “How to back up SQLite databases the right way (not by copying them!)”
Jon Ribbens via Python-list <[email protected]> Sun, 10 May 2026 23:09:39 -0000 (UTC)
| Newsgroups | gmane.comp.python.general |
|---|---|
| Organization | A noiseless patient Spider |
| Message-ID | <[email protected]> |
T24gMjAyNi0wNS0xMCwgTGF3cmVuY2UgROKAmU9saXZlaXJvIDxsZG9AbnouaW52YWxpZD4gd3Jv dGU6Cj4gTXIgU2VyZGFyIFllZ3VsYWxwIG9jY2FzaW9ubGx5IGNvbWVzIHVwIHdpdGggdXNlZnVs IHRpdGJpdHMgb2YKPiBpbmZvcm1hdGlvbiwgYnV0IEnigJltIG5vdCBzdXJlIEnigJlkIGNvdW50 IHRoaXMgYW1vbmcgdGhlbQo+PGh0dHBzOi8vd3d3LmluZm93b3JsZC5jb20vdmlkZW8vNDE2NDQz MS9ob3ctdG8tYmFjay11cC1zcWxpdGUtZGF0YWJhc2VzLXRoZS1yaWdodC13YXktbm90LWJ5LWNv cHlpbmctdGhlbS5odG1sPi4KPgo+IERvZXMgYW55Ym9keSBlbHNlIHVzZSBTUUxpdGXigJlzIGJh Y2t1cCBBUEk/IEnigJl2ZSBuZXZlciBib3RoZXJlZCwKPiBiZWNhdXNlIFNRTGl0ZSBpcyBhIHNp bmdsZS11c2VyIERCTVMuIFRvIGJhY2t1cCBhIGRhdGFiYXNlLCBJIGp1c3QKPiBzaHV0IGRvd24g dGhlIHByb2dyYW0gYWNjZXNzaW5nIGl0LCBhbmQgZG8gYSByZWd1bGFyIGZpbGUgY29weSBvbiB0 aGUKPiBkYXRhYmFzZSBmaWxlLiBTaW1wbGUuCgpZb3UgZG9uJ3QgZXZlbiBuZWVkIHRvIGRvIHRo YXQgLSBqdXN0IGxvY2sgdGhlIGRhdGFiYXNlIGR1cmluZyB0aGUgY29weS4KRm9yIG1vc3QgU1FM aXRlIGluc3RhbmNlcyB3aGVyZSB0aGUgZGF0YSBpcyBzbWFsbCB0aGUgZHVyYXRpb24gb2YgdGhl CmxvY2sgd291bGQgcHJvYmFibHkgYmUgYmFyZWx5IG5vdGljZWFibGUuCgo+IEkgdGhpbmsgdGhl IGJhY2t1cCBBUEkgbWlnaHQgYmUgdXNlZnVsIGZyb20gd2l0aGluIHRoZSBhcHAgYWNjZXNzaW5n Cj4gdGhlIGRhdGFiYXNlIGl0c2VsZiwgdG8gcHJvdmlkZSBpdHMgb3duIGJhY2t1cCBmdW5jdGlv biB3aGlsZSBpdCBpcwo+IHN0aWxsIHJ1bm5pbmcuIEFnYWluLCBub3Qgc29tZXRoaW5nIEnigJl2 ZSBmZWx0IG11Y2ggbmVlZCBmb3I7IGluIG15Cj4gZXhwZXJpZW5jZSwgbG9uZy1ydW5uaW5nIHNl cnZpY2Utc3R5bGUgYXBwcyB0ZW5kIHRvIHVzZSBtdWx0aXVzZXIKPiBEQk1TZXMsIHdoaWNoIGNh biBoYW5kbGUgbXVsdGlwbGUgc2ltdWx0YW5lb3VzIGNvbm5lY3Rpb25zIHdpdGhvdXQKPiB0aGlu Z3MgZ2V0dGluZyBjb25mdXNlZC4gQW5kIGJhY2tpbmcgdGhlbSB1cCBpcyBlYXNpbHkgZG9uZSBi eSBtYWtpbmcKPiB5ZXQgYW5vdGhlciBjb25uZWN0aW9uIGZyb20gYSBkYXRhYmFzZSBkdW1wIHV0 aWxpdHksIHVzdWFsbHkgcHJvdmlkZWQKPiBhcyBwYXJ0IG9mIHRoZSBEQk1TIHBhY2thZ2UuCgpU aGV5IGV4cGxhaW4gd2h5IHRoZSBiYWNrdXAgQVBJIGV4aXN0cyBoZXJlOgoKaHR0cHM6Ly9zcWxp dGUub3JnL2JhY2t1cC5odG1sCgogICogQW55IGRhdGFiYXNlIGNsaWVudHMgd2lzaGluZyB0byB3 cml0ZSB0byB0aGUgZGF0YWJhc2UgZmlsZSB3aGlsZSBhCiAgICBiYWNrdXAgaXMgYmVpbmcgY3Jl YXRlZCBtdXN0IHdhaXQgdW50aWwgdGhlIHNoYXJlZCBsb2NrIGlzCiAgICByZWxpbnF1aXNoZWQu CiAgKiBJdCBjYW5ub3QgYmUgdXNlZCB0byBjb3B5IGRhdGEgdG8gb3IgZnJvbSBpbi1tZW1vcnkg ZGF0YWJhc2VzLgogICogSWYgYSBwb3dlciBmYWlsdXJlIG9yIG9wZXJhdGluZyBzeXN0ZW0gZmFp bHVyZSBvY2N1cnMgd2hpbGUgY29weWluZwogICAgdGhlIGRhdGFiYXNlIGZpbGUgdGhlIGJhY2t1 cCBkYXRhYmFzZSBtYXkgYmUgY29ycnVwdGVkIGZvbGxvd2luZwogICAgc3lzdGVtIHJlY292ZXJ5 LgoKSSBtdXN0IGFkbWl0IEkgZG9uJ3QgdW5kZXJzdGFuZCB0aGUgbGFzdCBvbmUgLSBhIHBvd2Vy IGZhaWx1cmUgZHVyaW5nCnRoZSBiYWNrdXAgd291bGQgYmUgaW5jcmVkaWJseSByYXJlLCBhbmQg aWYgaXQgaGFwcGVucywganVzdCByZS1kbyB0aGUKYmFja3VwIGFnYWluLiAoT2J2aW91c2x5IHlv dSB3b3VsZG4ndCBvdmVyd3JpdGUgdGhlIHByZXZpb3VzIGJhY2t1cAp3aXRoIHRoZSBuZXcgYmFj a3VwLCBpbiBjYXNlIHRoZSBwcmltYXJ5IGRhdGFiYXNlIGRpZWQgZHVyaW5nIHRoZQpiYWNrdXAu KQotLSAKaHR0cHM6Ly9tYWlsLnB5dGhvbi5vcmcvbWFpbG1hbjMvL2xpc3RzL3B5dGhvbi1saXN0 LnB5dGhvbi5vcmcK