Jump to content
  • 0
Sign in to follow this  
marcorogeeh

change my server from rathena to hercules

Question

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


 

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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'

Share this post


Link to post
Share on other sites
  • 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: dot.gif

 

#1060 - Duplicate column name 'flag'

 

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

Edited by marcorogeeh

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.