phpMyAdmin Backup Settings

[gjh42]

When I did that SQL edit I was stabbing blindly. It worked, but I didn't want to tell people "the" way when I didn't know the proper way myself. I would appreciate knowledgeable input. (I looked at the structure of statements and removed what looked like a complete sequence including the CREATE. The SET and USE edits were straightforward.)

Also, I have since done a backup that did update cleanly, and I'm not sure what if any differences there were in settings between the cases.

I hoped someone expert in MySQL would put more info in the wiki article, but so far nobody has.

PS - I did download the db as a gzip. My edits were to the file after I unzipped it.