Page 1 of 1

Reboot needed

Posted: Sun Sep 06, 2009 5:06 pm
by uweyen
Server needs a reboot, everytime I zone into Sebilis I'm nude, relogged, zoned ina nd out, etc etc...

Can't turn in items for my 1.5 with it doing that.

Re: Reboot needed

Posted: Sun Sep 06, 2009 6:03 pm
by Jeido
It's like a plague! it's happening in Lguk, THF and Potranq now ><

Re: Reboot needed

Posted: Sun Sep 06, 2009 6:18 pm
by Lillu
seems like when I run a manual backup job with MySQL admin tool, it triggers some nude party..

rebooting now, thanks for posting.

Re: Reboot needed

Posted: Sun Sep 06, 2009 8:24 pm
by Shin Noir
it's because you're using a mysql backup tool!
http://www.pantz.org/software/mysql/mysqlcommands.html
[mysql dir]/bin/mysqldump -u username -ppassword --databases databasename >/tmp/databasename.sql

or if you're using winblows, windows key +r, cmd, go to dir of backup, assuming mysql bin path was added,
mysqldump -u username -ppassword --databases databasename > backupname.sql

clean and simple, can set up a scheduled task or cron job to auto backup too!
Though, I'm guessing your mysql admin tool does that already.

I'm confused how running a backup screwed up in game though, unless it's locking a table during the backups.. eep!

Re: Reboot needed

Posted: Sun Sep 06, 2009 9:12 pm
by Lillu
We have scheduled bacups in Navicat, and other weekly backup types too. I only use MySQL admin tool to have "other type" of backup, and cause I'm lazy to make a batch file.. :) guess I skipp that one or just run it when the db is offline. thanks tho!