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

Archive::Windows Servers Archive area for Windows Servers's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-28-2003, 07:25 AM
kai_shadowbane
Sarnak
 
Join Date: Sep 2003
Posts: 67
Default I know this may be a stupid MySQL question but...

How do you add the new database files in while replacing the old records when using the source command?

E.G. using the default source, and then adding in the new db for items, and such
Reply With Quote
  #2  
Old 09-28-2003, 07:30 AM
Guest
 
Posts: n/a
Default

Depends whether the you want to source in a completely new db.

In that case

drop database eq ;

create database eq ;

use eq ;

source <new db>
Reply With Quote
  #3  
Old 09-28-2003, 07:33 AM
kai_shadowbane
Sarnak
 
Join Date: Sep 2003
Posts: 67
Default

actually it was more that I want to use the info of the original db, and then add in the new stuff over top of what I already have, since the newer files are more updated, but the newer db may not have all the things in it the old db has
Reply With Quote
  #4  
Old 09-28-2003, 10:36 PM
nilremdrol
Fire Beetle
 
Join Date: Jul 2003
Location: Idaho
Posts: 10
Default

You need to drop the specific tables and then source in the new db files that will recreate the database files you just dropped. Be carefull to only drop the ones that you'll replace or you'll hose your db. (did that a few times lol) Open your new file in notepad and see what it creates or adds etc to know what to delete.
I usually use the mysql control center just cause i'm not fast with the cli yet, you might want to play with that, it helped me understand what I was doing a bit more. Still learning <grumble grumble>
-Nil
Tendrils of Darkness
Reply With Quote
Reply

Thread Tools
Display Modes

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 09:35 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