SQLite3::backup
(PHP 7 >= 7.4.0)
SQLite3::backup — Backup one database to another database
Description
public SQLite3::backup ( SQLite3 $destination_db [, string $source_dbname = "main" [, string $destination_dbname = "main" ]] ) : bool
SQLite3::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.
Parameters
-
destination_db -
A database connection opened with SQLite3::open().
-
source_dbname -
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. -
destination_dbname -
Analogous to
source_dbnamebut for thedestination_db.
Return Values
Returns true on success or false on failure.
Examples
Example #1 Backup an existing database
<?php
// $conn is a connection to an already opened sqlite3 database
$backup = new SQLite3('backup.sqlite');
$conn->backup($backup);
?>
© 1997–2020 The PHP Documentation Group
Licensed under the Creative Commons Attribution License v3.0 or later.
https://www.php.net/manual/en/sqlite3.backup.php