GeorgeS: Dedicated character backup-restore tool
I've had a few people run requests by me for sql updates.to the DB - I know when I started, this is what I wanted to do, but it became very hard as my "simple" method had to be abandoned due to the memory problems it created. It probably still can be done, but would be very hard and would take up a lot of time, that can be better spent on spawning and building zones.
I'm probably the only one constantly posting my updates (I know there must be more people like me, that hate to wait for updates!), I try to make it as simple as possible so everyone can benefit. The best solution I can think of is a selective backup/restore tool for the database - I use MySql-Admin, and I also have used yours, but why not have a dedicated eqemu character back-up restore tool? one that only keeps track of of tables that are unique to the server, and has little configuration or thinking to do. I usually keep a back up of these; ACCOUNT CHARACTER_ CHARACTER_BACKUP INVENTORY SHAREDBANK But this is just me, and all I mostly do is run around the zones testing and doing db work. I wonder if there would be more tables? If anyone can think of more, please post. I know another would probably be ; some parts of VARIABLES (motd, logintype, etc) For the most of them the utility would probaly need to DROP then remake tables, then add back-up data - but at least for VARIABLES, maybe use REPLACE? And I wonder what other tables would be needed, if any? This would be just a simple, user-friendly tool for back-up and restore tool for any type of server (public or minilogin), that would probably only require you know how to set the db.ini file. |
WARNING: This is just an FYI to Angelox - I do not recommend anyone using this script until you test it out first on a backed-up database.
------------ Angelox, whenever I grab one of your databases, I usually use the PEQ "dump_users.sql" to get rid of those tables in your database, then migrate the remaining "system" tables to the new database. This is the full script I have used. First, I switch to the current AX_PEQ and drop server-specific tables: Code:
use ax_peq; Code:
use peq; |
Thanks John, so probably if the person was using only ax_peq for the server, he would only need back up/restore The first codeblock;
Code:
use ax_peq; Maybe GeorgeS can simplify this in a new tool, I'd be glad to test it. These look like all the tables needed. |
It just dawned on me;
I can easily make a "patch" version of the db; Start with this; Code:
use peq; |
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. |
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. |
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. |
Quote:
Yes, as well as the new guild related tables. |
All times are GMT -4. The time now is 10:21 PM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.