Pulling latest peq data to your server

Pulling latest peq data to your server

There are two ways you can take advantage of the latest peq-expansions efforts on your private server.

1. (Use the CDN content db system to pull data directly from peq)[https://docs.eqemu.io/server/database/multi-tenancy/?h=cdn#how-is-multi-tenancy-used-in-the-server]
2. Use a script to pull down selective content_db tables to your local database

1 is the easiest, 2 is the most flexible

Akka's short writing on this is:

Example ./bin/world database:schema | grep -v "aa_" | jq '.content_tables | join(" ")' --raw-output

Gives adventure_template adventure_template_entry adventure_template_entry_flavor alternate_currency auras base_data blocked_spells books char_create_combinations char_create_point_allocations damageshieldtypes doors faction_base_data faction_list faction_list_mod fishing forage global_loot goallists graveyard grid grid_entries ground_spawns horses items ldon_trap_entries ldon_trap_templates lootdrop lootdrop_entries loottable loottable_entries merchantlist npc_emotes npc_faction npc_faction_entries npc_scale_global_base npc_spells npc_spells_effects npc_spells_effects_entries npc_spells_entries npc_types npc_types_tint object pets pets_beastlord_data pets_equipmentset pets_equipmentset_entries proximities skill_caps spawn2 spawn_conditions spawnentry spawngroup spells_new start_zones starting_items task_activities tasks tasksets tradeskill_recipe tradeskill_recipe_entries traps tribute_levels tributes veteran_reward_templates zone zone_points

You can pipe that to mysql dump mysqldump --lock-tables=false -h content-cdn.projecteq.net -P 16033 -uro -pro peq_content $(./bin/world database:schema | grep -v "aa_" | jq '.content_tables | join(" ")' --raw-output)

Then pipe it directly into your database mysqldump --lock-tables=false -h content-cdn.projecteq.net -P 16033 -uro -pro peq_content $(./bin/world database:schema | grep -v "aa_" | jq '.content_tables | join(" ")' --raw-output) | mysql -umydatabase -pmydatabasepass database_name

So you still use your own database, just pull from CDN as needed