Trigunflame |
03-29-2005 06:15 PM |
Quote:
Originally Posted by Dennis Olson
A couple of things -
Can you provide SCP support in addition to FTP? We exclusively use SCP for security reasons.
My database is about 16 Gb. Tell me what I should do in order to assure a good backup.
Thanks!
|
-------------------------------------------------------------
Yes, I will start working on an SCP interface ASAP.
-------------------------------------------------------------
As for your backup, if I were you, Make Absolute Sure you have SafeMode off so that you can use the shell commands (mysqldump).
As for compression, I would turn Compression OFF, and take care of that manually whenever you need to. Compressing 16gb will take a lot of CPU anyway you look at it, so I dont recommend doing that automatically; do it when you need it done.
Just do a straightup backup to the .sql file or MAYBE using the tar option to just archive it. If I were you however, I would just backup straight to the sql file with no compression/archiving whatsoever.
Also, make sure you are storing your attachments in the FileSystem; that is an option inside the AdminCP, Look for it. It's hard to think how you could have 16gb of just text.
|