This is the batch file I'm using to do a complete wipe of the DB. I'm
running under windows and I'm using a full version of MySQL, so you'll
have a fair amount of adapting to do from this:
Code:
--------------------
@echo off
Echo Ready to clear tables and rescan...
net stop slimsvc65
c:
cd "C:\Program Files\SlimServer65\server\SQL\mysql"
cd
"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe" --user=slimserver
--password=slimserver --database=slimdata65 --execute="\. schema_1_down.sql"
"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe" --user=slimserver
--password=slimserver --database=slimdata65 --execute="\. schema_2_down.sql"
"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe" --user=slimserver
--password=slimserver --database=slimdata65 --execute="\. schema_1_up.sql"
"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe" --user=slimserver
--password=slimserver --database=slimdata65 --execute="\. schema_2_up.sql"
rem "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe" --user=slimserver
--password=slimserver --database=slimdata65 --execute="\. schema_clear.sql"
C:\Perl\bin\perl.exe "C:/Program Files/SlimServer65/server/scanner.pl"
--rescan --cleanup
rem net start slimsvc65
cd "C:\Program Files\SlimServer65\server\SQL\mysql"
cd
"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe" --user=slimserver
--password=slimserver --database=slimdata65 --execute="\. schema_optimize.sql"
net start slimsvc65
pause
--------------------
--
gharris999
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=26342
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/beta
