How to vacuum sqlite database?

Question

I want to know how to vacuum sqlite database. I tried a syntax MANUAL VACUUM command for the whole database from command prompt:

 $sqlite3 database_name "VACUUM;";

But it's giving error as:

near "database_name": syntax error.

and also AUTO VACUUM:

PRAGMA auto_vacuum = INCREMENTAL;

And tried it for a particular table as:

VACUUM table_name;

But no result.

score 36 · Answer 1 · edited Dec 24 '17 at 04:09

36

You don't to specify the table name in the syntax. Only VACUUM works.

Also, it will clean the main database only and not any attached database files.

For more info, refer to the SQLite documentation.

edited Dec 24 '17 at 04:09

vqdave

2,361
1
18
36

answered Aug 08 '13 at 13:27

SHANK

2,978
23
31

1

this page suggests that its possible on the table http://www.tutorialspoint.com/sqlite/sqlite_vacuum.htm – Vihaan Verma Nov 26 '14 at 07:08
1

`VACUUM` from sqlite3 command line will only VACUUM main database. Attached databases can be VACUUMED only from sqlite3 verison `version 3.15.0`. For older versions, database name *must* be specified, this works from `bash` as mentioned in @yöliitäjä answer: `$sqlite3 database_name 'VACUUM;'` – Arnis Juraga Feb 19 '18 at 17:52
@VihaanVerma: It seems vacuuming tables not supported (on my SQLite v3.35.5 at least). When I run `VACUUM MyTable` it fails with message `Execution finished with errors. Result: unknown database MyTable`. – Mustafa Özçetin Aug 03 '23 at 11:34

score 26 · Answer 2 · edited Jan 11 '21 at 15:21

26

Give the command like this:

$sqlite3 database_name 'VACUUM;'

As a matter of fact, this is the way to do also other queries from command line:

$sqlite3 database_name 'select * from tablename;'

You can use the full path to the db:

$sqlite3 /path/to/db/foo.db 'VACUUM;'

edited Jan 11 '21 at 15:21

StayOnTarget

11,743
10
52
81

answered Jan 24 '18 at 11:14

yöliitäjä

261
3
3

score 19 · Answer 3 · answered Nov 02 '18 at 15:10

19

Run the command:

VACUUM;

if you use DB Browser for Sqlite or

open Sqlite from command prompt:

cd C:\your_folder
C:\Users\your_user\AppData\Local\Android\Sdk\platform-tools\sqlite3.exe  -line your_db_name.db

and run

VACUUM;

answered Nov 02 '18 at 15:10

live-love

48,840
22
240
204

score 0 · Answer 4 · answered Mar 27 '23 at 21:39

0

Do double-click on the database file, it will run directly in the command line. Then just type VACUUM;

answered Mar 27 '23 at 21:39

Ariel

157
1
4
18

score 0 · Answer 5 · answered Aug 03 '23 at 09:59

0

With DB Browser for SQLite it is trivial. Open your database file with DB Browser for SQLite and execute the VACUUM command in the Execute SQL tab (Either press F5 or click the Execute button):

answered Aug 03 '23 at 09:59

Mustafa Özçetin

1,893
1
14
16

How to vacuum sqlite database?

5 Answers5

Linked