Database transfer issues when migrating using Remote Transfer

Server Details:

Operating System: Ubuntu 22.04
Software Versions:

Current Version:  2.3
Build:  5Current Commit:  846341bfe2669585bef0e6da36a2199babeda859
Latest Version:  2.3
Latest Build:  5Latest Commit:  846341bfe2669585bef0e6da36a2199babeda859

Issue:
I am attempting to use the ‘Remote Transfer’ feature to migrate WordPress sites from one server to another. Although the UI indicates that the restoration is complete, the database does not transfer. The destination server is a fresh installation of CyberPanel. While the files have successfully transferred, the database transfer fails due to an issue I cannot identify. There are also some expected SSL errors.

Note: The credentials in the log files are replaced with dummy data for security reasons.

Main Error Log:

Backup version 2.1.1+ detected..
[07.06.2024_08-58-53] Extra data: line 1 column 2 (char 1). [setupConnection:75]
[07.06.2024_08-58-53] CREATE DATABASE JKLpdmeNVTBuQP
[07.06.2024_08-58-53] CREATE USER 'JKLpdmeNVTBuQP'@'localhost' IDENTIFIED BY 'cyberpanel'
[07.06.2024_08-58-53] GRANT ALL PRIVILEGES ON JKLpdmeNVTBuQP.* TO 'JKLpdmeNVTBuQP'@'localhost'
[07.06.2024_08-58-53] Backup version 2.1.1+ detected..
[07.06.2024_08-58-53] Extra data: line 1 column 2 (char 1). [setupConnection:75]
[07.06.2024_08-58-53] CREATE DATABASE Nx4wHRXpxj5trV
[07.06.2024_08-58-53] CREATE USER 'Nx4wHRXpxj5trV'@'localhost' IDENTIFIED BY 'cyberpanel'
[07.06.2024_08-58-53] GRANT ALL PRIVILEGES ON Nx4wHRXpxj5trV.* TO 'Nx4wHRXpxj5trV'@'localhost'
[07.06.2024_08-58-53] Backup version 2.1.1+ detected..
[07.06.2024_08-58-53] Extra data: line 1 column 2 (char 1). [setupConnection:75]
[07.06.2024_08-58-53] CREATE DATABASE mZX8vnL7YxERPu
[07.06.2024_08-58-53] CREATE USER 'mZX8vnL7YxERPu'@'localhost' IDENTIFIED BY 'cyberpanel'
[07.06.2024_08-58-53] GRANT ALL PRIVILEGES ON mZX8vnL7YxERPu.* TO 'mZX8vnL7YxERPu'@'localhost'
[07.06.2024_08-58-53] Backup version 2.1.1+ detected..
[07.06.2024_08-58-53] Database user: JKLpdmeNVTBuQP
[07.06.2024_08-58-53] Database host: localhost
[07.06.2024_08-58-53] Database password: *G0482B84DD0E95F7F28G3GEF632740HG82G13E09
[07.06.2024_08-58-53] mysql --defaults-extra-file=/home/cyberpanel/.my.cnf -u root --host=localhost --port 3306 JKLpdmeNVTBuQP /home/backup/transfer-9928/backup-demo.my-domain.co.uk-07.06.2024_08-57-50/JKLpdmeNVTBuQP
[07.06.2024_08-58-53] Extra data: line 1 column 2 (char 1). [setupConnection:75]
[07.06.2024_08-58-53] CREATE USER 'JKLpdmeNVTBuQP'@'localhost' IDENTIFIED BY '*G0482B84DD0E95F7F28G3GEF632740HG82G13E09'
[07.06.2024_08-58-53] (1396, "Operation CREATE USER failed for 'JKLpdmeNVTBuQP'@'localhost'")[createDatabase]
[07.06.2024_08-58-53] Extra data: line 1 column 2 (char 1). [setupConnection:75]
[07.06.2024_08-58-53] SET PASSWORD FOR 'JKLpdmeNVTBuQP'@'localhost' = '*G0482B84DD0E95F7F28G3GEF632740HG82G13E09'
[07.06.2024_08-58-53] Backup version 2.1.1+ detected..
[07.06.2024_08-58-53] Database user: Nx4wHRXpxj5trV
[07.06.2024_08-58-53] Database host: localhost
[07.06.2024_08-58-53] Database password: *G0482B84DD0E95F7F28G3GEF632740HG82G13E09
[07.06.2024_08-58-53] mysql --defaults-extra-file=/home/cyberpanel/.my.cnf -u root --host=localhost --port 3306 Nx4wHRXpxj5trV /home/backup/transfer-9928/backup-demo.my-domain.co.uk-07.06.2024_08-57-50/Nx4wHRXpxj5trV
[07.06.2024_08-58-53] Extra data: line 1 column 2 (char 1). [setupConnection:75]
[07.06.2024_08-58-53] CREATE USER 'Nx4wHRXpxj5trV'@'localhost' IDENTIFIED BY '*G0482B84DD0E95F7F28G3GEF632740HG82G13E09'
[07.06.2024_08-58-53] (1396, "Operation CREATE USER failed for 'Nx4wHRXpxj5trV'@'localhost'")[createDatabase]
[07.06.2024_08-58-53] Extra data: line 1 column 2 (char 1). [setupConnection:75]
[07.06.2024_08-58-53] SET PASSWORD FOR 'Nx4wHRXpxj5trV'@'localhost' = '*G0482B84DD0E95F7F28G3GEF632740HG82G13E09'
[07.06.2024_08-58-53] Backup version 2.1.1+ detected..
[07.06.2024_08-58-53] Database user: mZX8vnL7YxERPu
[07.06.2024_08-58-53] Database host: localhost
[07.06.2024_08-58-53] Database password: *G0482B84DD0E95F7F28G3GEF632740HG82G13E09
[07.06.2024_08-58-53] mysql --defaults-extra-file=/home/cyberpanel/.my.cnf -u root --host=localhost --port 3306 mZX8vnL7YxERPu /home/backup/transfer-9928/backup-demo.my-domain.co.uk-07.06.2024_08-57-50/mZX8vnL7YxERPu
[07.06.2024_08-58-53] Extra data: line 1 column 2 (char 1). [setupConnection:75]
[07.06.2024_08-58-53] CREATE USER 'mZX8vnL7YxERPu'@'localhost' IDENTIFIED BY '*G0482B84DD0E95F7F28G3GEF632740HG82G13E09'
[07.06.2024_08-58-53] (1396, "Operation CREATE USER failed for 'mZX8vnL7YxERPu'@'localhost'")[createDatabase]
[07.06.2024_08-58-53] Extra data: line 1 column 2 (char 1). [setupConnection:75]
[07.06.2024_08-58-53] SET PASSWORD FOR 'mZX8vnL7YxERPu'@'localhost' = '*G0482B84DD0E95F7F28G3GEF632740HG82G13E09'
[07.06.2024_08-58-53] rm -rf /home/demo.my-domain.co.uk/public_html

MariaDB Error logs:

2024-07-06  9:34:38 2571 [Warning] Aborted connection 2571 to db: 'cyberpanel' user: 'cyberpanel' host: 'localhost' (Got an error reading communication packets)
2024-07-06  9:57:49 2568 [Warning] Aborted connection 2568 to db: 'cyberpanel' user: 'cyberpanel' host: 'localhost' (Got an error reading communication packets)
2024-07-06  9:58:57 2605 [Warning] Aborted connection 2605 to db: 'cyberpanel' user: 'cyberpanel' host: 'localhost' (Got an error reading communication packets)

Any assistance in resolving this issue would be greatly appreciated. Thank you.

have you changed the cyberpanel or root mysql user pass?

No, it is literally a brand new fresh install of Cyberpanel.

can you please open a ticket at our platform let me check

Hey, how do I do that?. Not done that before?.

Anyone able to assist?