Hi,
I have tried with several abantecart sites to run the upgrade package to upgrade v1.1.9 to v1.2.0
All of them fail with error as below:
Error: Can't create sql dump of database during backup
I tried the manual processes and downloaded the upgrade only package, extracted it. Copied the contents of the directory 'code' to my abantcart directory and then tried to use upgrade.sql in phpMyAdmin (Version information: 4.0.10.7, latest stable version: 4.3.7)
I should note this script has so many errors in it its almost unusable as it assume a schema table prefix is 'ac_' and the TIMESTAMP commands don't work with all version of phpMyAdmin . And has to be worked through line by line to get it work, checking the table columns and index first before running each block of sql code.
Even after doing this, Still the upgrade failed and the store page and admin pages both showed critical errors.
So I rolled back to V1.1.9 store and database from a softaculous backup.
Ok, so here's how I did manage to get the upgrade to succeed....MAKE A FULL SOFTACULOUS BACKUP FIRST OF LIVE SITE!
Using the provided backup.php file as provided in this thread ?http://forum.abantecart.com/index.php/topic,1676.15.html?
I renamed the existing backup.php in /public_html/store/core/lib on your live site to backup.php.old
I then copied the downloaded backup.php file to /public_html/store/core/lib on live site
Then ran the upgrade using the message link or by typing 'abantecart_upgrade_120" into the 'Network Install tab' 'Installation Key' form textbox.
The package downloaded and installed correctly. Will do bit more testing but the store and backend appear to be working correctly.
So hope this work around helps anyone with similar upgrade issues as I had.