• Inviting everyone who uses WordPress management tools in Plesk
    The Plesk team is conducting a 60-minute research session that includes an interview and a moderated usability test.
    To participate, please use this link .
    Your experience will help shape product decisions and ensure the tools better support real-world use cases.

Migration with MySQL 5.5 installed do not migrate databases

jcgalvez

Basic Pleskian
Plesk Linux Centos 6.7 + upgrade mysql to version 5.5 according to the instructions on the following Link
https://kb.plesk.com/en/125589

I have 2 servers with 12.5 patched and upgraded to the top, one is a vps and the other running on hardware.

The problem is that when I put migrate from server a(vps) to server b (hardware) migrates everything BUT the mysql databases.

I have to mention that I "upgraded" mysql to 5.5 using https://kb.plesk.com/en/125589

I'm getting the following error

`- Subscription 'test.com'
|
|- error: Failed to copy content of database 'test1'
| Migration tools tried to perform operation in 3 attempts: Command execution failed on the source server 'source' (h42.test.com) with non-zero exit code.
| command: mysqldump -h localhost -P 3306 -uadmin --quick --quote-names --add-drop-table --default-character-set=utf8 --set-charset imexportsrl1 -p'***hidden***' --routines > /tmp/panel_migrator/db-dumps/test1.sql
| exit code: 2
| stdout:
| stderr: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'test1'': Cannot load from mysql.proc. The table is probably corrupted (1548)

however while testing that database on the vps server says that it's ok and no need to fix it
 
Back
Top