[Tut]how to switch repacks/backup server files

[aznh4xer]

PLEASE NOTE BEFORE YOU DO THIS.
I DO RECOMMEND THAT YOU DO NOT DELETE YOUR PREVIOUS SERVER FILES AFTER YOU'VE BACKED UP UR ACCOUNTS, UNLESS YOU BACKED UP ALL UR SERVER FILES ON A SEPERATE BACKUP FILE.

and PLEASE READ IT THROUGH BEFORE YOU TAKE ANY ACTION

First go to MYSQL ADMIN

Then login id/pw....

Something pops up.

On the LEFT side it has the following...

Server Info,
Server Control,
Startup Variables...
-skips to Backup-

Now click Backup.
ALL your SQL folders will be there
e.g. information_schema , mysql, odinms, seanpack, test
( might not be called ODINMS depending on what your chose as the name )

NEXT
Click on the database you want...
E.g. odinms and click the ARROW > ( the > is found between schemata AND Backup Content) and all the tables/database should pop up under BACKUP CONTENT.

NEXT
Click odinms (or w.e. you named it...) and it should UNCHECK all the checks in the boxes.

NEXT
Now to backup the accounts...just click the accounts, buddies, characters, guilds, pets, skills, storages, and all quest stuff( Depending on what you want, totally up to you! )

NEXT
CLICK
Execute Backup Now and save it somewhere....

TO SWITCH REPACKS
Just execute the start the server like you did your previous server ( must change the Files of Type to ANY ...if u have..dont bug me. and then go to Open Script....find the saved account stuff/ guilds or w.e. and DO NOT RUN IT YET at around LINE 20-30 of the SQL that has the accounts and stuff it'll say...

CREATE DATABASE IF NOT EXISTS odinms;
USE odinms;

YOU MUST CHANGE THE NAME TO UR DATABASE NAME THAT YOU PUT IN THE DB.PROP and YOUR SCHEMA NAME. ( IF YOU DON't, it won't work...or possibly OVERWRITE the previous accounts even if the accounts have been UPDATED / got more stuff, played more...got new weaps, etc

In db.properties of your NEW repack change the NAME of the database...
url=jdbc:mysql://127.0.0.1:3306/odinms ( odinms is the database name) You should CHANGE IT just in case and DON'T delete your other server files in case you do MESS UP or the repack is BUGGED FILLED/ DOESNT WORK. Then when you make your schema name...make it MATCH the name you put in the db.properties or it will NOT WORK.

Then if they do match then EXECUTE and your done switching repacks !! CONGRATS DUDE/DUDET!!

To backup ALL ur server files make sure ALL of the boxes are checked in, in the BACKUP CONTENT - read the top dont bug me -

[MentaL]

[ClericKn1ght]

There is already a guide for backup server files =D but im not sure if there is a guide on how to switch repacks. Anyway GREAT GUIDE

[aznh4xer]

yeah i know that :P but ya know so you dont have to go around looking for it and thanks !

[Moogra]

Yes, very good guide.
Now stupid noobs won't come up to me and say that I killed their database. That's why my PMs are blocked

[aznh4xer]

lol to moogra...yeah the thing is i USE other database names depending on the repack or w.e. im using...for example yours...i name MOOGRA [then version], pcmaple23, seanpack59 w.e. etc...yeah and if ur reading this MAKE SURE TO FUCKEN CHANGE IT IN THE DB.PROPERTIES url=jdbc:mysql://127.0.0.1:3306/odinms <-- CHANGE ODINMS TO THE DATABASE NAME YOU USED.

oh yeah to any that can maybe fix this problem...
notes for this...other ppl can connect to my server...but one of my friends cant..yes they have v55 ms...yes they have my localhost..yes they have my bat file...yes they have the same operating system...firewall down...its a really weird problem i think :P...and heres the screenie...ip blocked for security reasons...thank you. http://i120.photobucket.com/albums/o...xer/help-1.jpg pic also in attachment. and i do not get any error when others or i connect.... :[

[shadowerr]

erm hey... does this work when shifting from 0.55 to other version?

[GodlyStan]

Are you supposed to delete your old repack then use the new one you downloaded?

[jcreden]

Ty, very nice guide helped me alot. =D