Backup and Restore

Also available in Deutsch, Français, Español?, Русский.



Add example to backup and restore WackoWiki via

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

1. Via Command Line

1.1. Backup


To back up just the application database, create a dump file using the mysqldump tool. In this example, the database is named wacko_db; replace this with the name of the database you wish to export.


 $ mysqldump -u root -p wacko_db > backup.sql

To back up all the databases, use this command instead:


 $ mysqldump -A -u root -p > backup.sql

This operation could take some time depending on the database sizes.


The steps previously described will only back up the data contained inside your databases. There may be other files that you should take into account when performing a full backup, such as files that may have been uploaded to your application. Refer to your application’s documentation for more details.

1.2. Restore


Once you have the backup file, you can restore the data with a command like the one below:


 $ mysql -u root -p < backup.sql

To restore the data to a specific database, include the database name in the command, as shown below. For example, to import the data to a database named wacko_db, use this command:


 $ mysql -u root -p -D wacko_db < backup.sql

2. Via Admin Panel

You can transfer the tables and the user related files with the Backup and Restore module in the Admin panel.
The source and the target version of WackoWiki should be the same as well as the table prefix.

2.1. Backup


Steps in Admin panel

  1. Backup module: Run an backup of the entire wiki including the files.
    1. ensure that the folder file/backup/ exists and is writable
    2. The backup is stored under file/backup/[date_time].

2.2. Restore


  1. Move the folder to your new installed wiki and put it there at the same location, e.g. file/backup/
    1. transfer backup folder via SFTP
  2. Restore module: Run restore.
    1. restore backup
    2. The restore process can take a considerable amount of time depending on the volume of your backup.

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