PDA

View Full Version : Backup of MySQL issues


torb
03-09-2007, 05:33 AM
I'm having some issues with MySQL backups. Here's what I've found:

Logging in on CPanel and downloading my db through Cpanel backup gives me a file of 149kb gzipped, a joke. In PhpMyAdmin (through CPanel again) I get a file that's 149kb gzipped too... Now, for the strange part: through my forum software which only back ups *some* of the tables, the file size is 22MB SQL.

My db was at 36MB a month ago, now how come I can't back the whole thing up? It still says "SQL Disk usage 36.66 Megabytes" in cpanel, and I'm pretty sure it won't gzip to 149kb! :confused:

Anybody know how I can get the full db backed up? I'm getting frustrated here, as I desperately need a new dev-mirror on my local computer! :)

Thanks!

Michale
03-09-2007, 06:12 AM
This might help..


http://www.bluehostforum.com/showthread.php?t=6249


Michale

torb
03-09-2007, 06:14 AM
...seems to work now I think the reason was I logged in through bluehost.com as announced in the set-up e-mail sent by bh, rather than logging in on mydomain.com.

The file gzipped now is 17.9MB, which makes a lot more sense.

Consider this isssue resolved :)