migrating WP from cpanel server to cyberpanel

Hi i followed the following to do migration from cpanel that doesnt use litespeed or ols to another server which runs cyberpanel and ols.

1- i backed up SQL database from cpanel.
2- created new database in cyberpanel
3- logged to cyber panel phpMyAdmin and imported the database extraced in step 1.

**** I got error****

4- I zipped the wp folder in cpanel
5- i trued to use scp -P [port] -r user@hostname:/path_to_zipped_wp_file /destination

*** connection refused***

my question is : do i have to generate ssh key to connect to the other server?

After step 3 what error you faced? You do not need to specifically generate SSH keys to transfer just need scp root logins.

I would also prefer you to upload your zip file either via FTP or file manager.

1 errors were found during analysis.

Missing expression. (near “ON” at position 25)
SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = ON;

You need to import your database via command line.

can u help me with command doing so?

@moataz said:
can u help me with command doing so?

This will serve you best: How can I import a database with MySQL from terminal? - Stack Overflow

jazak allah khayaran

im following these commands but still getting

ERROR 2006 (HY000) at line 2749: MySQL server has gone away

i set my.cnf [mysqld]
max_allowed_packet=500M

but still…

sorry was my mistake forgot to reboot…

now seems everything ok in my side

just one thing SOA refers to ns1.yyy.xom while im using nameservers in my hostname so it shall be ns1.xxx.com

if any idea how to change

SOA editing will be available in the upcoming version.

thanks a lot ,

another thing – i applied ssl to my addon domain apptogrow.com which is yyy.com in our case…

but when i checked using mx tool ive found
The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

so i made ssl check and got:

None of the common names in the certificate match the name that was entered (www.apptogrow.com). You may receive an error when accessing this site in a web browser. Learn more about name mismatch errors.
Common name: apptogrow.com
SANs: apptogrow.com
Valid from April 20, 2018 to July 19, 2018
Serial Number: 032677ebbfb6d96b062c66bbb6def60ab92a
Signature Algorithm: sha256WithRSAEncryption
Issuer: Let’s Encrypt Authority X3

Common name: Let's Encrypt Authority X3

Organization: Let’s Encrypt
Location: US
Valid from March 17, 2016 to March 17, 2021
Serial Number: 0a0141420000015385736a0b85eca708
Signature Algorithm: sha256WithRSAEncryption
Issuer: DST Root CA X3

so its obvious that i need to change issuer name maybe or add my domain to some trusted hosts file… any idea what to do?

Look at this: http://docs.cyberpanel.net/doku.php?id=manually-extend-ssl-for-www-domain