Hello everyone,

Looking for ideas on how to best accomplish this:

I have a site running on a VPS account that's several years old and has not been backed up except what the provider does to the entire VPS. Over time the MySQL database that the site uses grew up to be a VERY significant size, almost half of the storage available. With application files and couple other sites running on that VPS I'm using 70% of all storage available to me.

How do I best make a backup of such db and move it across the net (FTP?) so I have a local backup? Are there applications out there that may let me backup the db in parts and FTP the parts, then re-assemble? I don't want to overload the VPS with the backup task and I don't want to completely kill it accidentally by having a backup file created that's larger (or equals to) the size of available storage.

Any ideas?

Thanks!