Page 1 of 1

[1.5]A recommended way to backup

Posted: Sat Jun 11, 2011 11:58 am
by estperfumes
Hi

i am looking at ways to backup my OC 1.5? would you recommend SQLBackupAndFTP?

Re: A recommended way to backup OC 1.5?

Posted: Sat Jun 11, 2011 3:32 pm
by SapporoGuy
I tend to use phpmyadmin (or such) for the db dump and then just FTP (copy the directories) so yeah, that would seem like the way to go.

Re: A recommended way to backup OC 1.5?

Posted: Sun Jun 12, 2011 5:00 am
by estperfumes
SapporoGuy wrote:I tend to use phpmyadmin (or such) for the db dump and then just FTP (copy the directories) so yeah, that would seem like the way to go.
thanks, i considered that but got 20 viruses last time i dumped, maybe just the ftp is sufficient

Re: [1.5]A recommended way to backup

Posted: Sun Jun 12, 2011 9:21 pm
by SapporoGuy
why would you get viruses?

Make sure you are using a safe ftp program.
Also, use your cpanel or what ever your hosting service provides.

You will also need the SQL data!

Re: [1.5]A recommended way to backup

Posted: Sun Jun 12, 2011 11:56 pm
by JAY6390
You can import/export data from the database directly from your admin under SYSTEM > BACKUP/RESTORE however note that for large databases this will take a long time to download, as it doesn't use any form of compression. PMA is the ideal choice, or if you have command line access, use mysqldump and gzip the output to a file. I've seen a 250MB uncompressed db shrink down to 10MB before now, so it's well worth doing to save on your bandwidth and upload/download time

Re: [1.5]A recommended way to backup

Posted: Mon Jun 13, 2011 12:12 pm
by Johnathan
It seems like adding a gzipped Backup function into the core would be a nice feature at some point in the future. I'd post it in the Feature Requests forum, but I have a feeling it would get ignored until all the 1.5 bugs are fixed. ;D