Use WPVidid backup, and your file system UI or SSH to transfer the export.
Problem
I wanted to move my WordPress sites off of Unlimited Web hosting and onto a DO droplet. Why? because shared hosting sucks. I was getting a D pingdom Performance grade with many lagging or failing https requests with a huge inexplicable TTFB. I realised that most of my static sites can be put on Render now for free (and I’d actually have Plesk git CI/CD back on my own VPS) and so I’d fit within the free license Plesk offering on the DO marketplace.
I used to use All-in-One WP Migration to export and migrate sites and it works well if the site size is small, around say 30Mb.
If there are a lot of posts and media the export file size can soon ballon to 450Mb+ in my case. With All-in-One WP Migration there is paywall and subscription covering the alternative to “file upload” methods, while this plugin is good, it presents a lot of headache if there are restrictions on your server configurability.
Export a backup to your source site /wp-content folder
Check: “Database + Files (WordPress Files) “
and “Save Backups to Local”
keep the destination folder the default
Zip
/wp-content/wpvididbackups
and download the .zip with your admin panel or SSH, or SFTP
Install WP in your new destination with the same admin login creds to keep it simple.
Upload the zip to the same location /wp-content/wpvididbackups in your destination fresh install site.
Change your DNS records so the old domain points to the new host, login in, restore the backup.
Check your permalinks.
SSL & cloudflare.
Cloudflare makes everything DNS so easy. But, though my own stupidity I was blocked from accessing my domain in Opera by a strict HSTS policy when trying to use ihosts to locally change my domains host IP to switch between the old and new host environments, that was because I revoked the Origin Certs on Cloudflare prematurely so be careful with using Strict SSL/TLS encryption mode in Full and the proxy DNS. Save the SSL changes to the last minute. If you revoke them remember to remove them in your host too.
Godspeed.
End Result
Dramatic increase in performance and a usable admin panel.