GeorgeS: Dedicated character backup-restore tool

[sesmar]

What I usually do when I get a new version of the DB, such as Angelox's db is something similar to what has been posted here.

I use the base PEQ drop_users.sql script to find all the tables that are related to users. Then I just open up MySql Administrator and create a backup job that backs up those tables. Once I run that job I will open up the SQL script that it creates and find the first reference to the Database name (usually close to top of the file.) So if the Database was named peq I will look for the 'use peq' statement and then I do a find and replace on all instances of peq with my new database name (such as peq to ax_peq). Now all you have to do is restore the backup file and you are all done.

[Angelox]

I used John Adams post and made an "update" sql, that should update just what's needed, and nothing else. I know I should of thought of this before, as it is a simple solution. But I always make "mental blocks for myself.
I tried it out, seems ok if anyone wants to try, it's posted.
Thanks for the as usual help you all give me.

[John Adams]

Just don't forget your peq_admin, and rules* related tables that are not in the base drop_users.sql script (unless it's been added since my d/l on 7/16).

I think those are the only additional server-specific tables added since peq-luclin-rc1.

[sesmar]

Originally Posted by John Adams

Just don't forget your peq_admin, and rules* related tables that are not in the base drop_users.sql script

Yes, as well as the new guild related tables.