change my server from rathena to hercules

M

marcorogeeh

New member
Messages
2
Points
0
Github
marcorogeeh
when i changed the server from rathena to hercules i found that rathena database "main.sql" which have all the players accounts dont work on hercules

when i open old account i fount to characters on the account

i want any way that i can change the rathena sql to hercules sql

when i open the server i found this

Code: 
: - detected 17 new SQL updates
[sql]: -- 'sql-files/upgrades/2013-02-14--16-15.sql'
[sql]: -- 'sql-files/upgrades/2013-02-15--18-06.sql'
[sql]: -- 'sql-files/upgrades/2013-03-05--01-05.sql'
[sql]: -- 'sql-files/upgrades/2013-03-06--00-00.sql'
[sql]: -- 'sql-files/upgrades/2013-03-09--01-56.sql'
[sql]: -- 'sql-files/upgrades/2013-04-16--01-24.sql'
[sql]: -- 'sql-files/upgrades/2013-10-09--21-38.sql'
[sql]: -- 'sql-files/upgrades/2013-10-10--16-36.sql'
[sql]: -- 'sql-files/upgrades/2013-10-27--16-47.sql'
[sql]: -- 'sql-files/upgrades/2013-10-30--19-53.sql'
[sql]: -- 'sql-files/upgrades/2013-10-30--21-12.sql'
[sql]: -- 'sql-files/upgrades/2013-10-31--07-49.sql'
[sql]: -- 'sql-files/upgrades/2013-11-09--00-03.sql'
[sql]: -- 'sql-files/upgrades/2013-11-15--00-06.sql'
[sql]: -- 'sql-files/upgrades/2013-11-15--19-57.sql'
[sql]: -- 'sql-files/upgrades/2013-11-16--07-49.sql'
[sql]: -- 'sql-files/upgrades/2013-11-18--08-23.sql'
[sql]: To manually skip, type: 'sql update skip <file name>'
in char server
Click to expand...
Click to expand...
 
execute the following files into your mysql db (phpmyadmin or whatsoever):

rAthena-main-upgrade.sql

rAthena-logs-upgrade.sql

and

  'sql-files/upgrades/2013-02-14--16-15.sql'

Code: 
: -- 'sql-files/upgrades/2013-02-15--18-06.sql'
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-03-05--01-05.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-03-06--00-00.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-03-09--01-56.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-04-16--01-24.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-10-09--21-38.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-10-10--16-36.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-10-27--16-47.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-10-30--19-53.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-10-30--21-12.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-10-31--07-49.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-11-09--00-03.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-11-15--00-06.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-11-15--19-57.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-11-16--07-49.sql'[/COLOR]
[COLOR=rgb(40,40,40)][sql]: -- 'sql-files/upgrades/2013-11-18--08-23.sql'[/COLOR]
 
u mean import ??

it says that

Error

SQL query:

ALTER TABLE `skill` ADD COLUMN `flag` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;

MySQL said:

#1060 - Duplicate column name 'flag'

when i imported the 2013-02-14--16-15.sql into ragnarok database
 

 
Last edited by a moderator:
first import rAthena-main-upgrade.sql and rAthena-logs-upgrade.sql

 
You must log in or register to reply here.
Back
Top