![]() |
I'd ask Chen this but it's waaaaaaaaay beyond HIM...
I have a demo board that I use to show off vB Lite. Every 12 hours or so, how can I have the board automatically reset itself? I mean:
1. Empty the entire db 2. Import the original, fresh install db from a .sql file ? |
I doubt it's beyond Chen.
Have a cron job fire off a shell script. Something like this... Code:
#!/bin/sh |
Or if you have root access, DROP DATABASE, CREATE DATABASE and load the file. :)
(umm, there IS a problem with [code]... argh) |
Ya, looks like its calling nl2br twice.
|
Coolness...since this is running on my own system I can just schedule a batch file to be run every 12 hours or something?
|
Quote:
|
This little batch file doesn't work:
Code:
@echo off Code:
C:\>resvblite |
I think I gave you the wrong syntax... sorry
mysql -uUser -pPassword -e "DELETE FROM table_name" database_name |
Or just put EVERYTHING in the vblite.sql file...
Start it with: [sql]USE database_name;[/sql] Then proceed with the DELETE FROM queries, and then the import queries. |
All times are GMT. The time now is 03:19 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|