Sicherungskopien anlegen

Auch verfügbar in English, Français, Español?, Русский.


Es ist empfehlenswert regelmäßig Sicherungskopien der wichtigsten Dateien und Datenbank anzulegen. Ebenso sollte eine Sicherungskopie erstellt werden bevor ein Update durchführt wird, oder das Wiki auf einen anderen Computer übertragen werden soll.


Zu sichernde Tabellen


Zu sichernde Dateien


Zu sichernde Verzeichnisse


Add example to backup and restore WackoWiki via

  1. command line (database + files)
  2. via phpMyAdmin / Adminer and FTP

Via Admin Panel

Die Tabellen und die benutzerbezogenen Dateien können mit dem Backup- und Restore-Modul in der Systemverwaltung übertragen werden..
Die Quell- und die Zielversion von WackoWiki sollten gleich sein, ebenso wie das Tabellen-Präfix.

Datensicherung


Schritte in der Systemverwaltung

  1. Backup-Module: Führe eine Datensicherung des gesamten Wikis einschließlich der Dateien durch.
    1. Stelle sicher, dass der Ordner file/backup/ existiert und schreibbar ist.
    2. Die Datensicherung findet sich unter file/backup/[date_time].

Wiederherstellung


  1. Verschiebe den Ordner in das neu installierte Wiki und legen ihn dort an der gleichen Stelle ab, z. B. file/backup/
  2. Restore-Module: Wiederherstellung ausführen.
    1. Der Wiederherstellungsprozess kann je nach Umfang der Sicherung einige Zeit in Anspruch nehmen.

13:51:28 - Initiated Restoration
================================================
Using parameters:
	Ignore duplicated keys: No
	Ignore duplicated files: No

Saved cluster: No
	Assume DROP TABLE


13:51:28 - Restoring the structure of the table
================================================
Perform SQL-instructions:

