SQL Backup - zipped


#1

I have two databases, one that is less than 6MB zipped, and another one (recently) is larger than 6MB zipped (31MB unzipped).

When I try to take a zipped backup, the second one no longer works (comes back as 197 bytes, corrupted). Unzipped, it works. The smaller one works, zipped or unzipped.

This has started happening ever since the zipped file crossed over 6MB.

Has anyone else had this issue?


#2

This sounds like the 7 megabyte limit on uploads through a web interface. I use command line for my SQL dumps and restores:
http://wiki.dreamhost.com/Backup_MySQL#Getting_a_Backup_From_the_Shell
http://wiki.dreamhost.com/Restore_SQL_backup

-Scott


#3

I thought that too, but then I was able to download the 31MB unzipped through the same interface. It chokes on the zip process.

I don’t have access to the command line through the office firewall.