[DiscordArchive] Is there a function in heidiSQL or is it a file browser thing?
[DiscordArchive] Is there a function in heidiSQL or is it a file browser thing?
Archived author: creasedEdge • Posted: 2025-04-18T05:16:07.666000+00:00
Original source
Is there a function in heidiSQL or is it a file browser thing?
Archived author: Illu • Posted: 2025-04-18T05:19:18.014000+00:00
Original source
I also want the zones and quests not just the races, also the new dungeons and raids from kalimdor and azeroth (Time, Karazhan, Kael'Danas, and that 2nd hand troll raid I've never done) and since with azerothcore I've got the DeathKnight zone, why not add that too
Archived author: WizzFizz • Posted: 2025-04-18T05:26:11.836000+00:00
Original source
In Heidi you can right-click a table & export.
You can select the entire DB or just specific tables.
I recommend tables for small scale changes to save time and space.
Of the options, choose drop & insert.
This will remove the modified table & replace it with the backup if you need to do a restore
![[Image: image.png?ex=690c31cc&is=690ae04c&hm=531...0c97f2772&]](https://cdn.discordapp.com/attachments/1255602330431127753/1362660837503799346/image.png?ex=690c31cc&is=690ae04c&hm=5317fcf4ee9ff54f7c864dce27cb5ff2d3f26b71a35a09b71506ce80c97f2772&)
![[Image: image.png?ex=690c31cc&is=690ae04c&hm=f5e...a64d59a04&]](https://cdn.discordapp.com/attachments/1255602330431127753/1362660837743001601/image.png?ex=690c31cc&is=690ae04c&hm=f5ee1d8aebf0c8f608a6e47b58976c45b1c4a4d0aad77e199643619a64d59a04&)
Archived author: creasedEdge • Posted: 2025-04-18T05:27:40.776000+00:00
Original source
This option? Export to SQL? And then to import "file - Run SQL"?
![[Image: image.png?ex=690c31cc&is=690ae04c&hm=531...0c97f2772&]](https://cdn.discordapp.com/attachments/1255602330431127753/1362660837503799346/image.png?ex=690c31cc&is=690ae04c&hm=5317fcf4ee9ff54f7c864dce27cb5ff2d3f26b71a35a09b71506ce80c97f2772&)
![[Image: image.png?ex=690c31cc&is=690ae04c&hm=f5e...a64d59a04&]](https://cdn.discordapp.com/attachments/1255602330431127753/1362660837743001601/image.png?ex=690c31cc&is=690ae04c&hm=f5ee1d8aebf0c8f608a6e47b58976c45b1c4a4d0aad77e199643619a64d59a04&)
Archived author: WizzFizz • Posted: 2025-04-18T05:35:16.191000+00:00
Original source
That’s it
Archived author: WizzFizz • Posted: 2025-04-18T05:36:07.093000+00:00
Original source
You can also drag the SQL file into the query window to run it
Archived author: creasedEdge • Posted: 2025-04-18T05:39:20.207000+00:00
Original source
Thank you!