WireDatabaseBackup::restoreMerge() method

Restore from 2 SQL files while resolving table differences (think of it as array_merge for a DB restore)

The CREATE TABLE and INSERT statements in filename2 take precedence of those in filename1. INSERT statements from both will be executed, with filename2 INSERTs updating those of filename1. CREATE TABLE statements in filename1 won't be executed if they also exist in filename2.

This method assumes both files follow the SQL dump format created by this class.

Usage

$bool = $backup->restoreMerge(string $filename1, string $filename2, array $options);

Arguments

NameType(s)Description
filename1string

Original filename

filename2string

Filename that may have statements that will update/override those in filename1

optionsarray

Return value

bool

True on success, false on fail.

Exceptions

Method can throw exceptions on error:

  • \Exception or WireException - if $options['haltOnErrors'] == true.


$backup methods and properties

API reference based on ProcessWire core version 3.0.236

Latest news

  • ProcessWire Weekly #518
    The 518th issue of ProcessWire Weekly brings in all the latest news from the ProcessWire community. Modules, sites, and more. Read on!
    Weekly.pw / 13 April 2024
  • ProFields Table Field with Actions support
    This week we have some updates for the ProFields table field (FieldtypeTable). These updates are primarily focused on adding new tools for the editor to facilitate input and management of content in a table field.
    Blog / 12 April 2024
  • Subscribe to weekly ProcessWire news

“ProcessWire is like a breath of fresh air. So powerful yet simple to build with and customise, and web editors love it too.” —Margaret Chatwin, Web developer