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 #522
    In the 522nd issue of ProcessWire Weekly we'll check out the latest core updates, introduce a new module called File Mover, and more. Read on!
    Weekly.pw / 11 May 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

“We were really happy to build our new portfolio website on ProcessWire! We wanted something that gave us plenty of control on the back-end, without any bloat on the front end - just a nice, easy to access API for all our content that left us free to design and build however we liked.” —Castus, web design agency in Sheffield, UK