I'd ask Chen this but it's waaaaaaaaay beyond HIM...

[filburt1]

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

?

[Mark Hensler]

I doubt it's beyond Chen.

Have a cron job fire off a shell script. Something like this...

#!/bin/sh

/path/to/mysql -uUser -pPassword -e "DELETE FROM table_name"
/path/to/mysql -uUser -pPassword -e "DELETE FROM table_name2"

/path/to/mysqlimport -uUser -pPassword database_name file_name.sql

[Admin]

Or if you have root access, DROP DATABASE, CREATE DATABASE and load the file. :)

(umm, there IS a problem with [code]... argh)

[Mark Hensler]

Ya, looks like its calling nl2br twice.

[filburt1]

Coolness...since this is running on my own system I can just schedule a batch file to be run every 12 hours or something?

[XyuRi]

Originally posted by filburt1
Coolness...since this is running on my own system I can just schedule a batch file to be run every 12 hours or something? that'd probably be the best option (thats probably yhr aproach I'd take)

[filburt1]

This little batch file doesn't work:


@echo off
echo Resetting vB Lite Demo Board on localhost...
c:
cd \mysql\bin
mysql -uroot -e "DELETE FROM vblite"
mysqlimport -uroot vblite \vblite.sql
echo Reset complete

Output:

C:\>resvblite
Resetting vB Lite Demo Board on localhost...
ERROR 1046 at line 1: No Database Selected
mysqlimport: Error: Table 'vblite.vblite' doesn't exist, when using table: vblite
Reset complete

[Mark Hensler]

I think I gave you the wrong syntax... sorry

mysql -uUser -pPassword -e "DELETE FROM table_name" database_name

[Admin]

Or just put EVERYTHING in the vblite.sql file...
Start it with:
USE database_name;
Then proceed with the DELETE FROM queries, and then the import queries.