protected function MySQLiSource::_getSQLFooter in Backup and Migrate 8.4

The footer of the sql dump file.

1 call to MySQLiSource::_getSQLFooter()

MySQLiSource::exportToFile in lib/backup_migrate_core/src/Source/MySQLiSource.php

Export this source to the given temp file. This should be the main back up function for this source.

File

lib/backup_migrate_core/src/Source/MySQLiSource.php, line 238

Class

MySQLiSource

Class MySQLiSource.

Namespace

BackupMigrate\Core\Source

Code

protected function _getSQLFooter() {
  return <<<FOOTER


/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/* @TODO expose these options in config with the ability to turn on and off */
SET FOREIGN_KEY_CHECKS = 1;
COMMIT;
SET AUTOCOMMIT = 1;
FOOTER;
}