Problem with Sambc/MYSQL

[jerryc]

This morning I awoke to find that my station went offline. In the event log it states "unhandled exception (table'.\samdb\queuelist' is marked as crashed and should be repaired"

 

I found some repair commands to input but I cannot get the command prompt to open so I can input the commands. Any suggestions?

Jerry

[SmoothJazz]

Windows7? enter cmd.exe in the search that is the command prompt what do you mean you cannot get it to open?

[jerryc]

The black box will open then immediately close. I have Xp pro with service pack 3. I am not a very computer savy person, so please forgive me if I seem ignorant.

Jerry

[shoutcaststreaming]

1) Log out of SAM.

 

2) from a DOS prompt enter:

 

net stop mysql

c:/mysql/bin/myisamchk -r -f c:/mysql/data/samdb/*.myi

net start mysql

 

3) Restart SAM

 

>>>>>>>>>>>>>>>>>>>>>

 

You have to do this in a command prompt. If you can't get it open, reboot and try again.

 

NOTE: Change the mySQL location to your actual location, it may be different.

[djgary72]

"unhandled exception (table'.\samdb\queuelist' is marked as crashed and should be repaired"

 

 

I used to get those SQL errors like that all the time with SAM.......since i moved to RadioDJ i haven't had any SQL errors...... Maybe a change of software with a more robust SQL would help.

[SmoothJazz]

for XP

 

1. Click Start.
   

1. Click Run.
   

1. Type cmd or command and press enter.
   

Then follow Shoutcaststreaming's step-by-step.

[jerryc]

Thanks everyone for the help, unfortunately something was wrong with the hard drive or O/S and the entire system crashed this morning. Hopefully my IT guy can get everything back. He did say he could not copy the msql file from the hard drive. Is that going to be a big problem or do I simply import my playlist again and make all the changes in Sam? Thanks everyone again for taking the time to help me out.

 

Jerry

[James]

Moved to appropriate section.

[BWorld]

Thanks everyone for the help, unfortunately something was wrong with the hard drive or O/S and the entire system crashed this morning. Hopefully my IT guy can get everything back. He did say he could not copy the msql file from the hard drive. Is that going to be a big problem or do I simply import my playlist again and make all the changes in Sam? Thanks everyone again for taking the time to help me out.

 

Jerry

 

I, once a month, save all the ID3 tags so that if my SAM were to crash I could import the songs back in. I ALWAYS keep 2 copies of my songs. One on a DEDICATED internal HD, and one on a backup external HD. I also backup my SAM DB and website to both of those drives weekly...just in case!

[jerryc]

I do have the songs backed up on another hard drive, but a lot of the track titles, and other information I had to input. It was a lesson hard learned about backing up data. Hopefully I will get off auto dj and get back to streaming today. Thanks again for all the help and information.

Jerry

[jerryc]

Hey everyone got my computer back today, hard drive took a crap. I reinstalled everything and Im still getting the same error message. I tried doing what shoutcast reccommended, but it says the file path is wrong. Im not that savy so Im not sure where to go from here. I may uninstall and just go with the firebird that comes with Sam BC. Not sure what to do. Thanks

Jerry

[shoutcaststreaming]

Like I said in my post, you need to know what folder your mySQL data base resides.

 

You can search for it in a command prompt:

 

dir samdb.* /s/p

 

Make sure you display hidden folders.

[isaacl]

You can also run a SQL script from MySQL Workbench, using something like this in the query area:

 

use samdb;

check table adz;
check table category;
check table categorylist;
check table disk;
check table event;
check table eventtime;
check table fixedlist;
check table fixedlist_item;
check table historylist;
check table queuelist;
check table requestlist;
check table songlist;
repair table adz;
repair table category;
repair table categorylist;
repair table disk;
repair table event;
repair table eventtime;
repair table fixedlist;
repair table fixedlist_item;
repair table historylist;
repair table queuelist;
repair table requestlist;
repair table songlist;
optimize table adz;
optimize table category;
optimize table categorylist;
optimize table disk;
optimize table event;
optimize table eventtime;
optimize table fixedlist;
optimize table fixedlist_item;
optimize table historylist;
optimize table queuelist;
optimize table requestlist;
optimize table songlist;

 

You probably only need the repair part for each table, but I run 'em all once I'm doing it...

Hope that helps.