change my server from rathena to hercules

[marcorogeeh 0]

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

: - 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

 

[evilpuncker 503]

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'

: -- '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'

[marcorogeeh 0]

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
 

Edited April 20, 2016 by marcorogeeh

[evilpuncker 503]

first import rAthena-main-upgrade.sql and rAthena-logs-upgrade.sql