Ubuntu based server ERROR 1146 (42S02) at line 431: Table 'rathena.item_db' doesn't exist

[cEdge-01]

Hi,

I have an issue following the guide based on Ubuntu in github and when I put this line as directed:

'cat ./sql-files/*.sql | mysql -u rathena -p rathena'

I get this error : ERROR 1146 (42S02) at line 431: Table 'rathena.item_db' doesn't exist

Can you please assist me with this error message.

[Slammer]

are you use db sql? if yes import rathena.item_db on sql database

[cEdge-01]

10 minutes ago, Slammer said:

are you use db sql? if yes import rathena.item_db on sql database

I believe it is db sql(just purely following the guide written on the wiki). When you say import is it item_db.sql because I cannot see any rathena.item_db or where this is meant to come from.

Do you have an example of how to do so?

[Slammer]

4 hours ago, cEdge-01 said:

I believe it is db sql(just purely following the guide written on the wiki). When you say import is it item_db.sql because I cannot see any rathena.item_db or where this is meant to come from.

Do you have an example of how to do so?

at folder sql-files just import to database ragnarok.

like main.sql and log.sql

[cEdge-01]

I figured it out, Thank you!

It turns out they have to be imported in a particular order.

This is the proper order that works:
cat ./sql-files/item_cash_db.sql | mysql -u rathena -p rathena
cat ./sql-files/item_cash_db2.sql | mysql -u rathena -p rathena
cat ./sql-files/item_db.sql | mysql -u rathena -p rathena
cat ./sql-files/item_db_equip.sql | mysql -u rathena -p rathena
cat ./sql-files/item_db_etc.sql | mysql -u rathena -p rathena
cat ./sql-files/item_db2.sql | mysql -u rathena -p rathena
cat ./sql-files/item_db_re.sql | mysql -u rathena -p rathena
cat ./sql-files/item_db_re_equip.sql | mysql -u rathena -p rathena
cat ./sql-files/item_db_re_etc.sql | mysql -u rathena -p rathena
cat ./sql-files/item_db_re_usable.sql | mysql -u rathena -p rathena
cat ./sql-files/item_db_usable.sql | mysql -u rathena -p rathena
cat ./sql-files/item_db2_re.sql | mysql -u rathena -p rathena
cat ./sql-files/mob_db.sql | mysql -u rathena -p rathena
cat ./sql-files/mob_db2.sql | mysql -u rathena -p rathena
cat ./sql-files/mob_db_re.sql | mysql -u rathena -p rathena
cat ./sql-files/mob_db2_re.sql | mysql -u rathena -p rathena
cat ./sql-files/mob_skill_db.sql | mysql -u rathena -p rathena
cat ./sql-files/mob_skill_db2.sql | mysql -u rathena -p rathena
cat ./sql-files/mob_skill_db_re.sql | mysql -u rathena -p rathena
cat ./sql-files/mob_skill_db2_re.sql | mysql -u rathena -p rathena
cat ./sql-files/main.sql | mysql -u rathena -p rathena
cat ./sql-files/logs.sql | mysql -u rathena -p rathena
cat ./sql-files/roulette_default_data.sql | mysql -u rathena -p rathena

Instead of 'cat ./sql-files/*.sql | mysql -u rathena -p rathena'

Edited May 30, 2022 by cEdge-01