db-バックアップ

SET @prefix = 'wp_';
SET @suffix = DATE_FORMAT(NOW(), '%Y%m%d_%H%i%s');

-- sHub-Log custom table backups
SET @sql = CONCAT('CREATE TABLE `', @prefix, 'backup_', @suffix, '_syntaxhub_securelog_login_errors` LIKE `', @prefix, 'syntaxhub_securelog_login_errors`');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql = CONCAT('INSERT INTO `', @prefix, 'backup_', @suffix, '_syntaxhub_securelog_login_errors` SELECT * FROM `', @prefix, 'syntaxhub_securelog_login_errors`');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql = CONCAT('CREATE TABLE `', @prefix, 'backup_', @suffix, '_syntaxhub_securelog_protected_ips` LIKE `', @prefix, 'syntaxhub_securelog_protected_ips`');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql = CONCAT('INSERT INTO `', @prefix, 'backup_', @suffix, '_syntaxhub_securelog_protected_ips` SELECT * FROM `', @prefix, 'syntaxhub_securelog_protected_ips`');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql = CONCAT('CREATE TABLE `', @prefix, 'backup_', @suffix, '_syntaxhub_securelog_attack_logs` LIKE `', @prefix, 'syntaxhub_securelog_attack_logs`');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql = CONCAT('INSERT INTO `', @prefix, 'backup_', @suffix, '_syntaxhub_securelog_attack_logs` SELECT * FROM `', @prefix, 'syntaxhub_securelog_attack_logs`');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

-- sHub-Log option backups
SET @sql = CONCAT('CREATE TABLE `', @prefix, 'backup_', @suffix, '_syntaxhub_securelog_options` LIKE `', @prefix, 'options`');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql = CONCAT(
  'INSERT INTO `', @prefix, 'backup_', @suffix, '_syntaxhub_securelog_options` ',
  'SELECT * FROM `', @prefix, 'options` ',
  'WHERE option_name LIKE ''syntaxhub_securelog_%'' ',
  'OR option_name LIKE ''_transient_syntaxhub_securelog_rate_%'' ',
  'OR option_name LIKE ''_transient_timeout_syntaxhub_securelog_rate_%'''
);
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;