Convert database to Hercules

bWolfie

I'm the man
Messages
850
Points
0
Location
Alberta, Midgard
Github
bWolfie
Emulator
Hello Hercules,

I am asking on behalf of somebody. Our server wants to move its database to Hercules. We are a very old server, still running eAthena. I'm unsure of the logistics, but our server's database is very large. The server has racked up 7-8 years of data. We have already begun moving all our scripts, soon we want to move server info like accounts and stuff.

Please, I am looking for any advice. I'm a little scared something will go horribly wrong. I'm not hugely clued in on the operation, but the conversion/upgrade is the SQL database and such where account, char info, etc. is stored.

Thank you.

 
I did this a couple months ago and it worked great.

First, you need to import all of eAthena SQL updates. You can find them in eAthena's repository : https://eathena-project.googlecode.com/svn/trunk/sql-files/

After that, you import "eAthena-main-upgrade.sql" from Hercules' repository. You can find it here : https://github.com/HerculesWS/Hercules/blob/master/sql-files/upgrades/eAthena-main-upgrade.sql

You can do the same with "eAthena-logs-upgrade.sql" if you want to keep your old logs : https://github.com/HerculesWS/Hercules/blob/master/sql-files/upgrades/eAthena-logs-upgrade.sql

After this is done, you run all Hercules SQL updates from the repository : https://github.com/HerculesWS/Hercules/tree/master/sql-files/upgrades

As I said, I moved from eAthena to Hercules a couple months ago and it worked fine! Just backup your database in case you make an error.

 
Last edited by a moderator:
Thank you 
default_wub.png


 
Back
Top