Jump to content
  • 0

eATHENA to rATHENA Help!


Hercules

Question


  • Group:  Members
  • Topic Count:  39
  • Topics Per Day:  0.01
  • Content Count:  104
  • Reputation:   1
  • Joined:  05/04/12
  • Last Seen:  

Hello rathena!!

I just want to transfer from eATHENA (TXT) to rATHENA (SQL)...

because many scripts are not working in eathena.

Please give me guides on installing rATHENA step by step.

Programs needed to run rATHENA and system requirements.

and specially how can I convert my files (CONFs,NPCs,DBs,etc..) ????

in capable of running my old files to rATHENA.

By the way im using eATHENA r14801 TXT,for now.. /heh

Hope that somebody help me..

Thanks in future!! /thx

Edited by SkyPirate
Link to comment
Share on other sites

11 answers to this question

Recommended Posts


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  


  • Group:  Members
  • Topic Count:  39
  • Topics Per Day:  0.01
  • Content Count:  104
  • Reputation:   1
  • Joined:  05/04/12
  • Last Seen:  

is there a program(s) that can be download that convert TXTs to SQLs?

Edited by SkyPirate
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  94
  • Topics Per Day:  0.02
  • Content Count:  2192
  • Reputation:   252
  • Joined:  11/11/11
  • Last Seen:  

Only special files that are able to be converted to SQL is your item_db and mob_db. http://mysterious-pr...trunk/TxTtoSQL/ There is no file that I am aware of that can convert the mob_skill into SQL as of yet.

Check the post below for mob_skill ;3

Edited by Mysterious
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  243
  • Reputation:   206
  • Joined:  11/28/11
  • Last Seen:  

Should hopefully work for item, mobs, and mob skills. Let me know if it doesn't so that I can update/fix it.

You can try using this TXT2SQL Converter program: [Xantara]_rA_text2sql_v1.2.0.zip

Edited by Xantara
Updated text2sql for v1.2.0 download link for rAthena SVN r16639. Use v1.1.0 if using previous revision.
  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  39
  • Topics Per Day:  0.01
  • Content Count:  104
  • Reputation:   1
  • Joined:  05/04/12
  • Last Seen:  

SIr I can't use MySQL Workbench v.5.2 because it requires windows xp sp3 but I only use SP2.

So I can only use is MYSQL Workbench v.5.1?? Can I install rATHENA using this version??if yes,HOW??

Please replay asap. /thx

Only special files that are able to be converted to SQL is your item_db and mob_db. http://mysterious-pr...trunk/TxTtoSQL/ There is no file that I am aware of that can convert the mob_skill into SQL as of yet.

Check the post below for mob_skill ;3

/thx I only mean there is the DBs sorry I forgot to mention /sry

Edited by SkyPirate
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.00
  • Content Count:  737
  • Reputation:   216
  • Joined:  11/29/11
  • Last Seen:  

my only tool would be :

"LOAD DATA INFILE '%s' INTO TABLE %s FIELDS TERMINATED BY ','"

Then you spécify you file and table and here you go, possibly you can dump the able afterward to make a .sql save.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  39
  • Topics Per Day:  0.01
  • Content Count:  104
  • Reputation:   1
  • Joined:  05/04/12
  • Last Seen:  

my only tool would be :

"LOAD DATA INFILE '%s' INTO TABLE %s FIELDS TERMINATED BY ','"

Then you spécify you file and table and here you go, possibly you can dump the able afterward to make a .sql save.

what program should i use?? MySQL Administrator,Query Browser,workbench v.5.1(because 5.2 does not work on my OS) or ????

and where i will put this line?? on what program??

"LOAD DATA INFILE '%s' INTO TABLE %s FIELDS TERMINATED BY ','"

SORRY IF I HAVE MANY QUESTIONS because im only new in SQLs,MySQL and rATHENA.. so please understand

/thx

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.00
  • Content Count:  737
  • Reputation:   216
  • Joined:  11/29/11
  • Last Seen:  

that just an sql query, so you jut need an mysql client to use it. Wich you probably do if you using mysql.

As an exemple from terminal :

"mysql -u user -p pass ragnarok_db"

we connect to our mysql server using id=user and pass=pass to db ragnarok_db.

"LOAD DATA INFILE '.\db\re\item_db.txt' INTO TABLE `item_db` FIELDS TERMINATED BY ','"

we read all item_db.txt field and put them into item_db table (remenber to check the file path).

From this point you're done since you just wanted to use your txt db into mysql, anyway if you want backup or an .sql file you still can do afterward.

"exit"

Quit mysql old connection.

"mysqldump -u -p ragnarok_db item_db > sql_files\item_db.sql"

Here you create a sql files for the table, so basically you've "converted" txt into sql. Seem longer like that but it's actually just 2 command and you're sure that the field are correct in db otherwise you'll get an sql error.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.01
  • Content Count:  587
  • Reputation:   104
  • Joined:  11/19/11
  • Last Seen:  

I suggest you to start a new beginning.it would be faster than debug

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  39
  • Topics Per Day:  0.01
  • Content Count:  104
  • Reputation:   1
  • Joined:  05/04/12
  • Last Seen:  

that just an sql query, so you jut need an mysql client to use it. Wich you probably do if you using mysql.

As an exemple from terminal :

"mysql -u user -p pass ragnarok_db"

we connect to our mysql server using id=user and pass=pass to db ragnarok_db.

"LOAD DATA INFILE '.\db\re\item_db.txt' INTO TABLE `item_db` FIELDS TERMINATED BY ','"

we read all item_db.txt field and put them into item_db table (remenber to check the file path).

From this point you're done since you just wanted to use your txt db into mysql, anyway if you want backup or an .sql file you still can do afterward.

"exit"

Quit mysql old connection.

"mysqldump -u -p ragnarok_db item_db > sql_files\item_db.sql"

Here you create a sql files for the table, so basically you've "converted" txt into sql. Seem longer like that but it's actually just 2 command and you're sure that the field are correct in db otherwise you'll get an sql error.

O_o can't understand this.. sorry im so dumb.please elaborate or can u give me an image demonstration?? please

I suggest you to start a new beginning.it would be faster than debug

Start a new beginning???? debug??? argghhhh

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  21
  • Topics Per Day:  0.01
  • Content Count:  326
  • Reputation:   19
  • Joined:  09/27/12
  • Last Seen:  

Are you planning on using MySQL item and mob databases?

Link to comment
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.   Paste as plain text instead

  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.

×
×
  • Create New...