[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
Quote:GitHub - AldebaraanMKII/WoW-character-and-guild-export-import-scripts: Powershell scripts to export/import world of warcraft characters and guilds
This currently only works on AzerothCore.
You may ask yourself: Why not just use the .pdump command?
The .pdump command works most of the time. But it has several disavantages:
1. You need to know the name of all the characters you want to transfer. With the script you only need to know the account name.
2. No info is displayed for these characters. If you want to know more details about them, you need to log in into the account to see them for yourself.
3. You need to run the account/world server. With this, you only need to run the database.
4. The .pdump command doesn`t transfer guilds (let alone any items in its bank).
5. The .pdump command doesn`t transfer transmog and reagent bank module data.
Instructions
1. Install Powershell 7
2. Install SimplySQL and PSSQLite modules:
Code:
Install-Module -Name SimplySql, PSSQLite -Force
3. Extract the scripts folder somewhere
4. Open "(Config) Backup scripts" with notepad++ or another text editor and check/update the following:
Code:
# Define source connection details
# source = database from which you will backup the characters/guilds from
$SourceServerName = "127.0.0.1"
$SourcePort = 3306
$SourceUsername = "root"
$SourcePassword = "test"
$SourceDatabaseAuth = "acore_auth"
$SourceDatabaseCharacters = "acore_characters"
$SourceDatabaseWorld = "acore_world"
# Define target connection details
# target = database from which you will restore the characters/guilds to
$TargetServerName = "127.0.0.1"
$TargetPort = 3306
$TargetUsername = "root"
$TargetPassword = "test"
$TargetDatabaseAuth = "acore_auth"
$TargetDatabaseCharacters = "acore_characters"
$TargetDatabaseWorld = "acore_world"
# Paths to executables
$mysqldumpPath = "E:\Games\WoW Server Files\My Repack\mysql\bin\mysqldump.exe"
$mysqlPath = "E:\Games\WoW Server Files\My Repack\mysql\bin\mysql.exe"
Source is the database you're exporting the data from.
Target is the database you're importing the data to.
Paths to executables is the path to the mysql executables, which are required to export the .sql files used by the scripts. Those executables are typically included in a repack`s mysql/bin folder. If you don`t have them, install MySQL server 8.4.
5. If you`re exporting characters/guilds, open the MySQL database that contain those characters/guilds.
6. If you`re importing characters/guilds, open the MySQL database that you want to transfer them to.
7. Go into the folder you extracted the scripts to, right click > PowerShell 7 > Open Here
8. type the name of the script like this: ./"Backup scripts.ps1"
9. Follow the instructions in the console.
IMPORTANT: Make sure only the mysql database is open when you export/import your characters or guild! Trying to export/import while the auth/world server is running can lead to issues, like several items missing from the character inventory or duplicate entries in the database!
rektbyfaith
11-04-2025, 12:44 PM #1Archived author: Aldebaraan • Posted: 2025-11-04T13:44:41.725070
Original source
Quote:GitHub - AldebaraanMKII/WoW-character-and-guild-export-import-scripts: Powershell scripts to export/import world of warcraft characters and guilds
This currently only works on AzerothCore.
You may ask yourself: Why not just use the .pdump command?
The .pdump command works most of the time. But it has several disavantages:
1. You need to know the name of all the characters you want to transfer. With the script you only need to know the account name.
2. No info is displayed for these characters. If you want to know more details about them, you need to log in into the account to see them for yourself.
3. You need to run the account/world server. With this, you only need to run the database.
4. The .pdump command doesn`t transfer guilds (let alone any items in its bank).
5. The .pdump command doesn`t transfer transmog and reagent bank module data.
Instructions
1. Install Powershell 7
2. Install SimplySQL and PSSQLite modules:
Code:
Install-Module -Name SimplySql, PSSQLite -Force
3. Extract the scripts folder somewhere
4. Open "(Config) Backup scripts" with notepad++ or another text editor and check/update the following:
Code:
# Define source connection details
# source = database from which you will backup the characters/guilds from
$SourceServerName = "127.0.0.1"
$SourcePort = 3306
$SourceUsername = "root"
$SourcePassword = "test"
$SourceDatabaseAuth = "acore_auth"
$SourceDatabaseCharacters = "acore_characters"
$SourceDatabaseWorld = "acore_world"
# Define target connection details
# target = database from which you will restore the characters/guilds to
$TargetServerName = "127.0.0.1"
$TargetPort = 3306
$TargetUsername = "root"
$TargetPassword = "test"
$TargetDatabaseAuth = "acore_auth"
$TargetDatabaseCharacters = "acore_characters"
$TargetDatabaseWorld = "acore_world"
# Paths to executables
$mysqldumpPath = "E:\Games\WoW Server Files\My Repack\mysql\bin\mysqldump.exe"
$mysqlPath = "E:\Games\WoW Server Files\My Repack\mysql\bin\mysql.exe"
Source is the database you're exporting the data from.
Target is the database you're importing the data to.
Paths to executables is the path to the mysql executables, which are required to export the .sql files used by the scripts. Those executables are typically included in a repack`s mysql/bin folder. If you don`t have them, install MySQL server 8.4.
5. If you`re exporting characters/guilds, open the MySQL database that contain those characters/guilds.
6. If you`re importing characters/guilds, open the MySQL database that you want to transfer them to.
7. Go into the folder you extracted the scripts to, right click > PowerShell 7 > Open Here
8. type the name of the script like this: ./"Backup scripts.ps1"
9. Follow the instructions in the console.
IMPORTANT: Make sure only the mysql database is open when you export/import your characters or guild! Trying to export/import while the auth/world server is running can lead to issues, like several items missing from the character inventory or duplicate entries in the database!
11-04-2025, 12:44 PM
Original source
rektbyfaith
11-04-2025, 12:44 PM #2Archived author: Aldebaraan • Posted: 2025-11-04T13:44:41.725070
Original source
11-04-2025, 12:44 PM
Original source
Quote: What am I doing wrong? This is my old repack (Zaicopx)
Backup character data.ps1:
# Paths to executables
$mysqldumpPath = "D:\Games\AzerothCore Single Player Repack\mysql\bin\mysqldump.exe" # path to mysqldump executable
$mysqlPath = "D:\Games\AzerothCore Single Player Repack\mysql\bin\mysql.exe" # path to mysql executable
MySQL Server is running, login and pass is correct (unchanged)
$serverName = "127.0.0.1"
$port = 3306
$username = "root"
$password = "ascent"
script.png
rektbyfaith
11-04-2025, 12:44 PM #3Archived author: uber-cheater3000 • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: What am I doing wrong? This is my old repack (Zaicopx)
Backup character data.ps1:
# Paths to executables
$mysqldumpPath = "D:\Games\AzerothCore Single Player Repack\mysql\bin\mysqldump.exe" # path to mysqldump executable
$mysqlPath = "D:\Games\AzerothCore Single Player Repack\mysql\bin\mysql.exe" # path to mysql executable
MySQL Server is running, login and pass is correct (unchanged)
$serverName = "127.0.0.1"
$port = 3306
$username = "root"
$password = "ascent"
script.png
11-04-2025, 12:44 PM
Original source
Quote: Originally Posted by uber-cheater3000
What am I doing wrong? This is my old repack (Zaicopx)
Backup character data.ps1:
# Paths to executables
$mysqldumpPath = "D:\Games\AzerothCore Single Player Repack\mysql\bin\mysqldump.exe" # path to mysqldump executable
$mysqlPath = "D:\Games\AzerothCore Single Player Repack\mysql\bin\mysql.exe" # path to mysql executable
MySQL Server is running, login and pass is correct (unchanged)
$serverName = "127.0.0.1"
$port = 3306
$username = "root"
$password = "ascent"
script.png
It's a issue with mysql.data. Follow the instructions in the opening post regarding issues (comment out the lines mentioned) and try running the script again without closing the console.
![[Image: lastpost-right.svg]](https://www.ownedcore.com/forums/images/styles/OwnedCoreFX/buttons/lastpost-right.svg)
rektbyfaith
11-04-2025, 12:44 PM #4Archived author: Aldebaraan • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: Originally Posted by uber-cheater3000
What am I doing wrong? This is my old repack (Zaicopx)
Backup character data.ps1:
# Paths to executables
$mysqldumpPath = "D:\Games\AzerothCore Single Player Repack\mysql\bin\mysqldump.exe" # path to mysqldump executable
$mysqlPath = "D:\Games\AzerothCore Single Player Repack\mysql\bin\mysql.exe" # path to mysql executable
MySQL Server is running, login and pass is correct (unchanged)
$serverName = "127.0.0.1"
$port = 3306
$username = "root"
$password = "ascent"
script.png
It's a issue with mysql.data. Follow the instructions in the opening post regarding issues (comment out the lines mentioned) and try running the script again without closing the console.
11-04-2025, 12:44 PM
Original source
Quote: The script from your archive (Backup character data.ps1) already has commented lines. This error was exactly with these parameters
Code:
#try {
# Add-Type -Path "./MySql.Data.dll" 2>$null
#} catch {
#
#}
Now I uncommented these lines and tried to run the script. It seems to work. But now I encountered another error:
anotherone.png
But I managed to export my guild using another script (Backup guild data.ps1).
rektbyfaith
11-04-2025, 12:44 PM #5Archived author: uber-cheater3000 • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: The script from your archive (Backup character data.ps1) already has commented lines. This error was exactly with these parameters
Code:
#try {
# Add-Type -Path "./MySql.Data.dll" 2>$null
#} catch {
#
#}
Now I uncommented these lines and tried to run the script. It seems to work. But now I encountered another error:
anotherone.png
But I managed to export my guild using another script (Backup guild data.ps1).
11-04-2025, 12:44 PM
Original source
Quote: Originally Posted by uber-cheater3000
The script from your archive (Backup character data.ps1) already has commented lines. This error was exactly with these parameters
Code:
#try {
# Add-Type -Path "./MySql.Data.dll" 2>$null
#} catch {
#
#}
Now I uncommented these lines and tried to run the script. It seems to work. But now I encountered another error:
anotherone.png
But I managed to export my guild using another script (Backup guild data.ps1).
With the console open comment the lines again, save the script, and try to run it again. If that doesn't work update your net framework.
rektbyfaith
11-04-2025, 12:44 PM #6Archived author: Aldebaraan • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: Originally Posted by uber-cheater3000
The script from your archive (Backup character data.ps1) already has commented lines. This error was exactly with these parameters
Code:
#try {
# Add-Type -Path "./MySql.Data.dll" 2>$null
#} catch {
#
#}
Now I uncommented these lines and tried to run the script. It seems to work. But now I encountered another error:
anotherone.png
But I managed to export my guild using another script (Backup guild data.ps1).
With the console open comment the lines again, save the script, and try to run it again. If that doesn't work update your net framework.
11-04-2025, 12:44 PM
Original source
Quote: Well, this was tricky but it works. Now the last step left...
I get an error when importing a character into your repack (I didn't forget about the commented lines and #Paths to executables)
Code:
PS D:\Games\Azerothcore WoTLK Repack (Playerbots)\WoW-character-and-guild-export-import-scripts-main> ./"Restore character data.ps1"
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4): 2
You selected: (gamer) Vredina - Orc Warlock Female LV60
Enter account name to transfer the character(s).: horell
Error: The field or property: "Datetime" for type: "MySql.Data.MySqlClient.MySqlDbType" differs only in letter casing from the field or property: "DateTime". The type must be Common Language Specification (CLS) compliant.
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4):
PS D:\Games\Azerothcore WoTLK Repack (Playerbots)\WoW-character-and-guild-export-import-scripts-main> ./"Restore character data.ps1"
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4): 2
You selected: (gamer) Vredina - Orc Warlock Female LV60
Enter account name to transfer the character(s).: horell
ID for username 'horell': 203
Restoring character 'Vredina'
(characters) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Column count doesn't match value count at row 1"
Importing character data...
(character_account_data) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VERSION 5\n\nADDEDVERSION 13\n\nOPTION_GUILD_RECRUITMENT_CHANNEL AUTO\n\nCHANNEL' at line 1"
(character_achievement_progress) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-40' for key 'character_achievement_progress.PRIMARY'"
(character_action) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-0-0' for key 'character_action.PRIMARY'"
(character_aura) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-5-0-11735-3' for key 'character_aura.PRIMARY'"
(character_glyphs) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-0' for key 'character_glyphs.PRIMARY'"
(character_queststatus) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-4003' for key 'character_queststatus.PRIMARY'"
(character_queststatus_rewarded) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-25' for key 'character_queststatus_rewarded.PRIMARY'"
(character_reputation) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-21' for key 'character_reputation.PRIMARY'"
(character_skills) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-43' for key 'character_skills.PRIMARY'"
(character_spell) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-126' for key 'character_spell.PRIMARY'"
(character_talent) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-17785' for key 'character_talent.PRIMARY'"
(character_homebind) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005' for key 'character_homebind.PRIMARY'"
Importing pet data...
Importing character items...
(character_inventory) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-0-0' for key 'character_inventory.guid'"
Import done in 1.4537746 seconds. Returning to menu...
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4):
rektbyfaith
11-04-2025, 12:44 PM #7Archived author: uber-cheater3000 • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: Well, this was tricky but it works. Now the last step left...
I get an error when importing a character into your repack (I didn't forget about the commented lines and #Paths to executables)
Code:
PS D:\Games\Azerothcore WoTLK Repack (Playerbots)\WoW-character-and-guild-export-import-scripts-main> ./"Restore character data.ps1"
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4): 2
You selected: (gamer) Vredina - Orc Warlock Female LV60
Enter account name to transfer the character(s).: horell
Error: The field or property: "Datetime" for type: "MySql.Data.MySqlClient.MySqlDbType" differs only in letter casing from the field or property: "DateTime". The type must be Common Language Specification (CLS) compliant.
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4):
PS D:\Games\Azerothcore WoTLK Repack (Playerbots)\WoW-character-and-guild-export-import-scripts-main> ./"Restore character data.ps1"
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4): 2
You selected: (gamer) Vredina - Orc Warlock Female LV60
Enter account name to transfer the character(s).: horell
ID for username 'horell': 203
Restoring character 'Vredina'
(characters) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Column count doesn't match value count at row 1"
Importing character data...
(character_account_data) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VERSION 5\n\nADDEDVERSION 13\n\nOPTION_GUILD_RECRUITMENT_CHANNEL AUTO\n\nCHANNEL' at line 1"
(character_achievement_progress) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-40' for key 'character_achievement_progress.PRIMARY'"
(character_action) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-0-0' for key 'character_action.PRIMARY'"
(character_aura) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-5-0-11735-3' for key 'character_aura.PRIMARY'"
(character_glyphs) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-0' for key 'character_glyphs.PRIMARY'"
(character_queststatus) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-4003' for key 'character_queststatus.PRIMARY'"
(character_queststatus_rewarded) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-25' for key 'character_queststatus_rewarded.PRIMARY'"
(character_reputation) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-21' for key 'character_reputation.PRIMARY'"
(character_skills) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-43' for key 'character_skills.PRIMARY'"
(character_spell) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-126' for key 'character_spell.PRIMARY'"
(character_talent) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-17785' for key 'character_talent.PRIMARY'"
(character_homebind) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005' for key 'character_homebind.PRIMARY'"
Importing pet data...
Importing character items...
(character_inventory) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-0-0' for key 'character_inventory.guid'"
Import done in 1.4537746 seconds. Returning to menu...
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4):
11-04-2025, 12:44 PM
Original source
Quote: Originally Posted by uber-cheater3000
Well, this was tricky but it works. Now the last step left...
I get an error when importing a character into your repack (I didn't forget about the commented lines and #Paths to executables)
Code:
PS D:\Games\Azerothcore WoTLK Repack (Playerbots)\WoW-character-and-guild-export-import-scripts-main> ./"Restore character data.ps1"
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4): 2
You selected: (gamer) Vredina - Orc Warlock Female LV60
Enter account name to transfer the character(s).: horell
Error: The field or property: "Datetime" for type: "MySql.Data.MySqlClient.MySqlDbType" differs only in letter casing from the field or property: "DateTime". The type must be Common Language Specification (CLS) compliant.
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4):
PS D:\Games\Azerothcore WoTLK Repack (Playerbots)\WoW-character-and-guild-export-import-scripts-main> ./"Restore character data.ps1"
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4): 2
You selected: (gamer) Vredina - Orc Warlock Female LV60
Enter account name to transfer the character(s).: horell
ID for username 'horell': 203
Restoring character 'Vredina'
(characters) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Column count doesn't match value count at row 1"
Importing character data...
(character_account_data) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VERSION 5\n\nADDEDVERSION 13\n\nOPTION_GUILD_RECRUITMENT_CHANNEL AUTO\n\nCHANNEL' at line 1"
(character_achievement_progress) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-40' for key 'character_achievement_progress.PRIMARY'"
(character_action) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-0-0' for key 'character_action.PRIMARY'"
(character_aura) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-5-0-11735-3' for key 'character_aura.PRIMARY'"
(character_glyphs) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-0' for key 'character_glyphs.PRIMARY'"
(character_queststatus) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-4003' for key 'character_queststatus.PRIMARY'"
(character_queststatus_rewarded) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-25' for key 'character_queststatus_rewarded.PRIMARY'"
(character_reputation) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-21' for key 'character_reputation.PRIMARY'"
(character_skills) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-43' for key 'character_skills.PRIMARY'"
(character_spell) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-126' for key 'character_spell.PRIMARY'"
(character_talent) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-17785' for key 'character_talent.PRIMARY'"
(character_homebind) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005' for key 'character_homebind.PRIMARY'"
Importing pet data...
Importing character items...
(character_inventory) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-0-0' for key 'character_inventory.guid'"
Import done in 1.4537746 seconds. Returning to menu...
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4):
Can you please send me the character sql files zipped?
rektbyfaith
11-04-2025, 12:44 PM #8Archived author: Aldebaraan • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: Originally Posted by uber-cheater3000
Well, this was tricky but it works. Now the last step left...
I get an error when importing a character into your repack (I didn't forget about the commented lines and #Paths to executables)
Code:
PS D:\Games\Azerothcore WoTLK Repack (Playerbots)\WoW-character-and-guild-export-import-scripts-main> ./"Restore character data.ps1"
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4): 2
You selected: (gamer) Vredina - Orc Warlock Female LV60
Enter account name to transfer the character(s).: horell
Error: The field or property: "Datetime" for type: "MySql.Data.MySqlClient.MySqlDbType" differs only in letter casing from the field or property: "DateTime". The type must be Common Language Specification (CLS) compliant.
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4):
PS D:\Games\Azerothcore WoTLK Repack (Playerbots)\WoW-character-and-guild-export-import-scripts-main> ./"Restore character data.ps1"
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4): 2
You selected: (gamer) Vredina - Orc Warlock Female LV60
Enter account name to transfer the character(s).: horell
ID for username 'horell': 203
Restoring character 'Vredina'
(characters) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Column count doesn't match value count at row 1"
Importing character data...
(character_account_data) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VERSION 5\n\nADDEDVERSION 13\n\nOPTION_GUILD_RECRUITMENT_CHANNEL AUTO\n\nCHANNEL' at line 1"
(character_achievement_progress) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-40' for key 'character_achievement_progress.PRIMARY'"
(character_action) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-0-0' for key 'character_action.PRIMARY'"
(character_aura) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-5-0-11735-3' for key 'character_aura.PRIMARY'"
(character_glyphs) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-0' for key 'character_glyphs.PRIMARY'"
(character_queststatus) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-4003' for key 'character_queststatus.PRIMARY'"
(character_queststatus_rewarded) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-25' for key 'character_queststatus_rewarded.PRIMARY'"
(character_reputation) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-21' for key 'character_reputation.PRIMARY'"
(character_skills) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-43' for key 'character_skills.PRIMARY'"
(character_spell) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-126' for key 'character_spell.PRIMARY'"
(character_talent) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-17785' for key 'character_talent.PRIMARY'"
(character_homebind) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005' for key 'character_homebind.PRIMARY'"
Importing pet data...
Importing character items...
(character_inventory) An error occurred: Exception calling "ExecuteNonQuery" with "0" argument(s): "Duplicate entry '2005-0-0' for key 'character_inventory.guid'"
Import done in 1.4537746 seconds. Returning to menu...
Please select a character by typing the corresponding number:
1. (gamer) Shooterguy - Troll Hunter Male LV2
2. (gamer) Vredina - Orc Warlock Female LV60
3. All characters in list
4. Exit
Enter your choice (1-4):
Can you please send me the character sql files zipped?
11-04-2025, 12:44 PM
Original source
Quote: Sure
Vredina - Orc Warlock Female LV60.zip
Maybe it's because that repack was really old? I played it in like ‘22 or so
rektbyfaith
11-04-2025, 12:44 PM #9Archived author: uber-cheater3000 • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: Sure
Vredina - Orc Warlock Female LV60.zip
Maybe it's because that repack was really old? I played it in like ‘22 or so
11-04-2025, 12:44 PM
Original source
Quote: Originally Posted by uber-cheater3000
Sure
Vredina - Orc Warlock Female LV60.zip
Maybe it's because that repack was really old? I played it in like ‘22 or so
It seems to be so. I encountered a similar issue related to hearthstone data when using zaicopx repack with the latest patch from 2023. But this has issues with other stuff. I will download the old repack from 2022 to test. In the meantime you can use the .pdump command to transfer your character.
rektbyfaith
11-04-2025, 12:44 PM #10Archived author: Aldebaraan • Posted: 2025-11-04T13:44:41.725070
Original source
Quote: Originally Posted by uber-cheater3000
Sure
Vredina - Orc Warlock Female LV60.zip
Maybe it's because that repack was really old? I played it in like ‘22 or so
It seems to be so. I encountered a similar issue related to hearthstone data when using zaicopx repack with the latest patch from 2023. But this has issues with other stuff. I will download the old repack from 2022 to test. In the meantime you can use the .pdump command to transfer your character.
Recently Browsing
1 Guest(s)
1 Guest(s)
Recently Browsing
1 Guest(s)
1 Guest(s)