How to set a continuous backup batch? Posted by Conrad Rentsch 19 Apr 2005 11:38 GMT-0000 posts: 13 Hi all, we are using tikiwiki in an productive environment. So how can I setup tiki, to do backups of the DB every day at a specific time? A detailed description would be very useful. Thanks a lot in advance
Posted by Damian Parker 19 Apr 2005 18:44 GMT-0000 posts: 2881 Please see the recent post by kalamate ❗ You will need to do a cronjob, type man crontab at your linux prompt for details. and schedule a mysqldump operation. See the mysql documentation for details of mysqldump Then you will need to tar or bzip2 the file system, Again see the necessary man pages for each for parameters. This is the procedure I use for all hosting accounts on tikihost.net servers. If your on Windows, then you'll have to wait for a windows user to answer, My knowledge of windows consists of using Scheduled Tasks, a batch file to mysqldump, then the DOS version of pkzip to archive the tree. Damian http://tikihost.net
Posted by Conrad Rentsch 20 Apr 2005 14:10 GMT-0000 posts: 13 Thanks Damian, i have written a backup script and configured as necessary the crontab, that works great. But one more question, why is the sql backup file made with mysqldump smaller than the one created by the internal tiki backup tool?
Posted by Damian Parker 21 Apr 2005 18:17 GMT-0000 posts: 2881 > Thanks Damian, > > i have written a backup script and configured as necessary the crontab, that works great. > > But one more question, why is the sql backup file made with mysqldump smaller than the one created by the internal tiki backup tool? Because the internal tool doesnt work correctly and any backups made with it, cannot be restored. Do not use it. Damian http://tikihost.net
