Page 1 of 1

Restoring back up

Posted: Mon Jul 08, 2013 12:32 am
by Gratis
I somehow found myself taking over a private server that was closing. The owner provided me with a back up of the server, but I am at a loss on how to restore it.

I can create and run a server just fine, internally, externally has been another issue. Can someone please point me in the right direction? Thank you in advance!

I also get this error when trying to connect when I set it up for public. Yes I changed maps in DB, but no one can connect.

Re: Restoring back up

Posted: Mon Jul 08, 2013 10:03 am
by bluekirby0
Did you follow the wiki setup guide first and foremost?

Second, when restoring the backup, you should just be able to redirect the backup file as input into mysql.exe i.e.

Code: Select all

mysql dbname -u user -ppassword < backup.sql
I would recommend setting up at least accounts and permissions as per the guide before you do this though.

Re: Restoring back up

Posted: Mon Jul 08, 2013 6:10 pm
by whasf
And backup the existing db, so you don't make things worse :)

Re: Restoring back up

Posted: Tue Jul 09, 2013 2:00 am
by Gratis
Back up restored! But previous server had account registration via website now when we try to create new characters we get the error

ERROR::Account could not be created!
ERROR::The username is already taken

Is there any way to fix this? Thank you in advance!

Re: Restoring back up

Posted: Tue Jul 09, 2013 5:59 am
by whasf
Gratis wrote:Back up restored! But previous server had account registration via website now when we try to create new characters we get the error

ERROR::Account could not be created!
ERROR::The username is already taken

Is there any way to fix this? Thank you in advance!
You're on your own, we don't have an account registration website system...

Re: Restoring back up

Posted: Tue Jul 09, 2013 9:54 am
by bluekirby0
Sorry, if its not in the trunk we can't provide support for it.

Re: Restoring back up

Posted: Tue Jul 09, 2013 11:58 am
by Gratis
Could you point me in the right direction? Would it be in one of the tables or would it be a conf file?

Re: Restoring back up

Posted: Tue Jul 09, 2013 5:29 pm
by bluekirby0
It *should* be in the the accounts and/or chars tables but again, we know nothing about the account system you are using or if it patches the code in any way to modify the expected behavior.