Updating mysql 5.5 to 5.7
I am trying to update a database with multiple table from 5.5 to 5.7.
I create a backup of the Database and save it to my local machine
I create a new 5.7 DB on the ionos server.
When created I upload the backup to the newly created DB but get the following error message.
Any ideas how to overcome this very welcome!
2 errors were found during analysis.
Unexpected beginning of statement. (near "phpMyAdmin" at position 0)Unrecognized statement type. (near "SQL" at position 11)
phpMyAdmin SQL Dump SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'phpMyAdmin SQL Dump
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"' at line 1