Hi,i am looking for a light relational database server with the ability to recover after a crash.I am not looking for sqlite or any other single file db system.
MySQL is very popular. But I don't know what you mean by "light". Its either SQL compliant or it isn't. I also don't know about its ability to recover after a crash. Since its so popular I can only assum that it can do it.
MySQL yes my choice too. Used it for years serious bit of kit, plenty of support on their forums & load of programming examples out there.
If at any time you need to go with a full blown relational database server this one is a serious contender and you wound not be wasting your time learning MySQL.
with the ability to recover after a crash
Depending on what your definition of crash means, yes you can administer MySQL remotely, & it's Free...