Migration failed: The used table type doesn't support FULLTEXT indexes

Upgrade to MariaDB 5.6 at least;

If upgrade is not possible:

1. Connect to the target server using SSH .

2. Open the dump file mentioned in the error message /usr/local/psa/var/modules/panel-migrator/sessions/20171108065711/target-server/db-dumps/example_db.sql and perform the search for the word FULLTEXT . Note the names of tables.

3. Connect to the source server using SSH .

4. Create backup of example_db database:

   # plesk db dump example_db > example_db.sql

5. Connect to MySQL server and change the engine to MyISAM for tables found in step 2:

   # plesk db
   mysql> use example_db
   ALTER TABLE table1 ENGINE = MYISAM;
   ALTER TABLE table2 ENGINE = MYISAM;

If there is no root access to the source server or there is no Plesk installed, use the following instruction:

1. Create a dump of the affected database on a source server and upload it to a local machine or in a directory of the incompletely migrated website on a target server in Plesk > Domains > example.com > File Manager.

2. Open the dump file and find all tables which contain word "FULLTEXT", for example:

   CONFIG_TEXT: CREATE TABLE `example.table` (
   `ex` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `ex2` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),
   UNIQUE KEY `license_type_id` (`license_type_id`,`pkg_id`),
   FULLTEXT KEY `pkg_id` (`pkg_id`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

3. Manually change the engine to MYISAM for all affected tables:

   CONFIG_TEXT: CREATE TABLE `example.table` (
   `ex` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `ex2` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),
   UNIQUE KEY `license_type_id` (`license_type_id`,`pkg_id`),
   FULLTEXT KEY `pkg_id` (`pkg_id`)
   ) ENGINE=MYISAM DEFAULT CHARSET=utf8;

4. Create a database in Plesk > Domains > example.com > Databases with the same name and user as the original one.

5. Import edited dump of the database in Plesk > Domains > example.com > Databases > example.database > Import.

6. Re-sync data for this domain without option Re-sync database data in Plesk > Tools & Settings > Migration and Transfer Manager > example.migration > example.com