i am running a site and giving a joomla demo on a sub domain. People will have admin access to this demo account and i want to refresh the database every 2 hours back to the original joomla installation. Please let me know the best way to do it. I am hosting with lunarpages. they have the cron job option. thank you
It's hard to tell you what to do since you don't give even a small hint as to what database software you are using. But, as an example, with Postgrsql I'd do something like this:
im using the following syntax ... but its not working .. please let me know if im typing something wrong mysql --user [user name] --password [password] --database [database name] < [saved database] this is to restore a file from saved database to database name (file)
