Not sure if this is an issue wtih PhpMyAdmin, or MySQL, but I discovered today that I can no longer export my whole Drupal database in one shot (for backup purposes). Specifically: I can’t export to a zipped file. PhpMyAdmin gives me a warning:

“cannot file http://localhost/phpmyadmin/export.php”

I fiddled around in Apache’s confg file and discovered that the paths and aliases were all good. Tested a different db and it all worked fine. So I figured this error may not be what the error said it was. Tried changing the max queries way up – didn’t help.

Solution?

Selected tables from A->M and exported as one file. No probs.
Did N->Z (which I thought would be problematic since Node and Users are in that half). No probs.

Strange… But hey, it worked. Got my backup. *yay :S