how to save database values from my ragnarok schema?

[joelolopez]

hi im using mysqlquery browser to browse my database. my problem is everytime my server unexpectedly shutdown my sql database is getting database errors. is there a way that i can save the values of my tables so that i can backup the values from my schemas and tables?

 

example values

 

in login table

username |    password,    < fields

hotshot     | hotshotpass     < values that i need to backup

 

is it possible to backup the values and import them again on my server whenever my database is broken and need to be fixed?

 

 

 

[Antares]

On linux we simply use

mysqldump -u[user] -p[pass] "schema" | gzip > "filename.gz"

I guess theres something similar on windows as well.

You may add this into a batch/bash script and add it to a task scheduler to run it frequently, and create another task that deletes the old backups (if neccessary)

You can refine it if you wish to dump specific table(s).

Also, if you write a crash detect script (log check), you can import the backup automatically, and restart the server.