Hi,
Please note that if you have a large server, you may run into much more than a brick wall when going over from 10.3 to 8.0
Hey guys, I just wanted to write this friendly reminder because of the errors that we went through, we were migrating from Cloudlinux 6 to Cloudlinux 8.5, the previous version of SQL was MariaDB and by default, and here is the thing, the default MySQL is 8! on the new cPanel you can avoid this...
forums.cpanel.net
These were just the few issues we ran into, I had to help clients with databases which had TEXT DEFAULT which are not allowed in 8, what you may not realize is if you are restoring 100's upon 100's of databases and accounts you may miss the text when it just didn't add the database for John or Jane..
I will be doing another set of 6 servers for our company but I will be staying away from MySQL 8.0!, Ill start at 10.3 MariaDB and go with it, remember if you do 8.0 you cant roll back.
My best way to do this especially if its many accounts is to do this
Backup in commandline
for x in `ls /var/cpanel/userdata`; do /scripts/pkgacct $x; done
Once done, I like to move them fast so
for x in `ls -arth /home | grep tar.gz`; do rsync -avh --progress -e 'ssh -p (port) -T -o Compression=no -x' $x
[email protected](IP):/home/; done
Then just loop through them to restore
for x in `ls /home | grep tar.gz`; do /scripts/restorepkg --unrestricted --force --allow_reseller $x; done
Just my two cents, and careful with MySQL 8.0 cant stress the hell I was in for 2 nights straight. Remember if you are not in Console and an SSH session, do this in screen, so you can get back to it with screen -r in case you lose the connection. Also remember that doing things with backup tool cpbackup, it relies on your system load so it can constantly pause for a while when it's waiting for load to go down, pain in the ass, didn't have that issue with pkgacct but it also can be tweaked in WHM > Tweak