[DiscordArchive] If I would like to switch from Linux to windows based install.
[DiscordArchive] If I would like to switch from Linux to windows based install.
Original source
If I would like to switch from Linux to windows based install.
And I want to keep my characters, and auth intact.
Can I use HeidiSQL to backup the database to the new windows machine, or do I have to extract it from my Linux VM first?
rektbyfaith
03-24-2025, 11:05 AM #1Archived author: AndersD • Posted: 2025-03-24T11:05:23.990000+00:00
Original source
If I would like to switch from Linux to windows based install.
And I want to keep my characters, and auth intact.
Can I use HeidiSQL to backup the database to the new windows machine, or do I have to extract it from my Linux VM first?
Original source
if you have access to your DB (on linuxVM) from your windows-VM, it shouldnt pose a problem. I also do backups / exports from my macbook while being connected to the Database which runs in a windows-VM.
just make sure the worldserver is not running so you are sure that no data is being written in the meantime
rektbyfaith
03-24-2025, 11:07 AM #2Archived author: Tecc • Posted: 2025-03-24T11:07:18.067000+00:00
Original source
if you have access to your DB (on linuxVM) from your windows-VM, it shouldnt pose a problem. I also do backups / exports from my macbook while being connected to the Database which runs in a windows-VM.
just make sure the worldserver is not running so you are sure that no data is being written in the meantime
Original source
Ok, so basically I should be able to just pull out acore_auth and acore_characters
And then later paste that into my new server
rektbyfaith
03-24-2025, 11:10 AM #3Archived author: AndersD • Posted: 2025-03-24T11:10:20.183000+00:00
Original source
Ok, so basically I should be able to just pull out acore_auth and acore_characters
And then later paste that into my new server
Original source
basically yes, but also be sure to have both servers on the same commit/revision so you don't have any discrepancies between the database structures.
When moving data to a new install, I tend to only export/import the tables that I need, not the whole DB
rektbyfaith
03-24-2025, 11:14 AM #4Archived author: Tecc • Posted: 2025-03-24T11:14:27.312000+00:00
Original source
basically yes, but also be sure to have both servers on the same commit/revision so you don't have any discrepancies between the database structures.
When moving data to a new install, I tend to only export/import the tables that I need, not the whole DB
Original source
What tables would be needed from acore_auth and acore_characters to ensure no characters are lost in the process?
rektbyfaith
03-24-2025, 11:17 AM #5Archived author: AndersD • Posted: 2025-03-24T11:17:00.413000+00:00
Original source
What tables would be needed from acore_auth and acore_characters to ensure no characters are lost in the process?
Original source
Characters
rektbyfaith
03-24-2025, 11:20 AM #6Archived author: Barais • Posted: 2025-03-24T11:20:09.229000+00:00
Original source
Characters