Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers
Reload this Page Transferring Server Database

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

Reply
 
Thread Tools Display Modes
  #1  
Old 09-26-2015, 11:58 PM
Shendare
Dragon
  
Join Date: Apr 2009
Location: California
Posts: 814
Default
Are you exporting/importing with HeidiSQL? If you change the "Max INSERT size" value to... really anything but the default 0, it'll work a -helluvalot- faster.

I like running at 1024 KB, but you can run it at a -tiny- tiny number like 16 KB, and it'll both export and import an order of magnitude faster.
Reply With Quote
  #2  
Old 09-27-2015, 10:22 PM
Trackye
Sarnak
  
Join Date: Feb 2008
Posts: 87
Default
I generally use Navicat but I have Heidi installed to. perhaps I can give that a shot as well.

Thanks!
Reply With Quote
  #3  
Old 09-27-2015, 10:24 PM
Akkadius's Avatar
Akkadius
Administrator
  
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default
Yes the time comes from all of the individual statements that are being ran versus bulk inserts. Once again my script takes care of that on its own.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode

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:21 PM.

EQEmulator - Archive - Top

 

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