PracticalBot
ربات انجمن کاربردی
- Dec 12, 2022
- 357
- 2
Less of a tutorial, more to point out another option which doesn't seem to have a mention anywhere on here yet....
I was searching for options to create a backup copy of an SQLite database. There are already options detailed
But another option that seemed quite attractive was to use VACUUM INTO, as detailed on sqlite.org at
The bit that stood out to me was;
Usage is pretty simple with the SQL library:
Backup SQLite using VACUUM INTO...:
I was searching for options to create a backup copy of an SQLite database. There are already options detailed
برای دیدن لینک ها باید ثبت نام کنید
, and
برای دیدن لینک ها باید ثبت نام کنید
, for example.But another option that seemed quite attractive was to use VACUUM INTO, as detailed on sqlite.org at
برای دیدن لینک ها باید ثبت نام کنید
The bit that stood out to me was;
It works when the database is open, with live *.wal files for example, and handily produces just a single backup file that's been shrunk to its minimum size.
Usage is pretty simple with the SQL library:
Backup SQLite using VACUUM INTO...:
کد:
محتوای بلوک کدها در دسترس شما نیست. برای مشاهده بلوک کدها، وارد انجمن شوید یاثبت نام کنید
برای دیدن لینک ها باید ثبت نام کنید
برای دیدن لینک ها باید ثبت نام کنید