[DiscordArchive] how introducing the sql to database with heidi ?
[DiscordArchive] how introducing the sql to database with heidi ?
Archived author: Skayz • Posted: 2024-05-20T23:13:57.599000+00:00
Original source
how introducing the sql to database with heidi ?
![[Image: image.png?ex=690bda5a&is=690a88da&hm=886...f4e257937&]](https://cdn.discordapp.com/attachments/284406375495368704/1242254172108230676/image.png?ex=690bda5a&is=690a88da&hm=88639c47dd509561d1f93731878eee06ec97c9fe835705591ff7ec3f4e257937&)
Archived author: Revision • Posted: 2024-05-20T23:14:34.643000+00:00
Original source
Click the database
![[Image: image.png?ex=690bda5a&is=690a88da&hm=886...f4e257937&]](https://cdn.discordapp.com/attachments/284406375495368704/1242254172108230676/image.png?ex=690bda5a&is=690a88da&hm=88639c47dd509561d1f93731878eee06ec97c9fe835705591ff7ec3f4e257937&)
Archived author: Skayz • Posted: 2024-05-20T23:14:39.775000+00:00
Original source
If it takes a long time it doesn't matter, sorry for bothering you and have a nice night and rest ^^
![[Image: image.png?ex=690bda61&is=690a88e1&hm=d74...26732fa37&]](https://cdn.discordapp.com/attachments/284406375495368704/1242254200050814986/image.png?ex=690bda61&is=690a88e1&hm=d745132c652d8808119c2ded562d0d3b8b027148f4d6f2f5223143626732fa37&)
Archived author: Revision • Posted: 2024-05-20T23:14:41.294000+00:00
Original source
Select Run SQL file
![[Image: image.png?ex=690bda61&is=690a88e1&hm=d74...26732fa37&]](https://cdn.discordapp.com/attachments/284406375495368704/1242254200050814986/image.png?ex=690bda61&is=690a88e1&hm=d745132c652d8808119c2ded562d0d3b8b027148f4d6f2f5223143626732fa37&)
Archived author: Revision • Posted: 2024-05-20T23:14:54.097000+00:00
Original source
and then browse to and select them. you can select multiple so no need to do 1 at a time
Archived author: Skayz • Posted: 2024-05-20T23:15:06.852000+00:00
Original source
ty !
Archived author: Skayz • Posted: 2024-05-20T23:18:22.523000+00:00
Original source
If I regret it in the future, is there any way to go back? Or should the world database be deleted so that it regenerates itself?
Archived author: Revision • Posted: 2024-05-20T23:19:19.749000+00:00
Original source
The easiest way is to reset the world database by dropping all the tables or deleting and recreating the database.
Archived author: Bench • Posted: 2024-05-20T23:19:29.325000+00:00
Original source
It can regenerate itself, I highly recommend holding onto every custom change you make in their own SQL query file so that such process will be a lot less painful
Archived author: Revision • Posted: 2024-05-20T23:19:49.366000+00:00
Original source
Just remember to save any custom changes you've made to it before. I don't want to be the recipient of another rage episode because someone didn't realize everything in the database gets deleted with it.