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

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

Reply
 
Thread Tools Display Modes
  #1  
Old 11-20-2017, 03:24 PM
kuahara
Sarnak
 
Join Date: Aug 2010
Location: Wichita Falls, Tx
Posts: 36
Default Copy characters to a new server

If I create a 2nd EQ Emu server, is there an easy way to copy the toons from one server over to the other?

In an effort to resolve an issue, I updated the binaries on the original server and foolishly enough, didn't backup my eqemu server prior to doing that. The update messed everything up. I can no longer enter world from char select if MQ is running (it crashes when I try) and I refuse to play without it.

I also don't seem to have a way to roll the binaries back as no previous versions of anything in that folder are available. So I'm stuck with this copy character option if it exists.

Any info is appreciated. Thanks.
Reply With Quote
  #2  
Old 12-29-2017, 07:19 PM
phantomghost
Hill Giant
 
Join Date: May 2015
Posts: 126
Default

I realize this is fairly old... but

I believe if you go to your database.

Go to character_data.

In Heidisql you can right click that table, and export to SQL.

Save this in your SQL folder on server as character_data (make sure you save as a SQL file)

Now I am assuming you have more than 1 database. So, when you save it if you are copying from database peq and want to copy to peq1 (open the file ctrl+f peq and change all of those to say peq1 ---save it--- if you do not you will just manually be overriding the peq database --- even if you type in use peq1)

Start>run>cmd

cd c:eq\sql
<enter>
mysql -uuser -ppassword
<enter>
use peq1;
<enter>
source character_data.sql;
<enter>

It should populate those characters onto that database.
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 03:28 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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3