I've been trying to migrate a wordpress site onto a very old IIS server, and keep coming up with an error when importing the database into phpMyAdmin:
Fortunately the issue is fairly easy to fix. In phpMyAdmin of the source website:
- Click the "Export" tab for the database
- Click the "Custom" radio button
- Go the section titled "Format-specific options" and change the dropdown for "Database system or older MySQL server to maximize output compatibility with:" from NONE to MYSQL40.
- Scroll to the bottom and click "GO".