Cron job to back up your db every night
This was posted by rbarclay and may be of use to you all
Quote:
|
Just thought I would highlight this for all the newbies out there - this works a treat and you SHOULD ALWAYS have a backup in place for your database - They can and DO crash.
|
Good stuff! can someone walk through the cron script to explain what each line does.
|
I think I already posted this, but here is a great tutorial:
http://www.phpfreaks.com/tutorials/28/0.php On the other hand if you really want to automate backups, use a Tool called "DARKMANS SITE BACKUP TOOL" it is really the BEST I have used and it not only backs up your Database, it works for specific directories as well, and it backs up everything to a folder on your server and it can even send it via email, after compresion if you like. FIVE STAR RECOMMEND Here is the link: http://www.crohack-forum.com/forum/viewforum.php?f=18 It will make your life alot easier. |
Seurity Issue?
Being that the username and password is in the file, how do you keep it secure on a shared web hosted machine?
|
If you are talking about the site backup tool, remember that the password is encrypted from the xcart software, so even if anybody catches it, they wont be able to access it.
On the other hand, you could hide the backups in a protected directory, really internal so nobody can notice it. Or send only by email without keeping file on server. |
Quote:
... unless they have access to the decryption code (i.e. the X-Cart code). |
Ooops, you are right about that. So I guess that only the other options could be considered for better protection, anyway there is no 100% security, the only way to avoid at the Max in a backup from a shared account would be executing a manual download of the backup.
And even though, if its shared, there might be someone able to access the MySql server also. |
Re: Seurity Issue?
Quote:
To clarify I mean the password is stored in the shell program file from the code example above posted by rbarclay. |
mmmm, ahhhh, mmmm #-o who is rbarclay?
|
All times are GMT -8. The time now is 07:34 PM. |
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.