Hercules Posted August 11, 2012 Group: Members Topic Count: 39 Topics Per Day: 0.01 Content Count: 104 Reputation: 1 Joined: 05/04/12 Last Seen: November 16, 2012 Share Posted August 11, 2012 (edited) 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.. Hope that somebody help me.. Thanks in future!! Edited August 11, 2012 by SkyPirate Quote Link to comment Share on other sites More sharing options...
Emistry Posted August 11, 2012 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2369 Joined: 10/28/11 Last Seen: 23 hours ago Share Posted August 11, 2012 http://rathena.org/wiki/index.php?search=setup&title=Special%3ASearch Quote Link to comment Share on other sites More sharing options...
Hercules Posted August 11, 2012 Group: Members Topic Count: 39 Topics Per Day: 0.01 Content Count: 104 Reputation: 1 Joined: 05/04/12 Last Seen: November 16, 2012 Author Share Posted August 11, 2012 (edited) is there a program(s) that can be download that convert TXTs to SQLs? Edited August 11, 2012 by SkyPirate Quote Link to comment Share on other sites More sharing options...
Mystery Posted August 11, 2012 Group: Members Topic Count: 94 Topics Per Day: 0.02 Content Count: 2192 Reputation: 253 Joined: 11/11/11 Last Seen: June 24, 2020 Share Posted August 11, 2012 (edited) 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 August 12, 2012 by Mysterious Quote Link to comment Share on other sites More sharing options...
Xantara Posted August 11, 2012 Group: Members Topic Count: 20 Topics Per Day: 0.00 Content Count: 243 Reputation: 206 Joined: 11/28/11 Last Seen: February 13, 2023 Share Posted August 11, 2012 (edited) 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 August 16, 2012 by Xantara Updated text2sql for v1.2.0 download link for rAthena SVN r16639. Use v1.1.0 if using previous revision. 1 Quote Link to comment Share on other sites More sharing options...
Hercules Posted August 12, 2012 Group: Members Topic Count: 39 Topics Per Day: 0.01 Content Count: 104 Reputation: 1 Joined: 05/04/12 Last Seen: November 16, 2012 Author Share Posted August 12, 2012 (edited) http://rathena.org/w...=Special:Search 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. 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 I only mean there is the DBs sorry I forgot to mention Edited August 12, 2012 by SkyPirate Quote Link to comment Share on other sites More sharing options...
Lighta Posted August 12, 2012 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 737 Reputation: 216 Joined: 11/29/11 Last Seen: December 20, 2020 Share Posted August 12, 2012 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. Quote Link to comment Share on other sites More sharing options...
Hercules Posted August 14, 2012 Group: Members Topic Count: 39 Topics Per Day: 0.01 Content Count: 104 Reputation: 1 Joined: 05/04/12 Last Seen: November 16, 2012 Author Share Posted August 14, 2012 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 Quote Link to comment Share on other sites More sharing options...
Lighta Posted August 14, 2012 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 737 Reputation: 216 Joined: 11/29/11 Last Seen: December 20, 2020 Share Posted August 14, 2012 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. Quote Link to comment Share on other sites More sharing options...
QQfoolsorellina Posted August 14, 2012 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 587 Reputation: 105 Joined: 11/19/11 Last Seen: July 7, 2019 Share Posted August 14, 2012 I suggest you to start a new beginning．it would be faster than debug Quote Link to comment Share on other sites More sharing options...
Hercules Posted August 15, 2012 Group: Members Topic Count: 39 Topics Per Day: 0.01 Content Count: 104 Reputation: 1 Joined: 05/04/12 Last Seen: November 16, 2012 Author Share Posted August 15, 2012 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 Quote Link to comment Share on other sites More sharing options...
Vach Posted October 9, 2012 Group: Members Topic Count: 21 Topics Per Day: 0.00 Content Count: 326 Reputation: 19 Joined: 09/27/12 Last Seen: February 27, 2021 Share Posted October 9, 2012 Are you planning on using MySQL item and mob databases? Quote Link to comment Share on other sites More sharing options...
Question
Hercules
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..
Hope that somebody help me..
Thanks in future!!
Edited by SkyPirateLink to comment
Share on other sites
11 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.