Copy characters to a new server

[phantomghost]

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.