DROP TABLE IF EXISTS `wacko_acl`;
CREATE TABLE IF NOT EXISTS `wacko_acl` (
	`page_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`privilege` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`list` text COLLATE utf8mb4_unicode_520_ci NOT NULL, 
	UNIQUE `idx_page_id` (`page_id`, `privilege`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_auth_token`;
CREATE TABLE IF NOT EXISTS `wacko_auth_token` (
	`auth_token_id` int(10) unsigned NOT NULL auto_increment,
	`selector` char(12) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`token` char(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`user_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`token_expires` datetime, 
	PRIMARY KEY (`auth_token_id`), 
	UNIQUE `idx_selector` (`selector`), 
	KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_cache`;
CREATE TABLE IF NOT EXISTS `wacko_cache` (
	`cache_id` int(10) unsigned NOT NULL auto_increment,
	`name` char(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`method` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`query` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`cache_lang` varchar(5) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`cache_time` datetime, 
	PRIMARY KEY (`cache_id`), 
	KEY `name` (`name`), 
	KEY `idx_cache_time` (`cache_time`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_config`;
CREATE TABLE IF NOT EXISTS `wacko_config` (
	`config_id` int(10) unsigned NOT NULL auto_increment,
	`config_name` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`config_value` text COLLATE utf8mb4_unicode_520_ci, 
	PRIMARY KEY (`config_id`), 
	UNIQUE `idx_config_name` (`config_name`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_category`;
CREATE TABLE IF NOT EXISTS `wacko_category` (
	`category_id` int(10) unsigned NOT NULL auto_increment,
	`parent_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`category_lang` varchar(5) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`category` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`category_description` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL, 
	PRIMARY KEY (`category_id`), 
	UNIQUE `idx_category` (`category_lang`, `category`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_category_assignment`;
CREATE TABLE IF NOT EXISTS `wacko_category_assignment` (
	`assignment_id` int(10) unsigned NOT NULL auto_increment,
	`category_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`object_type_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`object_id` int(10) unsigned DEFAULT '0' NOT NULL, 
	PRIMARY KEY (`assignment_id`), 
	UNIQUE `idx_assignment` (`category_id`, `object_type_id`, `object_id`), 
	KEY `idx_category_id` (`category_id`), 
	KEY `idx_object_id` (`object_id`), 
	KEY `idx_object_type_id` (`object_type_id`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_external_link`;
CREATE TABLE IF NOT EXISTS `wacko_external_link` (
	`link_id` int(10) unsigned NOT NULL auto_increment,
	`page_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`link` text COLLATE utf8mb4_unicode_520_ci NOT NULL, 
	PRIMARY KEY (`link_id`), 
	KEY `idx_page_id` (`page_id`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_file`;
CREATE TABLE IF NOT EXISTS `wacko_file` (
	`file_id` int(10) unsigned NOT NULL auto_increment,
	`page_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`user_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`file_name` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`file_lang` varchar(5) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`file_description` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`caption` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`author` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`source` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`source_url` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`license_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`uploaded_dt` datetime,
	`modified_dt` datetime,
	`file_size` int(10) unsigned DEFAULT '0' NOT NULL,
	`picture_w` int(10) unsigned DEFAULT '0' NOT NULL,
	`picture_h` int(10) unsigned DEFAULT '0' NOT NULL,
	`file_ext` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`mime_type` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`hits` int(10) unsigned DEFAULT '0' NOT NULL,
	`deleted` tinyint(1) unsigned DEFAULT '0',
	`converted` tinyint(1) unsigned DEFAULT '0' NOT NULL, 
	PRIMARY KEY (`file_id`), 
	UNIQUE `idx_page_id` (`page_id`, `file_name`), 
	KEY `idx_page_id_2` (`page_id`, `uploaded_dt`), 
	KEY `idx_deleted` (`deleted`), 
	KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_file_link`;
CREATE TABLE IF NOT EXISTS `wacko_file_link` (
	`file_link_id` int(10) unsigned NOT NULL auto_increment,
	`page_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`file_id` int(10) unsigned DEFAULT '0' NOT NULL, 
	PRIMARY KEY (`file_link_id`), 
	KEY `idx_page_id` (`page_id`), 
	KEY `idx_file_id` (`file_id`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_log`;
CREATE TABLE IF NOT EXISTS `wacko_log` (
	`log_id` int(10) unsigned NOT NULL auto_increment,
	`log_time` datetime,
	`level` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`user_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`ip` varchar(15) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`message` text COLLATE utf8mb4_unicode_520_ci NOT NULL, 
	PRIMARY KEY (`log_id`), 
	KEY `idx_level` (`level`), 
	KEY `idx_user_id` (`user_id`), 
	KEY `idx_ip` (`ip`), 
	KEY `idx_time` (`log_time`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_menu`;
CREATE TABLE IF NOT EXISTS `wacko_menu` (
	`menu_id` int(10) unsigned NOT NULL auto_increment,
	`user_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`page_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`menu_lang` varchar(5) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`menu_title` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`menu_position` smallint(2) unsigned DEFAULT '0' NOT NULL, 
	PRIMARY KEY (`menu_id`), 
	UNIQUE `idx_user_id` (`user_id`, `page_id`, `menu_lang`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_page`;
CREATE TABLE IF NOT EXISTS `wacko_page` (
	`page_id` int(10) unsigned NOT NULL auto_increment,
	`version_id` int(10) unsigned DEFAULT '1' NOT NULL,
	`owner_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`user_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`title` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`tag` varchar(250) COLLATE utf8mb4_bin NOT NULL,
	`menu_tag` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`depth` int(10) unsigned DEFAULT '0' NOT NULL,
	`parent_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`created` datetime,
	`modified` datetime,
	`body` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`body_r` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`body_toc` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`formatting` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'wacko' NOT NULL,
	`edit_note` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`minor_edit` tinyint(1) unsigned DEFAULT '0',
	`page_size` int(10) unsigned DEFAULT '0' NOT NULL,
	`license_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`reviewed` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`reviewed_time` datetime,
	`reviewer_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`ip` varchar(15) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`latest` tinyint(1) unsigned DEFAULT '1',
	`handler` varchar(30) COLLATE utf8mb4_unicode_520_ci DEFAULT 'page' NOT NULL,
	`comment_on_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`comments` int(4) unsigned DEFAULT '0' NOT NULL,
	`files` int(4) unsigned DEFAULT '0' NOT NULL,
	`revisions` int(10) unsigned DEFAULT '0' NOT NULL,
	`hits` int(10) unsigned DEFAULT '0' NOT NULL,
	`theme` varchar(20) COLLATE utf8mb4_unicode_520_ci,
	`page_lang` varchar(5) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`commented` datetime,
	`description` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`keywords` varchar(250) COLLATE utf8mb4_bin NOT NULL,
	`footer_comments` tinyint(1) unsigned,
	`footer_files` tinyint(1) unsigned,
	`footer_rating` tinyint(1) unsigned,
	`hide_toc` tinyint(1) unsigned,
	`hide_index` tinyint(1) unsigned,
	`tree_level` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`show_menu_tag` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`allow_rawhtml` tinyint(1) unsigned,
	`disable_safehtml` tinyint(1) unsigned,
	`noindex` tinyint(1) unsigned DEFAULT '0',
	`deleted` tinyint(1) unsigned DEFAULT '0',
	`converted` tinyint(1) unsigned DEFAULT '0' NOT NULL, 
	PRIMARY KEY (`page_id`), 
	UNIQUE `idx_tag` (`tag`), 
	KEY `idx_user_id` (`user_id`), 
	KEY `idx_owner_id` (`owner_id`), 
	KEY `idx_depth` (`depth`), 
	KEY `idx_created` (`created`), 
	KEY `idx_modified` (`modified`), 
	KEY `idx_minor_edit` (`minor_edit`), 
	KEY `idx_deleted` (`deleted`), 
	KEY `idx_reviewed` (`reviewed`), 
	KEY `idx_comment_on_id` (`comment_on_id`), 
	KEY `idx_commented` (`commented`), 
	KEY `idx_title` (`title`), 
	FULLTEXT KEY `body` (`body`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_page_link`;
CREATE TABLE IF NOT EXISTS `wacko_page_link` (
	`link_id` int(10) unsigned NOT NULL auto_increment,
	`from_page_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`to_page_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`to_tag` varchar(250) COLLATE utf8mb4_bin NOT NULL, 
	PRIMARY KEY (`link_id`), 
	KEY `idx_from_tag` (`from_page_id`, `to_tag`(78)), 
	KEY `idx_from_page_id` (`from_page_id`), 
	KEY `idx_to` (`to_tag`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_poll`;
CREATE TABLE IF NOT EXISTS `wacko_poll` (
	`poll_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`v_id` tinyint(3) unsigned DEFAULT '0' NOT NULL,
	`text` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`user_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`plural` tinyint(1) DEFAULT '0' NOT NULL,
	`votes` smallint(5) unsigned DEFAULT '0' NOT NULL,
	`start` datetime,
	`end` datetime, 
	KEY `idx_poll_id` (`poll_id`), 
	KEY `idx_time_frame` (`start`, `end`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_rating`;
CREATE TABLE IF NOT EXISTS `wacko_rating` (
	`page_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`value` int(11) DEFAULT '0' NOT NULL,
	`voters` int(10) unsigned DEFAULT '0' NOT NULL,
	`rating_time` datetime, 
	PRIMARY KEY (`page_id`), 
	KEY `idx_voters_rate` (`voters`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_referrer`;
CREATE TABLE IF NOT EXISTS `wacko_referrer` (
	`referrer_id` int(10) unsigned NOT NULL auto_increment,
	`page_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`referrer` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`referrer_time` datetime,
	`ip` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`user_agent` varchar(150) COLLATE utf8mb4_unicode_520_ci NOT NULL, 
	PRIMARY KEY (`referrer_id`), 
	KEY `idx_page_id` (`page_id`), 
	KEY `idx_referrer_time` (`referrer_time`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_revision`;
CREATE TABLE IF NOT EXISTS `wacko_revision` (
	`revision_id` int(10) unsigned NOT NULL auto_increment,
	`page_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`version_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`owner_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`user_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`title` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`tag` varchar(250) COLLATE utf8mb4_bin NOT NULL,
	`menu_tag` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`created` datetime,
	`modified` datetime,
	`body` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`body_r` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`formatting` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`edit_note` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`minor_edit` tinyint(1) unsigned DEFAULT '0',
	`page_size` int(10) unsigned DEFAULT '0' NOT NULL,
	`reviewed` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`reviewed_time` datetime,
	`reviewer_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`latest` tinyint(1) unsigned DEFAULT '0',
	`ip` varchar(15) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`handler` varchar(30) COLLATE utf8mb4_unicode_520_ci DEFAULT 'page' NOT NULL,
	`comment_on_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`page_lang` varchar(5) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`description` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`keywords` varchar(250) COLLATE utf8mb4_bin NOT NULL,
	`deleted` tinyint(1) unsigned DEFAULT '0',
	`converted` tinyint(1) unsigned DEFAULT '0' NOT NULL, 
	PRIMARY KEY (`revision_id`), 
	KEY `idx_page_id` (`page_id`), 
	KEY `idx_version_id` (`version_id`), 
	KEY `idx_owner_id` (`owner_id`), 
	KEY `idx_user_id` (`user_id`), 
	KEY `idx_tag` (`tag`), 
	KEY `idx_modified` (`modified`), 
	KEY `idx_minor_edit` (`minor_edit`), 
	KEY `idx_deleted` (`deleted`), 
	KEY `idx_reviewed` (`reviewed`), 
	KEY `idx_comment_on_id` (`comment_on_id`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_user`;
CREATE TABLE IF NOT EXISTS `wacko_user` (
	`user_id` int(10) unsigned NOT NULL auto_increment,
	`user_name` varchar(80) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`real_name` varchar(80) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`password` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`email` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`account_status` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`account_type` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`enabled` tinyint(1) unsigned DEFAULT '1' NOT NULL,
	`signup_time` datetime,
	`change_password` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`user_ip` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`email_confirm` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`last_visit` datetime,
	`last_mark` datetime,
	`login_count` int(10) unsigned DEFAULT '0' NOT NULL,
	`lost_password_request_count` smallint(6) unsigned DEFAULT '0' NOT NULL,
	`failed_login_count` smallint(6) unsigned DEFAULT '0' NOT NULL,
	`total_pages` int(10) unsigned DEFAULT '0' NOT NULL,
	`total_revisions` int(10) unsigned DEFAULT '0' NOT NULL,
	`total_comments` int(10) unsigned DEFAULT '0' NOT NULL,
	`total_uploads` int(10) unsigned DEFAULT '0' NOT NULL, 
	PRIMARY KEY (`user_id`), 
	UNIQUE `idx_user_name` (`user_name`), 
	KEY `idx_account_type` (`account_type`), 
	KEY `idx_enabled` (`enabled`), 
	KEY `idx_signup_time` (`signup_time`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_user_setting`;
CREATE TABLE IF NOT EXISTS `wacko_user_setting` (
	`setting_id` int(10) unsigned NOT NULL auto_increment,
	`user_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`theme` varchar(20) COLLATE utf8mb4_unicode_520_ci,
	`user_lang` varchar(5) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`list_count` int(10) unsigned DEFAULT '50' NOT NULL,
	`menu_items` int(2) unsigned DEFAULT '5' NOT NULL,
	`dont_redirect` tinyint(1) unsigned,
	`send_watchmail` tinyint(1) unsigned,
	`show_files` tinyint(1) unsigned,
	`show_comments` tinyint(1) unsigned DEFAULT '1' NOT NULL,
	`doubleclick_edit` tinyint(1) unsigned DEFAULT '1' NOT NULL,
	`show_spaces` tinyint(1) unsigned DEFAULT '1' NOT NULL,
	`typografica` tinyint(1) unsigned DEFAULT '1' NOT NULL,
	`autocomplete` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`numerate_links` tinyint(1) unsigned DEFAULT '1' NOT NULL,
	`diff_mode` tinyint(1) unsigned DEFAULT '2' NOT NULL,
	`notify_minor_edit` tinyint(1) unsigned DEFAULT '1' NOT NULL,
	`notify_page` tinyint(1) unsigned DEFAULT '2' NOT NULL,
	`notify_comment` tinyint(1) unsigned DEFAULT '1' NOT NULL,
	`allow_intercom` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`allow_massemail` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`hide_lastsession` tinyint(1) unsigned,
	`validate_ip` tinyint(1) unsigned,
	`noid_pubs` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`session_length` tinyint(3) unsigned,
	`timezone` decimal(5,2) DEFAULT '0.00' NOT NULL,
	`dst` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`sorting_comments` tinyint(1) unsigned DEFAULT '0' NOT NULL, 
	PRIMARY KEY (`setting_id`), 
	UNIQUE `idx_user_id` (`user_id`), 
	KEY `idx_send_watchmail` (`send_watchmail`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_usergroup`;
CREATE TABLE IF NOT EXISTS `wacko_usergroup` (
	`group_id` int(10) unsigned NOT NULL auto_increment,
	`group_name` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`description` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
	`moderator_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`created` datetime,
	`is_system` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`open` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`active` tinyint(1) unsigned DEFAULT '0' NOT NULL, 
	PRIMARY KEY (`group_id`), 
	UNIQUE `idx_name` (`group_name`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_usergroup_member`;
CREATE TABLE IF NOT EXISTS `wacko_usergroup_member` (
	`group_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`user_id` int(10) unsigned DEFAULT '0' NOT NULL, 
	UNIQUE `idx_group_id` (`group_id`, `user_id`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
DROP TABLE IF EXISTS `wacko_watch`;
CREATE TABLE IF NOT EXISTS `wacko_watch` (
	`watch_id` int(10) unsigned NOT NULL auto_increment,
	`user_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`page_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`comment_id` int(10) unsigned DEFAULT '0' NOT NULL,
	`pending` tinyint(1) unsigned DEFAULT '0' NOT NULL,
	`watch_time` datetime, 
	PRIMARY KEY (`watch_id`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;


13:51:41 - Completed. Processed instructions: 44


13:51:41 - Restore the contents of tables
================================================
Just download and process tables dump
(Instruction INSERT):

	13:51:41 - wacko_acl
	==========================
		records:   490

	13:52:03 - wacko_auth_token
	==========================
		records:   1

	13:52:03 - wacko_cache
	==========================
		records:   0

	13:52:03 - wacko_config
	==========================
		records:   198

	13:52:13 - wacko_category
	==========================
		records:   4

	13:52:13 - wacko_category_assignment
	==========================
		records:   4

	13:52:13 - wacko_external_link
	==========================
		records:   16

	13:52:14 - wacko_file
	==========================
		records:   18

	13:52:15 - wacko_file_link
	==========================
		records:   14

	13:52:16 - wacko_log
	==========================
		records:   1397

	13:53:25 - wacko_menu
	==========================
		records:   76

	13:53:30 - wacko_page
	==========================
		records:   98

	13:53:35 - wacko_page_link
	==========================
		records:   57

	13:53:41 - wacko_poll
	==========================
		records:   0

	13:53:41 - wacko_rating
	==========================
		records:   0

	13:53:41 - wacko_referrer
	==========================
		records:   0

	13:53:41 - wacko_revision
	==========================
		records:   490

	13:54:07 - wacko_user
	==========================
		records:   9

	13:54:07 - wacko_user_setting
	==========================
		records:   7

	13:54:08 - wacko_usergroup
	==========================
		records:   3

	13:54:08 - wacko_usergroup_member
	==========================
		records:   1

	13:54:08 - wacko_watch
	==========================
		records:   78

13:54:13 - Completed. Total entries: 2961


13:54:13 - Restoring files
================================================
Decompress and store the contents of directories
(homonymic files: replace):

	13:54:13 - file/global
	==========================
		File: 11
		restored: 11
		skipped: 0

	13:54:13 - file/perpage
	==========================
		File: 8
		restored: 8
		skipped: 0

13:54:13 - Completed. Total files:
	all: 19
	restored: 19
	skipped: 0


================================================
13:54:13 - RESTORATION COMPLETED