[Archive] (AzerothCore) Powershell scripts for character and guild export/import
[Archive] (AzerothCore) Powershell scripts for character and guild export/import
11-04-2025, 12:44 PM
Original source
rektbyfaith
11-04-2025, 12:44 PM #11Archived author: Aldebaraan • Posted: 2025-11-04T13:44:41.725070
Original source
11-04-2025, 12:44 PM
Original source
Quote: Unfortunately the .pdump command doesn't work either. The character cannot be imported into the new server
Code:
.pdump load MyProgress horell Vredina
LoadPlayerDump: (line 819) unknown column name `posO` for table `character_homebind`, aborting due to incompatible DB structure.
Dump file have broken data!
Anyway, thanks for trying to help
![[Image: have%20a%20nice%20day.png]](https://www.ownedcore.com/forums/images/smilies/have%20a%20nice%20day.png)
rektbyfaith
11-04-2025, 12:44 PM #12Archived author: uber-cheater3000 • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: Unfortunately the .pdump command doesn't work either. The character cannot be imported into the new server
Code:
.pdump load MyProgress horell Vredina
LoadPlayerDump: (line 819) unknown column name `posO` for table `character_homebind`, aborting due to incompatible DB structure.
Dump file have broken data!
Anyway, thanks for trying to help
11-04-2025, 12:44 PM
Original source
Quote: I think I've done it. I created a new character, exported it. Then copied his coordinates from:
Code:
INSERT INTO `character_homebind` (`guid`, `mapId`, `zoneId`, `posX`, `posY`, `posZ`) VALUES
and overwrites it to my character.
But that's not all. Then I got the error ‘duplicate `character_pet`’
Apparently, this is because of the BeastMaster NPC module.
Then I deleted the line (since I was hiring a hunter's pet)
Code:
INSERT INTO `character_pet` .........
This worked, the character was able to be imported, but my Felhunter still has some abilities from the Hunter pet. I have to delete them somehow now.
Other than that, everything seems to be fine.
![[Image: redface.gif]](https://www.ownedcore.com/forums/images/smilies/redface.gif)
rektbyfaith
11-04-2025, 12:44 PM #13Archived author: uber-cheater3000 • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: I think I've done it. I created a new character, exported it. Then copied his coordinates from:
Code:
INSERT INTO `character_homebind` (`guid`, `mapId`, `zoneId`, `posX`, `posY`, `posZ`) VALUES
and overwrites it to my character.
But that's not all. Then I got the error ‘duplicate `character_pet`’
Apparently, this is because of the BeastMaster NPC module.
Then I deleted the line (since I was hiring a hunter's pet)
Code:
INSERT INTO `character_pet` .........
This worked, the character was able to be imported, but my Felhunter still has some abilities from the Hunter pet. I have to delete them somehow now.
Other than that, everything seems to be fine.
11-04-2025, 12:44 PM
Original source
Quote: Originally Posted by uber-cheater3000
Unfortunately the .pdump command doesn't work either. The character cannot be imported into the new server
Code:
.pdump load MyProgress horell Vredina
LoadPlayerDump: (line 819) unknown column name `posO` for table `character_homebind`, aborting due to incompatible DB structure.
Dump file have broken data!
Anyway, thanks for trying to help
Homebind from old zaicopx has a extra column that was removed in current azerothcore.
![[Image: lastpost-right.svg]](https://www.ownedcore.com/forums/images/styles/OwnedCoreFX/buttons/lastpost-right.svg)
rektbyfaith
11-04-2025, 12:44 PM #14Archived author: Aldebaraan • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: Originally Posted by uber-cheater3000
Unfortunately the .pdump command doesn't work either. The character cannot be imported into the new server
Code:
.pdump load MyProgress horell Vredina
LoadPlayerDump: (line 819) unknown column name `posO` for table `character_homebind`, aborting due to incompatible DB structure.
Dump file have broken data!
Anyway, thanks for trying to help
Homebind from old zaicopx has a extra column that was removed in current azerothcore.
11-04-2025, 12:44 PM
Original source
Quote: I updated the scripts to use the SimplySQL module, which eliminates the errors that mysql.data caused. I also refactored the code, so now you only need to run one script and edit one configuration file.
rektbyfaith
11-04-2025, 12:44 PM #15Archived author: Aldebaraan • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: I updated the scripts to use the SimplySQL module, which eliminates the errors that mysql.data caused. I also refactored the code, so now you only need to run one script and edit one configuration file.
11-04-2025, 12:44 PM
Original source
rektbyfaith
11-04-2025, 12:44 PM #16Archived author: Aldebaraan • Posted: 2025-11-04T13:44:41.725070
Original source
11-04-2025, 12:44 PM
Original source
Quote: Hello. thanks for the script .. but im having problem with backing up my character data from another server but the sama azerothcore based. It start successfully but, it gave me this warning line :
WARNING: Query returned no resultset. This occurs when the query has no select statement or invokes a stored procedure that does not return a resultset. Use 'Invoke-SqlUpdate' to avoid this warning.
and the result is when i check the character data folder to restoring my backing up data, the folder is still empty. Anyway to solve this ?
PS: The Backup guild data is excecute nicely
here is the log for character data backups :
**********************
PowerShell transcript start
Start time: 20250310085636
Username: DESKTOP-OKN77QL\ABUDZAR-PC
RunAs User: DESKTOP-OKN77QL\ABUDZAR-PC
Configuration Name:
Machine: DESKTOP-OKN77QL (Microsoft Windows NT 10.0.22631.0)
Host Application: C:\Program Files\WindowsApps\Microsoft.PowerShell_7.5.0.0_x64__8wekyb3d8bbwe\pwsh.dll
Process ID: 13300
PSVersion: 7.5.0
PSEdition: Core
GitCommitId: 7.5.0
OS: Microsoft Windows 10.0.22631
Platform: Win32NT
PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1, 6.0, 7.0
PSRemotingProtocolVersion: 2.3
SerializationVersion: 1.1.0.1
WSManStackVersion: 3.0
**********************
Transcript started, output file is ./logs/BackupScripts_20250310_085636.log
WoW Backup Scripts
Select a option:
1. Backup character(s).
2. Backup guild(s).
3. Restore character(s).
4. Restore guild(s).
5. Exit script
Type a number (1-5):
(Press CTRL + C to exit)
ID for username 'zuma': 3
Found 2 Characters.
Character List:
1. (GUID: 3) Punkhead - Race: Undead, Class: Rogue, Gender: Male, LV18, Honor: 0, Money: 884g, 65s and 95c, Creation date: 26/02/2025 18:43:33
2. (GUID: 5004) Glym - Race: Dwarf, Class: Hunter, Gender: Male, LV51, Honor: 53, Money: 1026g, 97s and 86c, Creation date: 01/03/2025 02:04:28
3. Back up all characters
4. Go back
5. Exit script
Backing up character Punkhead...
WARNING: Query returned no resultset. This occurs when the query has no select statement or invokes a stored procedure that does not return a resultset. Use 'Invoke-SqlUpdate' to avoid this warning.
Backing up character Glym...
Found pet: (ID: 1462), Lupo, Lupos, LV 41
Found pet: (ID: 1496), Lovely, Hayoc, LV 50
Found pet: (ID: 239, Akatsuki, Grunter, LV 50
Found pet: (ID: 2417), Rave, Ravage, LV 51
All characters backed up in 0.8120974 seconds. Returning to menu...
rektbyfaith
11-04-2025, 12:44 PM #17Archived author: zafiys • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: Hello. thanks for the script .. but im having problem with backing up my character data from another server but the sama azerothcore based. It start successfully but, it gave me this warning line :
WARNING: Query returned no resultset. This occurs when the query has no select statement or invokes a stored procedure that does not return a resultset. Use 'Invoke-SqlUpdate' to avoid this warning.
and the result is when i check the character data folder to restoring my backing up data, the folder is still empty. Anyway to solve this ?
PS: The Backup guild data is excecute nicely
here is the log for character data backups :
**********************
PowerShell transcript start
Start time: 20250310085636
Username: DESKTOP-OKN77QL\ABUDZAR-PC
RunAs User: DESKTOP-OKN77QL\ABUDZAR-PC
Configuration Name:
Machine: DESKTOP-OKN77QL (Microsoft Windows NT 10.0.22631.0)
Host Application: C:\Program Files\WindowsApps\Microsoft.PowerShell_7.5.0.0_x64__8wekyb3d8bbwe\pwsh.dll
Process ID: 13300
PSVersion: 7.5.0
PSEdition: Core
GitCommitId: 7.5.0
OS: Microsoft Windows 10.0.22631
Platform: Win32NT
PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1, 6.0, 7.0
PSRemotingProtocolVersion: 2.3
SerializationVersion: 1.1.0.1
WSManStackVersion: 3.0
**********************
Transcript started, output file is ./logs/BackupScripts_20250310_085636.log
WoW Backup Scripts
Select a option:
1. Backup character(s).
2. Backup guild(s).
3. Restore character(s).
4. Restore guild(s).
5. Exit script
Type a number (1-5):
(Press CTRL + C to exit)
ID for username 'zuma': 3
Found 2 Characters.
Character List:
1. (GUID: 3) Punkhead - Race: Undead, Class: Rogue, Gender: Male, LV18, Honor: 0, Money: 884g, 65s and 95c, Creation date: 26/02/2025 18:43:33
2. (GUID: 5004) Glym - Race: Dwarf, Class: Hunter, Gender: Male, LV51, Honor: 53, Money: 1026g, 97s and 86c, Creation date: 01/03/2025 02:04:28
3. Back up all characters
4. Go back
5. Exit script
Backing up character Punkhead...
WARNING: Query returned no resultset. This occurs when the query has no select statement or invokes a stored procedure that does not return a resultset. Use 'Invoke-SqlUpdate' to avoid this warning.
Backing up character Glym...
Found pet: (ID: 1462), Lupo, Lupos, LV 41
Found pet: (ID: 1496), Lovely, Hayoc, LV 50
Found pet: (ID: 239
Found pet: (ID: 2417), Rave, Ravage, LV 51
All characters backed up in 0.8120974 seconds. Returning to menu...
11-04-2025, 12:44 PM
Original source
Quote: Originally Posted by zafiys
Hello. thanks for the script .. but im having problem with backing up my character data from another server but the sama azerothcore based. It start successfully but, it gave me this warning line :
WARNING: Query returned no resultset. This occurs when the query has no select statement or invokes a stored procedure that does not return a resultset. Use 'Invoke-SqlUpdate' to avoid this warning.
and the result is when i check the character data folder to restoring my backing up data, the folder is still empty. Anyway to solve this ?
PS: The Backup guild data is excecute nicely
here is the log for character data backups :
**********************
PowerShell transcript start
Start time: 20250310085636
Username: DESKTOP-OKN77QL\ABUDZAR-PC
RunAs User: DESKTOP-OKN77QL\ABUDZAR-PC
Configuration Name:
Machine: DESKTOP-OKN77QL (Microsoft Windows NT 10.0.22631.0)
Host Application: C:\Program Files\WindowsApps\Microsoft.PowerShell_7.5.0.0_x64__8wekyb3d8bbwe\pwsh.dll
Process ID: 13300
PSVersion: 7.5.0
PSEdition: Core
GitCommitId: 7.5.0
OS: Microsoft Windows 10.0.22631
Platform: Win32NT
PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1, 6.0, 7.0
PSRemotingProtocolVersion: 2.3
SerializationVersion: 1.1.0.1
WSManStackVersion: 3.0
**********************
Transcript started, output file is ./logs/BackupScripts_20250310_085636.log
WoW Backup Scripts
Select a option:
1. Backup character(s).
2. Backup guild(s).
3. Restore character(s).
4. Restore guild(s).
5. Exit script
Type a number (1-5):
(Press CTRL + C to exit)
ID for username 'zuma': 3
Found 2 Characters.
Character List:
1. (GUID: 3) Punkhead - Race: Undead, Class: Rogue, Gender: Male, LV18, Honor: 0, Money: 884g, 65s and 95c, Creation date: 26/02/2025 18:43:33
2. (GUID: 5004) Glym - Race: Dwarf, Class: Hunter, Gender: Male, LV51, Honor: 53, Money: 1026g, 97s and 86c, Creation date: 01/03/2025 02:04:28
3. Back up all characters
4. Go back
5. Exit script
Backing up character Punkhead...
WARNING: Query returned no resultset. This occurs when the query has no select statement or invokes a stored procedure that does not return a resultset. Use 'Invoke-SqlUpdate' to avoid this warning.
Backing up character Glym...
Found pet: (ID: 1462), Lupo, Lupos, LV 41
Found pet: (ID: 1496), Lovely, Hayoc, LV 50
Found pet: (ID: 239
Found pet: (ID: 2417), Rave, Ravage, LV 51
All characters backed up in 0.8120974 seconds. Returning to menu...
I made a commit fixing the issue. So download it again from github.
rektbyfaith
11-04-2025, 12:44 PM #18Archived author: Aldebaraan • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: Originally Posted by zafiys
Hello. thanks for the script .. but im having problem with backing up my character data from another server but the sama azerothcore based. It start successfully but, it gave me this warning line :
WARNING: Query returned no resultset. This occurs when the query has no select statement or invokes a stored procedure that does not return a resultset. Use 'Invoke-SqlUpdate' to avoid this warning.
and the result is when i check the character data folder to restoring my backing up data, the folder is still empty. Anyway to solve this ?
PS: The Backup guild data is excecute nicely
here is the log for character data backups :
**********************
PowerShell transcript start
Start time: 20250310085636
Username: DESKTOP-OKN77QL\ABUDZAR-PC
RunAs User: DESKTOP-OKN77QL\ABUDZAR-PC
Configuration Name:
Machine: DESKTOP-OKN77QL (Microsoft Windows NT 10.0.22631.0)
Host Application: C:\Program Files\WindowsApps\Microsoft.PowerShell_7.5.0.0_x64__8wekyb3d8bbwe\pwsh.dll
Process ID: 13300
PSVersion: 7.5.0
PSEdition: Core
GitCommitId: 7.5.0
OS: Microsoft Windows 10.0.22631
Platform: Win32NT
PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1, 6.0, 7.0
PSRemotingProtocolVersion: 2.3
SerializationVersion: 1.1.0.1
WSManStackVersion: 3.0
**********************
Transcript started, output file is ./logs/BackupScripts_20250310_085636.log
WoW Backup Scripts
Select a option:
1. Backup character(s).
2. Backup guild(s).
3. Restore character(s).
4. Restore guild(s).
5. Exit script
Type a number (1-5):
(Press CTRL + C to exit)
ID for username 'zuma': 3
Found 2 Characters.
Character List:
1. (GUID: 3) Punkhead - Race: Undead, Class: Rogue, Gender: Male, LV18, Honor: 0, Money: 884g, 65s and 95c, Creation date: 26/02/2025 18:43:33
2. (GUID: 5004) Glym - Race: Dwarf, Class: Hunter, Gender: Male, LV51, Honor: 53, Money: 1026g, 97s and 86c, Creation date: 01/03/2025 02:04:28
3. Back up all characters
4. Go back
5. Exit script
Backing up character Punkhead...
WARNING: Query returned no resultset. This occurs when the query has no select statement or invokes a stored procedure that does not return a resultset. Use 'Invoke-SqlUpdate' to avoid this warning.
Backing up character Glym...
Found pet: (ID: 1462), Lupo, Lupos, LV 41
Found pet: (ID: 1496), Lovely, Hayoc, LV 50
Found pet: (ID: 239
Found pet: (ID: 2417), Rave, Ravage, LV 51
All characters backed up in 0.8120974 seconds. Returning to menu...
I made a commit fixing the issue. So download it again from github.
11-04-2025, 12:44 PM
Original source
rektbyfaith
11-04-2025, 12:44 PM #19Archived author: Aldebaraan • Posted: 2025-11-04T13:44:41.725070
Original source
Recently Browsing
1 Guest(s)
1 Guest(s)
Recently Browsing
1 Guest(s)
1 Guest(s)