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.

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.