eATHENA to rATHENA Help!

[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 August 11, 2012 by SkyPirate

[Emistry]

http://rathena.org/wiki/index.php?search=setup&title=Special%3ASearch

[Hercules]

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

Edited August 11, 2012 by SkyPirate

[Mystery]

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

[Xantara]

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.

[Hercules]

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

[Lighta]

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.

[Hercules]

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

[Lighta]

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.

[QQfoolsorellina]

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

[Hercules]

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

[Vach]

Are you planning on using MySQL item and mob databases?