I have run into some problems restoring these files using phpMyAdmin. There was some issue with my host and somehow odd characters were inserted into my backup.
If you are working with a remote host, an 80 Mb file uploaded to your server will probably time out your session anyway. Question: where is your DB server and do you have command line access to it?
Read through the docs for MySQL for instructions on importing data from a file and bypass phpMyAdmin. Then page through your backup file looking for offending bits or odd characters. In my case, the comments consisted of a line of dashes and MySQL choked on this. If you find a pattern of errors, I would use a command line script to fix them since loading up an 80 Mb file in BBEdit or something would make your eyes bleed.
Recent Comments