leertaste Posted March 22, 2013 Group: Members Topic Count: 41 Topics Per Day: 0.01 Content Count: 137 Reputation: 1 Joined: 02/02/13 Last Seen: July 18, 2019 Share Posted March 22, 2013 I used SQL eAthena for a long timeBut now, after long time, I want to change to rAthena... My problem is:Is it possible to export my SQL Tables to my new rAthena shemata?(using sql query)And if it is, how does it works? Quote Link to comment Share on other sites More sharing options...
Euphy Posted March 22, 2013 Group: Members Topic Count: 72 Topics Per Day: 0.02 Content Count: 2997 Reputation: 1130 Joined: 05/27/12 Last Seen: June 1, 2017 Share Posted March 22, 2013 Run all the scripts in the trunk/sql-files/upgrades/ directory, in ascending order. 1 Quote Link to comment Share on other sites More sharing options...
Lemongrass Posted March 22, 2013 Group: Developer Topic Count: 28 Topics Per Day: 0.01 Content Count: 547 Reputation: 270 Joined: 11/08/11 Last Seen: April 23 Share Posted March 22, 2013 I did it by using a SELECT INTO statement. For example: INSERT INTO `item_db_re` SELECT * FROM `item_db`; But notice that the column count and column types should be the same, which is not a problem for most tables. Quote Link to comment Share on other sites More sharing options...
leertaste Posted March 22, 2013 Group: Members Topic Count: 41 Topics Per Day: 0.01 Content Count: 137 Reputation: 1 Joined: 02/02/13 Last Seen: July 18, 2019 Author Share Posted March 22, 2013 Can you give some more examples so I have a better guess? Quote Link to comment Share on other sites More sharing options...
leertaste Posted March 22, 2013 Group: Members Topic Count: 41 Topics Per Day: 0.01 Content Count: 137 Reputation: 1 Joined: 02/02/13 Last Seen: July 18, 2019 Author Share Posted March 22, 2013 I want all tables from eAthena transfered to rAthenafor example my char_tablemy storage_tableeverything..someone knows how to do? Quote Link to comment Share on other sites More sharing options...
leertaste Posted March 23, 2013 Group: Members Topic Count: 41 Topics Per Day: 0.01 Content Count: 137 Reputation: 1 Joined: 02/02/13 Last Seen: July 18, 2019 Author Share Posted March 23, 2013 Simple, thanks Quote Link to comment Share on other sites More sharing options...
eJay Posted June 7, 2013 Group: Members Topic Count: 80 Topics Per Day: 0.02 Content Count: 325 Reputation: 76 Joined: 03/22/12 Last Seen: August 5, 2019 Share Posted June 7, 2013 (edited) What is the following step how to work this? Check if im wrong 1st step: Import the eathena sql, my back up files Then execute every in sql-files/upgrades to my ragnarok database? Edited June 7, 2013 by Kim Quote Link to comment Share on other sites More sharing options...
Question
leertaste
I used SQL eAthena for a long time
But now, after long time, I want to change to rAthena...
My problem is:
Is it possible to export my SQL Tables to my new rAthena shemata?
(using sql query)
And if it is, how does it works?
Link to comment
Share on other sites
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.