Migrating Accounts: A Mini How-To

[CrabClaw]

After upgrading to Angelox's database I had to migrate all my accounts, characters and items to the new database. For those of you who are thinking of doing this here is what I did:

First off, I use the windows version of MySQL Administrator program for all my work.

Launch the administrator and click on the "Backup" section. Here you will create a new project to back up each of your databases. Make sure you have a common directory for all of your backup files, as it makes it easier to find them later.

I made a project for backing up my EQ database called "EQ Backup" and one for my PEQ database called "PEQ Backup".

After making a backup of all my databases, I create a new backup project called Accounts Backup.

Choose the database you want to move your accounts from and click the ">" button to copy it into the next pane.

In the pane where you choose what tables in the database you want to move your accounts from and check off all of the tables and re-select just the following:

account
character_
character_backup
inventory
sharedbank

Click "Save Project", and execute the backup.

Next go to the "Restore" section and click "Open Backup File" and open your Accounts backup.sql file.

IMPORTANT Step: In the "general" section of the first pane, there is a drop down box called "Target Schema" change this to the target database you want to copy your Accounts Backup to.

Run the backup with the "Start Restore" button. After a moment, you should be good to go! You can check it using the MySQL Query Browser tool or just logging in and seeing if it worked. NOTE: This will replace the tables the account tables in the new database.