When you used phpMyAdmin did you tell it to ‘gzip’ the file?
Thread Starter
Rhand
(@rhand)
Yes. Downloaded as a .gz from PMA as well. It “unzipped just fine. Tried the plugin WP-DB-Backup again, but still got a .cpgz instead of the .sql when I tried to unzip.
Thread Starter
Rhand
(@rhand)
Tried downoading backup created by plugin using Safari instead of Firefox this time. Safari tried to unzip it and failed with error:
10/31/10 10:42:06 PM [0x0-0x190190].com.apple.Safari[6792] Sun Oct 31 22:42:06 mysmbp Safari[6792] <Error>: CGImageSourceCreateWithURL: CFURLCreateDataAndPropertiesFromResource failed with error code -14.
Thread Starter
Rhand
(@rhand)
Somehow files were corrupted before they got to my box. This goes for dumping using PMA as well as the WP-DB-Backup plugin.
Tested dumps made them with hexdump on got:
mymbp:Backup me$ hexdump -C file.sql.gz | head
hexdump: file.sql.gz: No such file or directory
hexdump: file.sql.gz: Bad file descriptor
Tried gunzipping .gz files in terminal and got.
gzip: /Users/me/Webdesign/folder/backup/file.sql.gz: not in gzip format
. This happens often when making a dump on a server that is located several 1000 miles away. They were corrupted during transfer. When I use WP-DB_Backup and e-mail the SQL dump all is well and the files can be gunzipped or unzipped without any issues.
You may try removing the .gz filename extension. I’ve seen .sql.gz files that are actually just .sql files.
