So many problems with migration…

So I’m trying to deploy a site from one server to another. I’ve had no issues with UD on the staging server. Made a full backup etc.

I tried to use the migrator function, which seemed to fail I’m guessing for communication issues between the server.

I then downloaded the backup files and uploaded them to the prod server using the Web interface. That didn’t seem to work well, UD didn’t seem to recognize the backup set.

So I cleared the UD folder via FTP and FTP’d the backup files to the local store directory. Rescanned and UD found the set. Clicked Restore, all files and chose the migrate option. The error I got is below.

Any ideas on next steps?

Error received:

Error: the server sent us a response (JSON) which we did not understand. Error data:: {“m”:”<p>The backup archive files have been processed, but with some errors. You will need to cancel and correct any problems before retrying.<\/p>”,”w”:”The database file appears to have been compressed twice – probably the website you downloaded it from had a mis-configured webserver.<br>PHP event: code E_WARNING: rename(D:\\ftp\\bakerbros\\Htdocs\\WP\/wp-content\/updraft\/backup_2015-12-05-1723_Baker_Bros_02d49d0f017a-db.gz.tmp,D:\\ftp\\bakerbros\\Htdocs\\WP\/wp-content\/updraft\/backup_2015-12-05-1723_Baker_Bros_02d49d0f017a-db.gz) [function.rename<\/a>]: File exists (line 3531, D:\\ftp\\bakerbros\\Htdocs\\WP\\wp-content\\plugins\\updraftplus\\class-updraftplus.php)”,”e”:”The attempt to undo the double-compression failed.<br>Failed to open database file.”,”i”:”[]”}WordPress database error Access denied; you need (at least one of) the SUPER privilege(s) for this operation for query SET GLOBAL max_allowed_packet=33554432 made by do_action(‘wp_ajax_updraft_ajax’), call_user_func_array, UpdraftPlus_Admin->updraft_ajax_handler, UpdraftPlus->analyse_db_file, UpdraftPlus->get_max_packet_size