Loaded Commerce Community

Could someone tell me if this would work to set up a cron job and backup the database?
$datestamp = date("Y-m-d");
$filename = DIR_FS_CATALOG . "admin/backups/$datestamp.sql.gz";
mysqldump -u dbuser --password=pwd dbname | gzip > $filename


Of course I would add in the other necessary calls to the config files but mainly I am looking to know if my method would capture everything in the database so if I needed to I could do a restore the file would be valid.

Thanks!

Mike

As it is, not a chance, but if you have access to cron then wouldn't it be easier to make the cron command execute say /admin/backup.php?action=backup on a schedule? Cronjob configurations can depend on who you're hosted with, but if you have shell access then you can test different commands before adding it to the cronjob.

Simon

I was mainly looking at this line as the one in question:
mysqldump -u dbuser --password=pwd dbname | gzip > $filename

Now I could do as you suggested, which is a good suggestion, but I was going to build this into a php file that would do an "off site" ftp so the back-ups would not be only on my server. I just didn't want to cloud the water with too much detail (which I fear I might have).

Thanks!

Mike

Yeah but $filename in the line above will break (can't use a string in a path like that) and why write a separate script that connects to the dbase when a couple exist already in /admin that do this? Sounds and looks like hard work.

Offsite backups? - easier / more convenient / cheaper to use 3rd party setup ... google and sift the multitude of choices, many with dozen of options and nice interfaces.

Simon

Trying your suggestion of "/admin/backup.php?action=backup" didn't work with the cron command. I suspect that it is missing a field since if I manually enter that into the URL it asks what compression I want to use...

I wrote the script I was thinking about, it executed, and it saved the file. Then to look into other options and follow your advice about a google search, I search and I run into this:
http://addons.oscommerce.com/info/3100

Looks almost exactly like what I was recreating. lol.

So it looks like I am going to look at that contrib a little harder to see if it works for CRELoaded (don't see why it wouldn't - it does a sql dump like I was thinking about).

Mike

Yep good move ... use what's out there. Takes too long reinventing the wheel.

Simon