Forums

Reset Database every hour?

Permalink
Hi Folks,

I'm creating a demo site where I want the content and pages etc to be restored every hour so if people login and mess it up it will be put back to "normal" an hour later.

Be good to "restore" the DB every hour, how can I do this? Is there a way I can do it in PHPMyAdmin or can I do it in Concrete5 itself?

Thanks in advance!

Dave
madesimplemedia
 
mnakalay replied on at Permalink Best Answer Reply
mnakalay
hi,
There are several how-tos that explain just that.
The latest (version 5.6.0 and above) can be found here:http://www.concrete5.org/documentation/how-tos/developers/set-up-a-...
madesimplemedia replied on at Permalink Reply
madesimplemedia
Looks good thanks, I will check it out! :)
madesimplemedia replied on at Permalink Reply
madesimplemedia
Hi,
I've just got one problem with this:

I followed the guide above, created the DB, got the site and content how I wanted it and create the starting point.

I then used the Starting Point Generator to create my content.xml file.
Also added the cronjob and entered all my settings into the reset script.

Now the issue is, when the script runs, it drops all the DB tables as it should and everything else seems to work ok, but I then have to go back to phpmyadmin and re-import all the tables because they are not getting added (DB is empty)??

Any ideas what the issue could be?

Thanks

Dave
madesimplemedia replied on at Permalink Reply
madesimplemedia
Anyone know about this one please? :)