Azurel
Silver Pleskian
I tried to migrate from CentOS 7.8 (MariaDB 10.1.45) to CentOS 8.2 (MariaDB 10.3.17) and get a error.
I make daily backup for this database (and import localhost on pc), without ever have a error. What could be the problem here?
The export should maybe use something like this
Now I have fixed it in source database with set
EDIT: Reported Migrate fails for database, when a table have ROW_FORMAT=FIXED
I make daily backup for this database (and import localhost on pc), without ever have a error. What could be the problem here?
Failed to copy content of database 'mydomain1'
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/20200807122600/target-server/my_localhost_mydomain1.cnf -h localhost -P 3306 -uadmin mydomain1 < /usr/local/psa/var/modules/panel-migrator/sessions/20200807122600/target-server/db-dumps/mydomain1.sql
exit code: 1
stdout:
stderr: ERROR 1005 (HY000) at line 10887: Can't create table `mydomain1`.`sessions` (errno: 140 "Wrong create options")
The export should maybe use something like this
cat mysqldump | sed -r 's/ROW_FORMAT\s*\=\s*FIXED/ROW_FORMAT=DYNAMIC/g' > output.sql
Now I have fixed it in source database with set
ALTER TABLE `sessions` ROW_FORMAT=DEFAULT;
EDIT: Reported Migrate fails for database, when a table have ROW_FORMAT=FIXED
Last edited: