Restoring back up

Post Reply
Gratis
Posts: 55
Joined: Wed Jun 26, 2013 11:26 pm

Restoring back up

Post by Gratis » Mon Jul 08, 2013 12:32 am

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.

bluekirby0
Developer
Posts: 707
Joined: Sun Jul 22, 2012 12:11 am

Re: Restoring back up

Post by bluekirby0 » Mon Jul 08, 2013 10:03 am

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.

User avatar
whasf
Site Admin
Posts: 1312
Joined: Thu Jul 19, 2012 9:11 pm

Re: Restoring back up

Post by whasf » Mon Jul 08, 2013 6:10 pm

And backup the existing db, so you don't make things worse :)
-- Whasf

Gratis
Posts: 55
Joined: Wed Jun 26, 2013 11:26 pm

Re: Restoring back up

Post by Gratis » Tue Jul 09, 2013 2:00 am

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!

User avatar
whasf
Site Admin
Posts: 1312
Joined: Thu Jul 19, 2012 9:11 pm

Re: Restoring back up

Post by whasf » Tue Jul 09, 2013 5:59 am

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...
-- Whasf

bluekirby0
Developer
Posts: 707
Joined: Sun Jul 22, 2012 12:11 am

Re: Restoring back up

Post by bluekirby0 » Tue Jul 09, 2013 9:54 am

Sorry, if its not in the trunk we can't provide support for it.

Gratis
Posts: 55
Joined: Wed Jun 26, 2013 11:26 pm

Re: Restoring back up

Post by Gratis » Tue Jul 09, 2013 11:58 am

Could you point me in the right direction? Would it be in one of the tables or would it be a conf file?

bluekirby0
Developer
Posts: 707
Joined: Sun Jul 22, 2012 12:11 am

Re: Restoring back up

Post by bluekirby0 » Tue Jul 09, 2013 5:29 pm

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.

Post Reply