Navicat problem

[Ciprian 0]

Hello,

When I tried to modify something in Navicat, for example at 70038 item, I want to change value1 from 20 at 100. I change this value and save, after that when I give reboot at server and check again the db from SQL, the value is on 20... also I tried to export the intem_proto from Navicat and put intem_proto.txt in WinSCP, than I tried to start the client and connection is refused in this case... What I did do wrong? 

[TMP4 6919]

10 hours ago, Ciprian said:

Hello,

When I tried to modify something in Navicat, for example at 70038 item, I want to change value1 from 20 at 100. I change this value and save, after that when I give reboot at server and check again the db from SQL, the value is on 20... also I tried to export the intem_proto from Navicat and put intem_proto.txt in WinSCP, than I tried to start the client and connection is refused in this case... What I did do wrong? 

A metin2 server by default reads the item_proto from item_proto.txt (unless you use very old serverfile, or you or your serverfile's author did not modify it). So if you change anything in the mysql, it gets overwritten every time you start your server.

"I tried to export the intem_proto from Navicat and put intem_proto.txt in WinSCP"
It's a bad approach since an sql file and the item_proto.txt (csv just with tabs) are totally different file. If you exported it to csv, that's bad too because while you have numbers on item_proto table, you have names in item_proto.txt (for example antiflags ANTI_DROP, ANTI_MYSHOP vs number like 1,4,8,16 etc).

Edit item_proto.txt directly, and forget about the mysql proto.
If you want to use mysql proto (I'm not advising it) then: https://metin2.dev/topic/3198-db-no-txt/

 

Edited January 20 by TMP4