Differences

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

--- merkalt:database_backup [2010/09/14 13:32] – dmitriy
+++ 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.
@@ Line 22: / Line 24: @@
 But file size issue should be explored first.
 Third party script whcuch probably will be used for DB backups could be found in merkalt.com/test/_db_backup folder.
-Backup file should not include tables of test instances if it possible (tables with 'tst_' prefixes).
+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.
+**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?