[DiscordArchive] how were you editing your database?
[DiscordArchive] how were you editing your database?
Archived author: Nyeriah • Posted: 2024-08-10T18:37:33.129000+00:00
Original source
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
Archived author: Nyeriah • Posted: 2024-08-10T18:38:02.124000+00:00
Original source
Refer to the specific module page for more information on how to install them. Some require applying SQL files manually.
Archived author: OG Oran • Posted: 2024-08-10T18:38:54.721000+00:00
Original source
this is all pretty japanese to me so far, im learning linux and how this all works as I go. Ill go check out the page for teh module. Thanks
Archived author: Nelnamara • Posted: 2024-08-10T19:03:48.485000+00:00
Original source
You need to run the sql queries in the data folder of the module.
This will create the tables needed for the module to run. This is something you'll want to check with any module you use.
Archived author: OG Oran • Posted: 2024-08-10T19:07:23.474000+00:00
Original source
so I know how to navigate to the directory for them but once there ie root/stuff/data/xxx how to I run the sql queries? what is the command. I am just using ls to see what is in each container before figuring out what to do next.
Archived author: OG Oran • Posted: 2024-08-10T19:07:25.207000+00:00
Original source
root@Azeroth:~/azerothcore-wotlk/modules/mod-individual-xp/data/sql# ls
db-auth db-characters db-world
root@Azeroth:~/azerothcore-wotlk/modules/mod-individual-xp/data/sql# cd ~/azerothcore-wotlk/modules/mod-individual-xp/data/sql/db-characters
root@Azeroth:~/azerothcore-wotlk/modules/mod-individual-xp/data/sql/db-characters# ls
base updates
root@Azeroth:~/azerothcore-wotlk/modules/mod-individual-xp/data/sql/db-characters# cd ~/azerothcore-wotlk/modules/mod-individual-xp/data/sql/db-characters/base
root@Azeroth:~/azerothcore-wotlk/modules/mod-individual-xp/data/sql/db-characters/base# ls
mod_individual_xp_IndividualXP.sql
root@Azeroth:~/azerothcore-wotlk/modules/mod-individual-xp/data/sql/db-characters/base#
Archived author: OG Oran • Posted: 2024-08-10T19:07:41.529000+00:00
Original source
this is an example of what I am seeing, how do I use the .sql above