(AzerothCore) Powershell scripts for character and guild export/import

[Aldebaraan]

New update: added support for guild house module.

[prazravec]

in function Backup-Guild-Main is a bug

if ($guildData.Count -gt 0) {

it should be ->

if ($guildData.ItemArray.Length -gt 0) {

[renz153]

New update: added support for guild house module.

Restoring character 'Rowkan'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Column count doesn't match value count at row 1
Importing character data...
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-1' for key 'character_account_data.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-36' for key 'character_achievement_progress.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-0-24' for key 'character_action.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-1-0-2457-3' for key 'character_aura.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-377' for key 'character_queststatus.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-6' for key 'character_queststatus_rewarded.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-21' for key 'character_reputation.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-43' for key 'character_skills.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-71' for key 'character_spell.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-12163' for key 'character_talent.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '41' for key 'mail.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-723' for key 'custom_reagent_bank.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2' for key 'character_homebind.PRIMARY'
Importing character items...
203
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-0-3' for key 'character_inventory.guid'
what im doing wrong ?

[Aldebaraan]

Restoring character 'Rowkan'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Column count doesn't match value count at row 1
Importing character data...
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-1' for key 'character_account_data.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-36' for key 'character_achievement_progress.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-0-24' for key 'character_action.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-1-0-2457-3' for key 'character_aura.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-377' for key 'character_queststatus.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-6' for key 'character_queststatus_rewarded.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-21' for key 'character_reputation.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-43' for key 'character_skills.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-71' for key 'character_spell.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-12163' for key 'character_talent.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '41' for key 'mail.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-723' for key 'custom_reagent_bank.PRIMARY'
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2' for key 'character_homebind.PRIMARY'
Importing character items...
203
Invoke-SqlUpdate: D:\restore\descargas 2023\WoW-character-and-guild-export-import-scripts-main (3)\WoW-character-and-guild-export-import-scripts-main\Functions.ps1:153
Line |
153 | Invoke-SqlUpdate -ConnectionName $ConnectionName -Query $Quer …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Duplicate entry '2-0-3' for key 'character_inventory.guid'
what im doing wrong ?

I made a commit earlier today that is probably the cause of the bug. Can you clone the previous commit to see if it fixes it?

[Aldebaraan]

I made a commit earlier today that is probably the cause of the bug. Can you clone the previous commit to see if it fixes it?

If that doesn't work zip your mysql\data folder and send me a link. I will test it.

[prazravec]

is possible to make a backup for bots as well? is any guide how to do it? is even possible that update can reinit bots or replace their equip?

[Aldebaraan]

is possible to make a backup for bots as well? is any guide how to do it? is even possible that update can reinit bots or replace their equip?

The way the script works right now: not possible all at once. You need go through hundreds of bot accounts one at a time. You could use my autobackup script if you got every bot name, but you would still need to restore one at a time since a account can only have 10 characters per realm.