Character Migration to Npcbot Version Emucoach repack

[eyerobot]

Make a backup of your existing databases by right clicking and choose sql dump, Check the boxes next to drop and create first.
These should be emucoach-auth, emucoach-char, And emucoach world databases, However they are currently named.

Rename your old _Server Folder to _Serverbak
Extract the new Database into your saving folder, Then go into the database folder, And drag the _Server folder to your C drive.
Extract the Release folder into your saving folder, Then drag the new folder into C:/_Server.
Extract all map files into c:/_Server/Release.

IMPORTANT
If the names of auth and char database that you backed up are different than the names of the current auth and char databases, Then you need to edit two databases you created previously with Notepad++, Once you have the editor open, Drag your mouse over the incorrect database name, Then click search at the top, And then click replace. In that new pop up window the first thing you see listed is the text that you highlighted, In the bottom area post the correct name of the database that you want to change it to. Then click replace all, And boom the entire file is altered to the new database name. Do this for both of the old database files you created.

Go into the _Server folder and click Mysql.
After Mysql starts, Open Heidisql. Login to your new server, And select the auth database, Then click the folder button at the top middle to open a file to run on that database. Choose the auth file that you backed up previously. And click the run button at the top.

Now select the Char database, And run the backup char file that you created earlier.

This will add all of your character data back into your new server, But it will not give you the database table named characters.npcbot, So this needs to be added manually.
Select the char database, And open a new query window, Copy and paste this into the window, And then click the run button.

-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.5.9-log - MySQL Community Server (GPL)
-- Server OS:                    Win32
-- HeidiSQL Version:             9.4.0.5125
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- Dumping database structure for emucoach_char_v8_vip
USE `emucoach_char_v8_vip`;

-- Dumping structure for table emucoach_char_v8_vip.character_npcbot
DROP TABLE IF EXISTS `character_npcbot`;
CREATE TABLE IF NOT EXISTS `character_npcbot` (
  `owner` int(10) NOT NULL DEFAULT '0',
  `entry` int(10) NOT NULL DEFAULT '0',
  `race` tinyint(3) DEFAULT NULL,
  `class` tinyint(3) DEFAULT NULL,
  `istank` tinyint(3) DEFAULT NULL,
  `equipMhEx` int(10) DEFAULT NULL,
  `equipOhEx` int(10) DEFAULT NULL,
  `equipRhEx` int(10) DEFAULT NULL,
  `equipHead` int(10) DEFAULT NULL,
  `equipShoulders` int(10) DEFAULT NULL,
  `equipChest` int(10) DEFAULT NULL,
  `equipWaist` int(10) DEFAULT NULL,
  `equipLegs` int(10) DEFAULT NULL,
  `equipFeet` int(10) DEFAULT NULL,
  `equipWrist` int(10) DEFAULT NULL,
  `equipHands` int(10) DEFAULT NULL,
  `equipBack` int(10) DEFAULT NULL,
  `equipBody` int(10) DEFAULT NULL,
  `equipFinger1` int(10) DEFAULT NULL,
  `equipFinger2` int(10) DEFAULT NULL,
  `equipTrinket1` int(10) DEFAULT NULL,
  `equipTrinket2` int(10) DEFAULT NULL,
  `equipNeck` int(10) DEFAULT NULL,
  `active` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`owner`,`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table emucoach_char_v8_vip.character_npcbot: ~0 rows (approximately)
DELETE FROM `character_npcbot`;
/*!40000 ALTER TABLE `character_npcbot` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_npcbot` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

A couple things to know if you don't have a computer dedicated for server development.
OpenSSL needs to be installed on your computer, Or you get startup errors when you start your server.
DO NOT INSTALL THE LIGHT VERSION http://slproweb.com/products/Win32OpenSSL.html
Get the correct non light version for your operating system wether it's 32 or 64 bit.

After installing OpenSSL Browse to c:/windows/system32 or windows/syswow64 and copy Ssleay32.dll. This needs to be pasted into your C:/_Server/Release folder.

And that's about it. You should now have all of your characters from your old server in the new one.

 

[KheZu]

This is for the VIP version only or? Npcbots