Well, the routines are there in SC to wipe the db. Here is a script
that gets fired on my server in the wee hours of the am, just as the
server is shutting down. It wipes the db so that the schema is
recreated and the whole library gets scanned when the server starts
itself up the next am:
Code:
--------------------
#!/bin/sh
cd /usr/local/slimserver_trunk/server/SQL/mysql
mysql --user=slimserver --password=slimserver --database=slimserverdata
--execute="\. schema_1_down.sql"
mysql --user=slimserver --password=slimserver --database=slimserverdata
--execute="\. schema_2_down.sql"
mysql --user=slimserver --password=slimserver --database=slimserverdata
--execute="\. schema_5_down.sql"
--------------------
I'm still adding music to my system on an almost daily basis, so this
works for me.
I've got my server configured to use a separate instance of MySQL, not
the one bundled with SC. Also, this installation is running off the
latest trunk code via SVN. The installation is getting a little long
in the tooth at this point and doesn't reflect recent practices.
--
gharris999
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=41081
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/beta
