[Updating with sql and backup]

[Germo]

Hi. I have spent alot of time getting my server running as nicely as i could, but we all know there is always a bug or 2 to be fixed, and thats why we use the sql updates or use a newer version of Ascent core.

Since i have spent so many hours on getting npc working right with new spawns, waypoints, speech, hp, damage, etc etc, and alot of new objects has been made into the world, i would like to know if someone really knows this, there proberly is, which table they are backing up by name, i already have a backup program running on my world, and i know that accounts characters, creature_proto need to be backed up, not to loose all the changes i made to npc.

But lets say, that i want to keep using the sql updates, and new core updates, and dont want to loose all of the hard work i made, could someone tell me excatly which table they will back up, before using sql updates, so i wont loose alot of hard work. i know some of the tables, but iam not sure how many, and which ones i need to backup, besides the ones i already mentioned.


Germo

[MentaL]

[Germo]

No one knows this..? I just dont want to overwrite my tables, but i still want to use sql updates. or are you guys who knows this, copying lines inside the tables and inside the new updated tables..?

Germo

[Germo]

Hmm.. Nobody knows this..??

[titus4k]

i've been posting this in another board, but might help you here too:

i only found mysqldump as a possible solution, but its not perfect. from within a command window (cmd.exe), try for example:

mysqldump.exe -u USER -p PASSWORD ncdb creature_names --skip-extended-insert --compact -t --where 'entry between 1000 and 2000' > my_creature_names.sql

this will dump all entries between 1000 and 2000 from table=creature_names and DB=ncdb into a file called my_creature_names.sql
since db structure has been changed a bit, you have to edit my_creature_names.sql to fit the new db structure.
editing depends on the table you are dumping, not all have changed.
after installing a 2.3 compatible db and editing your my_...sql files, you can import them in the new 2.3 DB.
also have a look at new ascent.conf feature: ascent.conf:

# Additional Table Binding
# You can load static item/creature/etc data into the server using this directive.
# This way throughout database updates your custom data can be preserved.
# Format: "sourcetable destination table,sourcetable destinationtable"
# Example: "myitems items,mynpcs creature_names"
# Default: ""
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Startup Preloading = "0"
BackgroundLootLoading = "1"
EnableMultithreadedLoading = "1"
LoadAdditionalTables="">

you can create a table called my_items with the exact structure of items, and insert your own item into it (my_items).
then change:

LoadAdditionalTables=""

into:

LoadAdditionalTables="my_items items"

so next time you update your world db , you dont have to worry about your items anmore.

creatures/npc uses more than one table (creature_names, creature_proto ...) so you have to find the entries you has been entered yourself and dump them as describes above, using mysqldump.

t4k

[Germo]

Wow many thanks. This i can use. Thanks for sharing this . this is so kind of you.
Iam still a noOb in sql, but iam learning by doing, and this i think i can do :-) thanks gain.

Germo