将脚本添加到index.php

Question

Dear stackflower users,

A few days ago there was a power outage and my mysql database was lost... (I did have a one month old backup)

So I started looking for a program that makes backups of my mysql database automatically. I found a script that does exactly this, its called phpMyBackupPro

According to the readme I had to add:

    require_once("phpMyBackupPro/schedule_backup.php");

To a page that gets loaded frequently (for example index.php)

So I tried adding this to my index.php page of joomla and clearing my joomla and browser cache. However the backup files are not being created when I load the index.php, when I run the script manually they are however.

So I started looking for some addons that could load php files in joomla, but they either didn't work or they where not compatible with joomla 1.7.

is their anyone who knows how to get this script to work, or knows a better way of automatically backing up mysql databases on windows?

Answer 1

I would avoid trying to what you mentioned and instead use a Joomla specific extension such as this:

http://extensions.joomla.org/extensions/access-a-security/site-security/backup/15682?qh=YToxOntpOjA7czoxMDoibGF6eWJhY2t1cCI7fQ%3D%3D

I have used this for years and it has saved my ass on multiple occasions so happily recommend it!

Having said that if you're dead set on what you've mentioned simply add it to the BOTTOM of your template file located: templates/your_templates/index.php

Hope this helps,

Andy