Hi, i need your help. I've many SAM running and sometimes i see a crash due to firebird database problem.
So if i try to restart sam it crash saying problem with database. I clear the db deleting it in database folder and create a new one. So after this i restore the old saved backup but it crashes ALWAYS !!!!
I've tried to use a tool to fix a db but nothing !!
It crashes..
I need to rebuild my radio station form the beginning !!!

Please help me i become crazy !!!!

Regards, Stefano.

Save yourself hours of aggravation and switch to mysql, at least you can repair a broken database.

_________________
- Rob Oyler, SVS

I've the same problem with some SAM and mySql ..!!!
I would like to know because a database breaks down ..!!!
I've only 10 folders with 2.000 music files.. ONLY Mp3 validated files.
Could you tell me ?? I run SAM on an external win10 cloud..

After a couple of months it stops..


Regards.
Stefano.

Are you saying the database is on a remote server but SAM itself is on a local computer?

_________________
- Rob Oyler, SVS

I 'll try to explain the problem.. I mean.. SAM is Working ..so I make a valid backup..
SAM crash random..
db is probably corrupted..
So i delete the old .fdb and run SAM so SAM create a new one..
OK !
Then i try to RESTORE the last saved backup but.. SAM CRASH !!!!

I'll become crazy..

Again, there is no need to reload a backup (generally) using mysql, it can be repaired

_________________
- Rob Oyler, SVS

Now i had a problem with an mySql sam..!!!
Could you tell me how can i do to repair the db ??
After many tries is back again but i'm afraid that happens again..
There's a way to check the db integrity..??
Thanks a lot.
Regards, Stefano.

So are you using FireBird or mySQL ? It looks like you are using FireBird.

Repairing a FireBird DataBase is almost impossible for a beginner to do. You should be using mySQL, which is much better than FireBird.

_________________
- DJ Dee
- Spacial Volunteer Support (SVS)
- Custom PAL services: www.palscripts.com
- http://www.AlternativeHD.com
- http://www.lahotcountry.com

I've some SAM with firebird and some with mySql..
NOW i've a problem with mySql database..
After many retries SAM is running now..!!! But i've many probs to reload correctly..
There's a way to check the mySql db integrity..??
Or a tool to repair ??
Now it's running but i'm afraid..

Thanks.

Use MySQL Workbench. There are tutorials on YouTube on how to use it.

_________________
- DJ Dee
- Spacial Volunteer Support (SVS)
- Custom PAL services: www.palscripts.com
- http://www.AlternativeHD.com
- http://www.lahotcountry.com

MyISAM Databases can be repaird using myisamchk commandline tool which operates on the database files even if the database server itself is completely gone.
There's a quick walkthrough in the FAQ how to use that tool.
Two thing to pay attention to: The version numbers have most likely changed and you need to find the right path to the MySQL executeables for your system.
The other thing is the Alias names for the MySQL service. I don't really know if MySQL still registers the short names for their services. You might need to disable the service using the Windows management engine GUI. (Right-Click computer -> select manage -> look for services -> find all mysql related stuff in the list and stop before running myisamchk and run it again after you're finished)

InnoDB databases shouldn't really run into these kinds of problems. They just revert to an old stable state at the next start of MySQL / your computer.

I'd opt for using MySQL Workbench whenever possible for users not familiar with the commandline anymore (If you were around before WinXP, you might at least have seen the commandline a few times already and know that you have to be careful to enter the exact words and properly quote stuff with spaces)

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

Shop for readymade PAL scripts by countrywesterndj - Or get a custom script made by me (or others)

My Project:
Send "Now Playing" from SAM to Twitter and/or Facebook | Sourcecode