[DiscordArchive] Different session names?
[DiscordArchive] Different session names?
Archived author: Yuki ユキ • Posted: 2023-11-15T08:15:24.311000+00:00
Original source
They're leftover tables from a module I installed and then removed, so technically speaking I created them myself (I think)
Archived author: Yuki ユキ • Posted: 2023-11-15T08:16:06.589000+00:00
Original source
The simplicity of that solution completely evaded me, you may be a genius...
Archived author: Dedmen (∩`-´)⊃━☆゚.*・。゚ /\(O_O)/\ • Posted: 2023-11-15T08:21:07.605000+00:00
Original source
I did a full SQL dump and reapplied it.
It would be a lot faster to do it directly on the server, there are some guides online but by the time I read about the faster way I already had the slow one running
Archived author: Yuki ユキ • Posted: 2023-11-15T08:27:38.603000+00:00
Original source
That's what I'm fumbling through right now. I've creating 3 new databases and now I'm attempting to import the data from the acore databases by exporting them to SQL scripts, then importing them back in.
Archived author: Roboto • Posted: 2023-11-15T08:46:02.538000+00:00
Original source
Most SQL tools allow you to duplicate databases
Archived author: Yuki ユキ • Posted: 2023-11-15T08:47:06.409000+00:00
Original source
Apparently Heidi is different, no duplication options but you can work around it by exporting SQL scripts that recreate the exact structure and data from an existing database. Then you run the script and it imports it back in. Really inefficient, but it works.
Archived author: Roboto • Posted: 2023-11-15T08:47:29.819000+00:00
Original source
In Heidi, right-click a database > Export > choose "Database" in the Output dropdown
Archived author: Roboto • Posted: 2023-11-15T08:48:05.469000+00:00
Original source
It's hidden I'll give you that
Archived author: Yuki ユキ • Posted: 2023-11-15T08:48:43.483000+00:00
Original source
Strange, I get a slightly different set of options?
![[Image: image.png?ex=690c60ef&is=690b0f6f&hm=905...ebd428fb9&]](https://cdn.discordapp.com/attachments/369084351129845760/1174269760670806097/image.png?ex=690c60ef&is=690b0f6f&hm=905427109049c8366a576407c1bcb5b44aa6977a256f2282b95b22debd428fb9&)
Archived author: Yuki ユキ • Posted: 2023-11-15T08:48:47.873000+00:00
Original source
![[Image: image.png?ex=690c60ef&is=690b0f6f&hm=905...ebd428fb9&]](https://cdn.discordapp.com/attachments/369084351129845760/1174269760670806097/image.png?ex=690c60ef&is=690b0f6f&hm=905427109049c8366a576407c1bcb5b44aa6977a256f2282b95b22debd428fb9&)