Updating Tables from updates posted

[dniheb]

I searched around on the forums and tried to find a post on how to update the tables from the files that people upload here as far as the text files and the .s files. I tried to use the import wizard in navicate but it wouldn't show the fields from the text file. i.e. the abyvunkl.txt file to update the zone. If someone could point me to a post or a wiki on this I would appreciate that. Thanks you in advance.

[dniheb]

In case anyone is new to all this and is struggling with this as I was / am here is how I figured it out (not sure if it the 100% accurate way to do it XD) But in my case in navicat Right click on Tables (not the table you are trying to update but the tables that is under the dspdb in the left hand side of Navicat) Then left click on execute sql script browse to the file that contains the table updates. Note if it is anything other then a *.sql file you will have to click the drop down and change it to All Files. Then choose the txt or .s file and click start and it should pull the data in. This way has been working for me. That being said I would back up my data first before trying what might be a ghetto newbie sql faux pas sable hack.

[kjLotus]

In case anyone is new to all this and is struggling with this as I was / am here is how I figured it out (not sure if it the 100% accurate way to do it XD) But in my case in navicat Right click on Tables (not the table you are trying to update but the tables that is under the dspdb in the left hand side of Navicat) Then left click on execute sql script browse to the file that contains the table updates. Note if it is anything other then a *.sql file you will have to click the drop down and change it to All Files. Then choose the txt or .s file and click start and it should pull the data in. This way has been working for me. That being said I would back up my data first before trying what might be a ghetto newbie sql faux pas sable hack.

that's the normal way of doing it (it's the exact process described in the setup guide :p)

however, it does it by dropping the table and then readding it. for most tables (game data) it's okay, but for any tables relating to character data you would probably want to edit them manually (right click the table, design table, make it match what's changed in the .sql file)

[dniheb]

I knew it had to be posted somewhere XD my search skills are not what they used to be that and I jump around doing a million things at once instead of focusing on one thing XD. Thanks for your help and all your hard work you guys do a awesome job