PHP: Dumping Memory sqLite Database to File

Question

i'm trying to dump a sqLite Database from memory to file (for loggin purposes) but it gives me an error.

I've tried:

conn = new SQLite3("dump.db");
$db->backup( $conn );

but it gives me an error:

Call to undefined method SQLite3::backup()

I'm using sqLite Version 3.28.0

Any idea how it would work?

Daniel W. · Accepted Answer · 2021-05-12 12:11:28Z

1

Your SQLite3 extension is old and doesn't have all the functions (SQLite3::backup has been introduced arround PHP 7.4).

As of SQLite 3.27.0 (2019-02-07), it is also possible to use the statement VACUUM INTO 'file.db'; to backup the database to a new file.

If upgrading is not an option, you can simply use copy().

answered May 12, 2021 at 12:11

Daniel W.

32.6k15 gold badges99 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1