MySql backups

[morrow]

How reliable are the mysql backups that are being provided by Powweb? My database is about 13meg or so zipped. Some of my vbulletin message have photo attachements.

The reason I ask is because everytime I try to create a backup, it times out on me. I don't have telnet access to Powweb.com, so telneting in is not an option.

Thanks for your response.

[B&T]

I don't trust any backups except ones I make myself. Try this:

http://help.powweb.com/info/backup.php

it will make a rotating backup so you will always have 30.

[Atomic-Design]

I once lost around 2-3 weeks of data because the PowWeb backups weren't so recent. That looks like a nice script, too.

[HalfaBee]

You should provbably add system( "gzip $filename" );
to the script, to make the backups smaller.

A 13MB zipped file could be very large unzipped.
Multiply that by 30 and 1000GB is soon eaten up.

HalfaBee

[Nino]

Originally posted by HalfaBee
You should provbably add system( "gzip $filename" );
to the script, to make the backups smaller.

A 13MB zipped file could be very large unzipped.
Multiply that by 30 and 1000GB is soon eaten up.

HalfaBee

Will
system( "gzip $filename" );
replace the file with the compressed version or does it create another file that is a compressed version?

(I'm not familiar with gzip).

Nino

[HalfaBee]

Yes it does replace the file with a .gz file.

HalfaBee