Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 10-02-2011, 04:35 PM
Rhodan
Hill Giant
 
Join Date: Oct 2006
Posts: 179
Default

Start by setting up a new database but use a different name. Follow the same instructions you used to set up the original database just use something like "create database peqoffline;" then "use peqoffline;"

Once you've sourced in the database and updates you can dump the unmodified database to disk as a backup. from an MSDOS prompt you can type

c:/>mysqldump -uyourusername -pyourpassword peqoffline >pequnmodified.sql

That gives you an up to date copy that you can source in later (if needed) without having to apply all the updates again.

Next dump just the npc_types table so if you mess up you can drop npc_types table and source the table back in without having to do the entire database.

c:/>mysqldump -uyourusername -pyourpassword peqoffline npc_types >pequnmodified.sql


Now you can drop the second database since you have the sql files.

from a mysql console

drop database peqoffline;

now go to your main database and make a backup of that in case something goes horribly wrong. Use the same mysqldump command as above just change the database name.

Once that is done, drop the npc_types table from the mysql command prompt

drop table npc_types;

source in the unmodified table you dumped earlier.

source npctypes.sql;

THen everything should be back to the default NPCs and you can experiment away knowing you have an unmodified table backup in case anything goes wrong.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 02:53 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3