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
  #4  
Old 07-12-2010, 02:51 AM
robinreg
Sarnak
 
Join Date: Feb 2010
Location: California
Posts: 88
Default

what I do is that I use HeidiSQL, I would select the table I want to backup. Say I want to save my lootdrop table. I would right click on the table and select bulk table editor. That will bring up a table tool window. I then would select the SQL export and make sure that I have drop and create checked with replace existing data. On the left side you'll see a list of tables you can check that you want to back up on from your database. I would want to save it as "One Big File" on the output list. On the bottom left side you'll see skip tables larger than. I would click put that on "0" so it doesn't skip the one you want to save if it's bigger than what you have it as. On the icon where it looks like a floppy disk, you would click on that and it would pull up your directory in which you want to save your data in. Just give it a name. then click okay and it'll create a SQL file with all your data in it. then when you upgrade your database. just simply source your backup data into your database. It'll drop the exisiting tables on the database and replace it with the one you have. Hope that helps.
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 10:35 PM.


 

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