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.
|