Welcome to WebmasterWorld Guest from 54.225.58.238

Forum Moderators: open

Message Too Old, No Replies

automatic restore of a database every hour

     
6:09 am on Jun 27, 2008 (gmt 0)

Full Member

10+ Year Member

joined:Mar 7, 2003
posts:301
votes: 0


For a demo site:
Does anyone know of a simple php script which will restore my PHPBB3 database and settings every hour?

PHPBB3 has a built in restore function, I'm wondering if there's a way to trigger it with a cron job.

Thanks.

3:59 am on June 28, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member eelixduppy is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Nov 12, 2005
posts:5966
votes: 0


There probably IS a way to execute that script with a cron. Have you tried it yet? You might have to write up your own little script real quick to properly use the restore feature without the forms that come with phpbb, however.

Also, if you don't mind me asking, what is the purpose of restoring the database every hour? How often does this actually need to happen?

5:42 am on June 28, 2008 (gmt 0)

Full Member

10+ Year Member

joined:Mar 7, 2003
posts:301
votes: 0


Every hour is not a requirement- just to eliminate spam posts or changes to the demo users.
12:34 am on June 29, 2008 (gmt 0)

Full Member

10+ Year Member

joined:Mar 7, 2003
posts:301
votes: 0


How about a script which will take my .sql file, and overwrite an existing database with it?
9:18 pm on June 29, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member eelixduppy is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Nov 12, 2005
posts:5966
votes: 0


Create a .SQL file with the backup from a previous time, then run a cron with the command:

mysql < backup.sql
1:14 am on June 30, 2008 (gmt 0)

Full Member

10+ Year Member

joined:Mar 7, 2003
posts:301
votes: 0


mysql -uUSERNAME -pPASSWORD DATABASE < /home/mysite/public_html/store/backup.sql

Worked :)

Thanks.