Complete Loot Tables

[Fleyhum]

Hello this is my first time posting here but have been playing for awile i tried all db's out to get some sort of real loot table but most are way to incomplete so i made my own using websites for data of what mobs drop i have set about 20 or so zone with complete loot tables(high end zones planes,seb,vexthal,and such) but i was wanting to know how to export the db some friends like having all the drops but i have no idea of how to export my db can anyone help please(also will post it if anyone wants it )

[Trumpcard]

You want to dump the tables, you can use the mysqldump command


mysqldump <databasename> <tablename> > somefile

lets say you want to dump the lootdrop_entries table, you'd do
something like

mysqldump eq lootdrop_entries > lootdropentries.sql

then they could source those into their database.

To dump the ENTIRE database, just do

mysqldump <databasename> > filename

[Fleyhum]

Thanks that worked perfect one other question some of the top tier PoP items are not in db is there a better way to add them (i have just been making them by replacing cloth items)

[Graypaint]

Actually the PoP items all fit in between untaken spaces-I think theTwo Handed opalescent sword is 31231(or something) between a few other items, so no need to replace anything(although clothing hasn't been worn since luclin launched anyway /shrug)
PS.
Would you mind sharing the SQL?

[Fleyhum]

Thanks i just noticed that in all my time working on the db i never paid any attention to the fact that alot of id numbers are not present and i will share it as soon as i get proc's working none seem to show up on items i have created they show them on item but in game it doesnt show anything plus i need a few more spawns in pop zones for the pop armor drops i am only having patterns drop and setting trade skill levels to make the items kinda a slow process hand writing tradeskills :evil: but for some reason admin tool errors out when adding new trade skills so having to hand write them(is there a way to update db with game running?)