SQL question (sq lite)

[Scooby]

Is is possible to save a database manually?

several times now ive had server crashes (its very rare nowdays) and lose all the data since the server was

last started. so rather than me restarting the server to save the db is there a way to do this with a command?

[Castillo]

As far as I know, is not required to "save" the database.

[Scooby]

well i always lose data when the server crashes, from what i can gather think the sql db only saves on shutdown

so if the dedi crashes or the server.exe crashes all new data since the server started is lost.

luckily for me, after losing so much data time and time again, i moved a lot over to xml

but with new scripts i find i want to save more stats and i think right now its on the limits...

and i dont wanna risk adding any more to sql coz i keep losing data.

i guess i'll have to carry on as it is for now. thx for the quick reply

[Castillo]

Maybe you should consider moving to MySQL.

[Scooby]

i have so many stats being saved i dont even think it would be possible to move now.

also, i know nothing about MySQL.

[Cadu12]

It is possible move to MySQL. I made my own account system.

[Scooby]

ok well it maybe something for me to look into in the near future then.

thanks for ur replies.