Hello,
First, please visit the linked posts below to clean up wp_actionscheduler_actions & wp_actionscheduler_logs tables. Failure to do so may get your database huge.
Next, modify the WPvivid settings as recommended below on your source site to initiate a new backup:
General settings:
1. Uncheck the option of ‘Merge all the backup files into single package when a backup completes’
Advanced settings:
1. Database access method: PDO?
2. Compression method: PCLzip
3. Compress files every: 200 MB
4. Exclude the files which are larger than: 200MB
5. PHP script execution timeout for backup: 300 seconds
6. PHP memory limit for a backup task: 512 or 1024 MB
7. The number of files compressed to the backup zip each time: 300
8. Split a sql file every this size: 200 MB
Additionally, considering the large size of the website, it is advisable to utilize the Upload feature for transferring your site, following the steps outlined below:
1. Create a backup of your source site and download it to your desktop.
2. Upload the backup to the /wp-content/wpvividbackups directory of your target site. You can utilize an FTP client, or cPanel file manager.
3. Click on the “Scan uploaded backups and received backups ” button to detect and display the uploaded backup in the backup list. Then, proceed with the restoration process on your target site.
Kind regards.