Database backup through cronjob
Well, 1and1 is claiming that they provide a backup for their databases and webspace everyday. However, one time when I accidentally deleted a database from the 1and1 control panel, the tech support of 1and1 gave me a backup of the database that was there 3 days ago. So some tables were not there, some tables were not updated.
Not exactly sure why, of maybe I've deleted the database prior to time their backup was ran.
After that experience, I just made a cronjob to do the database backup since my package comes with SSH access.
You may just insert the code below to your cron.
x x x x x mysqldump -hdbxxx.perfora.net -udbo4xxxxxx -pxxxxxx dbxxxxxxxx > db-backup.sql
0 comments:
Subscribe to:
Post Comments (Atom)
