How do I backup and restore the accounts and their characters?

[kingdutka]

Ok, I've got my private server up and running and everyone can connect. I really need to know how to backup the accounts I've created and how I would restore them. I would also like to know how to backup and restore individual characters. I will need a uber n00bie guide detailing every click of the process. I am using the software listed in a guide I found on this forum:

http://www.d3scene.com/forum/wow-pri...html#post18005

Thanks in advance to all you wonderful peoples!

[seravin]

Umm Copy all the files and put em some where else to back it up i guess..but note the word guess =P just yeah..like i have my wow installed on 4 computers so if one gets bugged, no big deal =D.

[kingdutka]

Exactly which files do I copy though? All I want to back up is my accounts and characters for my private server. If the client crashes, that doesn't bother me at all. I also have the game installed on 4 PC's. I am asking about the server backup.

[yugimuto1987]

I would like to know regarding this backup and restoring too :biggrin:

Additionally, how do i reset the server to the original state? Meaning, right now i had been playing the server with my friends and it is on beta testing, when I officially launched my server, I would like to reset the server, fearing some my friend who are GM might simply spawn bosses on unwanted spot...

[kingdutka]

Originally Posted by kingdutka

Exactly which files do I copy though? All I want to back up is my accounts and characters for my private server. If the client crashes, that doesn't bother me at all. I also have the game installed on 4 PC's. I am asking about the server backup.

Someone out there *has* to know this... please?

[nasapunk88]

This is not mine, i got it with a download but it worked for me with mangos server . Create a .bat file (edit it to ur user name, password, etc) and run:

@ECHO OFF
rem Create the date and time elements.
For /f "tokens=1-8 delims=:/-., " %%i in ('echo exit^|cmd /q /k"prompt $D $T"') do (
For /f "tokens=2-4 delims=/-,() skip=1" %%a in ('echo.^|date') do (
set dow=%%i
set %%a=%%j
set %%b=%%k
set %%c=%%l
set hh=%%m
set min=%%n
set ss=%%o
)
)

SET TDATE="%yy%%mm%%dd% %hh%%min%%ss%"
SET DBUSER=root
SET DBPASS=mangos
SET MDBNAME=mangos
SET RDBNAME=realmd
SET MYPATH="C:\Program Files\MySQL\MySQL Server 5.0\bin"

ECHO EXPORTING ACCOUNTS BACKUP...
ECHO.
%MYPATH%\mysqldump.exe --user=%DBUSER% --password=%DBPASS% --opt %RDBNAME% account ip_banned realmcharacters realmlist > realmd_char.%TDATE%.sql
%MYPATH%\mysqldump.exe --user=%DBUSER% --password=%DBPASS% --opt %MDBNAME% auctionhouse character character_action character_aura character_gifts character_homebind character_instance character_inventory character_kill character_pet character_queststatus character_reputation character_ticket character_social character_spell character_spell_cooldown character_tutorial guild guild_charter guild_charter_sign guild_member guild_rank item_instance item_text mail corpse group group_member instance arena_team arena_team_member > mangos_char.%TDATE%.sql
ECHO.

ECHO COMPLETED
ECHO.
pause

[kingdutka]

Originally Posted by nasapunk88

Create a .bat file (edit it to ur user name, password, etc) and run:

I don't know how to do this. I can create a .bat file, but where do I put it, when do I run it, where do I run it from, should my WoW server be on or off, and how do I "edit it to my user name, password, etc" and is that supposed to be my Windows user name/password or my WoW account user name/password? I have no idea what to do.

Like I said in my first post, I need an "uber n00b" guide to backing up my private server accounts detailing EVERY mouse click and every key pressed. I need it to tell me how to backup the accounts AND restore said backup. I need it all written in a way that even a 12 year old could figure out. Thanks!

[nasapunk88]

Ok well the first thing is that all versions of servers are different. If ur using antrix or mangos it makes a difference. I've just been playing around and editing on the fly but id be glad to help.. If u would let me know information about where/what type of database ur using (or the link to the guide u used exactly) ill get working on trying to make one for u =)

[kingdutka]

This is the guide I used for installing my server: http://www.d3scene.com/forum/wow-pri...html#post18005

THANKS!! You ROCK!

[nasapunk88]

ok that makes it easier =) ..ill assume u used everythin that guide did ...username=root.....password=mangos...the database name=mangos..and realm database name=realmd

to make this .bat file...open up a txt editor...Notepad =)
copy and paste the code i showed above (from @ECHO to pause)

now scroll down to the part where it says
SET MYPATH="C:\Program Files\MySQL\MySQL Server 5.0\bin"

Determine where u installed ur MySQL server and open till the folder named "bin" (the C:\Program Files\MySQL\MySQL Server 5.0\bin should be default i believe) and if its not exactly like that paste it over the one i put in.

now Save it where ever u would like to store ur backup files with the name as ***.bat .........where *** is anything u want... (for example Save as name: backup_character.bat)

open up where u saved it and it should now be a .bat and not a .txt file....double click (run it) and it will Backup ur data to a mangos_char database and ur realmd_char database with the date included in the file name..

so all u have to do is restore those .sql files and ur backup characters should be there

hope that all made sense =-)