tkalfaoglu
Silver Pleskian
Username: tkalfaoglu
TITLE
Migration gives an SQL error
PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE
CENTOS 8 Obsidian
PROBLEM DESCRIPTION
While migrating I see these errors for one hosting:
Failed to copy content of database 'cebiopendoc'
Migration tools tried to perform operation in 3 attempts: Command execution failed on the local server with non-zero exit code.
command: mysql --defaults-file=/usr/local/psa/var/modules/panel-migrator/sessions/20210709111654/target-server/my_localhost_cebiopendoc.cnf -h localhost -P 3306 -uadmina cebiopendoc < /usr/local/psa/var/modules/panel-migrator/sessions/20210709111654/target-server/db-dumps/cebiopendoc.sql
exit code: 1
stdout:
stderr: ERROR 1064 (42000) at line 25: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 5
STEPS TO REPRODUCE
migate this domain from another server running centos 7 obsidian
ACTUAL RESULT
gives this error
EXPECTED RESULT
smooth sailing
ANY ADDITIONAL INFORMATION
YOUR EXPECTATIONS FROM PLESK SERVICE TEAM
Confirm bug
TITLE
Migration gives an SQL error
PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE
CENTOS 8 Obsidian
PROBLEM DESCRIPTION
While migrating I see these errors for one hosting:
Failed to copy content of database 'cebiopendoc'
Migration tools tried to perform operation in 3 attempts: Command execution failed on the local server with non-zero exit code.
command: mysql --defaults-file=/usr/local/psa/var/modules/panel-migrator/sessions/20210709111654/target-server/my_localhost_cebiopendoc.cnf -h localhost -P 3306 -uadmina cebiopendoc < /usr/local/psa/var/modules/panel-migrator/sessions/20210709111654/target-server/db-dumps/cebiopendoc.sql
exit code: 1
stdout:
stderr: ERROR 1064 (42000) at line 25: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 5
STEPS TO REPRODUCE
migate this domain from another server running centos 7 obsidian
ACTUAL RESULT
gives this error
EXPECTED RESULT
smooth sailing
ANY ADDITIONAL INFORMATION
YOUR EXPECTATIONS FROM PLESK SERVICE TEAM
Confirm bug