Differences

This shows you the differences between two versions of the page.

--- merkalt:database_backup [2010/09/14 13:20] – daruma
+++ merkalt:database_backup [2010/09/16 07:40] (current) – dmitriy
@@ Line 17: / Line 17: @@
 If current date and time is greater then last backup date plus backup period then backup script should be launched.
 Otherwise - shouldn't.
+//NOTE: Pseudo-cron script **SHOULD NOT USE any external libraries** (like mysql.inc.php, etc.) and should be realized only with a help of native PHP functions.//
 Backup files should be gzipped, stored ouside of sites accessible area.
 If size of gzipped backup file will not too big then backup should be sent via e-mail as attached file.
 But file size issue should be explored first.
-Third party script for DB backups could be found in merkalt.com/test/_db_backup folder. It seems it has all these features.
+Third party script whcuch probably will be used for DB backups could be found in merkalt.com/test/_db_backup folder.
+Backup file will exclude ONLY tables of test instances (tables with 'tst_' prefixes).
+DB backup will not be provided for Labelyourbelongings.com instance for a while.
-Backup file should not include tables of test instances if it possible (tables with 'tst_' prefixes).
+**Question**
-**Questions:**
+Size of each created backup (compressed by gzip) currently is about 3Mb. It seems such files too large to be sent as e-mail attachment. May be it makes a sense to do one of the following (or combined) -
+  * place file in the folder accessible only from admin area or ftp (not public browsable), add a page with backups list in admin.
+  * place file in the folder accessible only from ftp (not browsable).
-  -  Should this backup include tables of wordpress (customer service) blogs also?
++ I think it should be sort of restriction of number of backups stored there, say last 30 backups?
-  -  Labelyourbelongings.com instance hosted separately ftom other merkalt instances. Should this script be installed for Labelyourbelongings.com?