pfarrell;451059 Wrote:
> Wow, that is harsh.
> Seems to me that would be classified as a install script bug, a big
> one.
>
> Years ago, I played directly with the database, which I remember is on
> some non-standard port. But I don't remember the details of how to even
> do that.
>
> (I've been using MySql professionally for a long time, so I can drive
> once the proper local SD voodoo is know.)
>
> Do you want to use mysql-admin to drop the database? or just
> mysql-client to drop all the tables?
>
> Is there a handy script to drop all the tables at once?
>
> This sure seems extreme to me.
Shouldn't one be able to perform the equivalent of a *full* wipe and
rescan simply by stopping the squeezeboxserver service, manually
deleting the /var/lib/squeezeboxserver/cache/MySQL/ directory and then
restarting the service? Won't sbs then recreate the directories, the db
and all the tables from scratch? Not as elegant as mucking with the db
using mysql-administrator on port 9092, I know, but I'd think it would
get the job done.
That said, to drop all the tables you should be able to use a query
based on the schema_1_down.sql file in
/usr/share/squeezeboxserver/SQL/mysql...something like:
Code:
--------------------
USE slimserver;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS metainformation;
DROP TABLE IF EXISTS unreadable_tracks;
DROP TABLE IF EXISTS rescans;
DROP TABLE IF EXISTS tracks;
DROP TABLE IF EXISTS playlist_track;
DROP TABLE IF EXISTS albums;
DROP TABLE IF EXISTS years;
DROP TABLE IF EXISTS contributors;
DROP TABLE IF EXISTS contributor_track;
DROP TABLE IF EXISTS contributor_album;
DROP TABLE IF EXISTS genres;
DROP TABLE IF EXISTS genre_track;
DROP TABLE IF EXISTS comments;
DROP TABLE IF EXISTS pluginversion;
DROP TABLE IF EXISTS progress;
DROP TABLE IF EXISTS tracks_persistent;
--------------------
--
gharris999
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=66972
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
