SQLite3::backup
(PHP 7 >= 7.4.0, PHP 8)
SQLite3::backup — Backup one database to another database
说明
$destination, string $sourceDatabase = "main", string $destinationDatabase = "main"): boolSQLite3::backup() copies the contents of one database into another, overwriting the contents of the destination database. It is useful either for creating backups of databases or for copying in-memory databases to or from persistent files.
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.
参数
destination-
A database connection opened with SQLite3::open().
sourceDatabase-
The database name is
"main"for the main database,"temp"for the temporary database, or the name specified after theASkeyword in anATTACHstatement for an attached database. destinationDatabase-
Analogous to
sourceDatabasebut for thedestination.
示例
示例 #1 Backup an existing database
<?php
// $conn is a connection to an already opened sqlite3 database
$backup = new SQLite3('backup.sqlite');
$conn->backup($backup);
?>