Hey all,
I had the same problem. Here’s an easy fix, don’t know if it will work for everyone though.
Use MySQL Administrator to backup (you can download from http://www.mysql.com/products/administrator/). Start MySQL Administrator and login to your MySQL database as root. In the left pane click ‘Backup’ then click ‘New Project’ down in the bottom right. Name it whatever you want. Now, click on your wordpress database in the ‘Schemata’ pane then click the right arrow to add it to the backup project.
Now, HERE’S THE KEY. Click on the ‘Advanced Options’ tab, and select ‘Compatability Mode’ under ‘Output File Options’. Now you can save your backup with ‘Save Project’ in bottom right or just backup right away with ‘Execute Backup Now’ also in bottom right.
This will create the SQL file, move that to your linux box. Use whatever client you like (I used phpmyadmin) and restore this SQL file.
Should work.
