Transfer to new Hard Drive

[Disorder]

Hey folks!

I bought a SSD today and got it up and running. I'd like to move all EQ related files to the new hard drive. I'm not sure how to move my database, server, etc, with out causing all sorts of issues. Should I just do a fresh server set up on new hard drive? I'd prefer to not lose the work I've already done.

Thanks in advance!

[Secrets]

Originally Posted by Disorder

Hey folks!

I bought a SSD today and got it up and running. I'd like to move all EQ related files to the new hard drive. I'm not sure how to move my database, server, etc, with out causing all sorts of issues. Should I just do a fresh server set up on new hard drive? I'd prefer to not lose the work I've already done.

Thanks in advance!

Dump database into sql file.

Move entire EQEmu folder over from old drive to new drive.

Install Perl version that matches the other drive's compile entirely.
Install any MySQL version.

Create + Source Database.

Change eqemu_config.xml to use the new database name, username, password, and hostname.

Start World + eqlaunch (or zone) and any other related programs.

Done.

[Disorder]

Secrets,

Thanks for the quick response. I'm not very handy with mysql command prompt.

Does this look correct? I found this via google and could not get it to work.

mysqldump -h localhost -u [MySQL user, e.g. root] -p[database password] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql

Thanks a bunch.

[Disorder]

Hold off - I think I found a way to do it via navicat. Don't want you to waste your time.

[lerxst2112]

Be very careful doing it with Navicat. You'll want to test if you can restore it before you do anything else.

What was the problem with that mysqldump line? Did you get some sort of error?

[Disorder]

Ok. So i'm getting an error when I try to run the server now. I installed OS on new HD, copied files over as stated, did clean install of perl 5.12, mysql, c++, cmake, navicat, N++, tortoise, and.. I think that is it. I went back through the whole process minus compiling in cmake/C++, etc. I imported my DB into new one. The DB seems correct.

I get this error in eqemu_error_world log

---------------------------------------------
[01.27. - 23:05:53] Starting Log: logs/eqemu_error_world_2752.log
[01.27. - 23:05:53] Failed to connect to database: Error: #2003: Can't connect to MySQL server on 'localhost' (0)

Any suggestions?

[Disorder]

Lerxst2112,

Sorry, I'm not sure what error I was getting. I decided to switch my OS to SSD before I went any further. I used navicat to dump, and used prompt to import from the sql file. Thanks for the response

[Disorder]

Here is my config file..

<?xml version="1.0">
<server>
	<world>
		<shortname>Disorder</shortname>
		<longname>Disorder and Mayhem</longname>

		<!-- Only specify these two if you really think you need to.  (read: You don't) -->
		<!-- <address>some.server.com</address> -->
		<!-- <localaddress>192.168.0.5</localaddress> -->

		<!-- Loginserver information.  Defaults shown -->
		<loginserver>
			<host>eqemulator.net</host>
			<port>5998</port>
			<account></account>
			<password></password>
		</loginserver>

		<!-- Server status.  Default is unlocked -->
		<!--<locked/>-->
		<!-- <unlocked/> -->

		<!-- Sets the ip/port for the tcp connections.  Both zones and console (if enabled).  Defaults are shown -->
		<tcp ip="localhost" port="9000" telnet="disable"/>

		<!-- Sets the shared key used by zone/launcher to connect to world -->
		<key>some long random string</key>
		
		<!-- Enable and set the port for the HTTP service.  Defaults are shown -->
		<http port="9080" enabled="false" mimefile="mime.types" />
	</world>

	<!-- Chatserver (channels) information.  Defaults shown -->
	<chatserver>
		<host>channels.eqemulator.net</host>
		<port>7778</port>
	</chatserver>

	<!-- Mailserver (in-game mail) information.  Defaults shown -->
	<mailserver>
		<host>channels.eqemulator.net</host>
		<port>7779</port>
	</mailserver>

	<zones>
		<defaultstatus>0</defaultstatus>

		<!-- Sets port range for world to use to auto configure zones -->
		<ports low="7000" high="7100"/>
	</zones>

	<!-- Database configuration, replaces db.ini.  Defaults shown -->
	<database>
		<host>localhost</host>
		<port>3306</port>
		<username>MYUSERNAME</username>
		<password>MYPW</password>
		<db>peq</db>
	</database>

	<!-- Launcher Configuration -->
	<launcher>
		<!-- <logprefix>logs/zone-</logprefix> -->
		<!-- <logsuffix>.log</logsuffix> -->
		<!-- <exe>zone.exe or ./zone</exe> -->
		<!-- <timers restart="10000" reterminate="10000"> -->
	</launcher>

	<!-- File locations.  Defaults shown -->
	<files>
		<!-- <spells>spells_us.txt</spells> -->
		<!-- <opcodes>opcodes.conf</opcodes> -->
		<!-- <logsettings>log.ini</logsettings> -->
		<!-- <eqtime>eqtime.cfg</eqtime> -->
	</files>
	<!-- Directory locations.  Defaults shown -->
	<directories>
		<!-- <maps>Maps</maps> -->
		<!-- <quests>quests</quests> -->
		<!-- <plugins>plugins</plugins> -->
	</directories>
</server>

[Disorder]

I ran world.exe in debug mode. This is what I got. I guess i'm missing some files in system 32.

'world.exe': Loaded 'C:\eqemu\world.exe', Symbols loaded.
'world.exe': Loaded 'C:\Windows\System32\ntdll.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\kernel32.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\KernelBase.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Perl\bin\perl512.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\user32.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\gdi32.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\lpk.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\usp10.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\msvcrt.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\advapi32.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\sechost.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\rpcrt4.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\winsxs\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.17514_none_ec8 3dffa859149af\comctl32.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\ws2_32.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\nsi.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\imm32.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\msctf.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\nlaapi.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\NapiNSP.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\pnrpnsp.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\mswsock.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\dnsapi.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\winrnr.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\wshbth.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Program Files\Bonjour\mdnsNSP.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\IPHLPAPI.DLL', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\winnsi.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\rasadhlp.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\WSHTCPIP.DLL', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\wship6.dll', Cannot find or open the PDB file
'world.exe': Loaded 'C:\Windows\System32\FWPUCLNT.DLL', Cannot find or open the PDB file
The thread 'Win32 Thread' (0x954) has exited with code 0 (0x0).
The thread 'Win32 Thread' (0x57c) has exited with code 0 (0x0).
Detected memory leaks!
Dumping objects ->
{807} normal block at 0x00F7F448, 32 bytes long.
Data: <some long random> 73 6F 6D 65 20 6C 6F 6E 67 20 72 61 6E 64 6F 6D
{806} normal block at 0x00F7F3E8, 32 bytes long.
Data: <Disorder and May> 44 69 73 6F 72 64 65 72 20 61 6E 64 20 4D 61 79
{220} normal block at 0x00F78FC8, 32 bytes long.
Data: <channels.eqemula> 63 68 61 6E 6E 65 6C 73 2E 65 71 65 6D 75 6C 61
{219} normal block at 0x00F788C0, 32 bytes long.
Data: <channels.eqemula> 63 68 61 6E 6E 65 6C 73 2E 65 71 65 6D 75 6C 61
{218} normal block at 0x00F78F80, 8 bytes long.
Data: < > 1C 8F F7 00 00 00 00 00
{217} normal block at 0x00F78F10, 52 bytes long.
Data: < > E0 7F F7 00 A0 8D F7 00 E0 7F F7 00 80 8F F7 00
{214} normal block at 0x00F78EC8, 8 bytes long.
Data: <d > 64 8E F7 00 00 00 00 00
{213} normal block at 0x00F78E58, 52 bytes long.
Data: < > E0 7F F7 00 A0 8D F7 00 E0 7F F7 00 C8 8E F7 00
{210} normal block at 0x00F78E10, 8 bytes long.
Data: < > AC 8D F7 00 00 00 00 00
{209} normal block at 0x00F78DA0, 52 bytes long.
Data: <X 0 > 58 8E F7 00 30 8C F7 00 10 8F F7 00 10 8E F7 00
{206} normal block at 0x00F78D58, 8 bytes long.
Data: < > F4 8C F7 00 00 00 00 00
{205} normal block at 0x00F78CE8, 52 bytes long.
Data: < P X > E0 7F F7 00 50 89 F7 00 E0 7F F7 00 58 8D F7 00
{202} normal block at 0x00F78CA0, 8 bytes long.
Data: << > 3C 8C F7 00 00 00 00 00
{201} normal block at 0x00F78C30, 52 bytes long.
Data: < > 08 8A F7 00 C0 8A F7 00 A0 8D F7 00 A0 8C F7 00
{198} normal block at 0x00F78BE8, 8 bytes long.
Data: < > 84 8B F7 00 00 00 00 00
{197} normal block at 0x00F78B78, 52 bytes long.
Data: < P > E0 7F F7 00 50 89 F7 00 E0 7F F7 00 E8 8B F7 00
{194} normal block at 0x00F78B30, 8 bytes long.
Data: < > CC 8A F7 00 00 00 00 00
{193} normal block at 0x00F78AC0, 52 bytes long.
Data: <0 P 0 > 30 8C F7 00 E0 7F F7 00 50 89 F7 00 30 8B F7 00
{190} normal block at 0x00F78A78, 8 bytes long.
Data: < > 14 8A F7 00 00 00 00 00
{189} normal block at 0x00F78A08, 52 bytes long.
Data: < 0 x > E0 7F F7 00 30 8C F7 00 E0 7F F7 00 78 8A F7 00
{186} normal block at 0x00F789C0, 8 bytes long.
Data: <\ > 5C 89 F7 00 00 00 00 00
{185} normal block at 0x00F78950, 52 bytes long.
Data: < x > E8 8C F7 00 C0 8A F7 00 78 8B F7 00 C0 89 F7 00
{182} normal block at 0x00F78878, 8 bytes long.
Data: < > 20 7F F7 00 00 00 00 00
{181} normal block at 0x00F78830, 8 bytes long.
Data: < > 00 7F F7 00 00 00 00 00
{180} normal block at 0x00F787E8, 8 bytes long.
Data: < ~ > E0 7E F7 00 00 00 00 00
{179} normal block at 0x00F787A0, 8 bytes long.
Data: < ~ > C0 7E F7 00 00 00 00 00
{178} normal block at 0x00F78758, 8 bytes long.
Data: < ~ > A0 7E F7 00 00 00 00 00
{177} normal block at 0x00F78710, 8 bytes long.
Data: < ~ > 80 7E F7 00 00 00 00 00
{176} normal block at 0x00F786C8, 8 bytes long.
Data: <`~ > 60 7E F7 00 00 00 00 00
{175} normal block at 0x00F78680, 8 bytes long.
Data: <@~ > 40 7E F7 00 00 00 00 00
{174} normal block at 0x00F78638, 8 bytes long.
Data: < ~ > 20 7E F7 00 00 00 00 00
{173} normal block at 0x00F785F0, 8 bytes long.
Data: < ~ > 00 7E F7 00 00 00 00 00
{172} normal block at 0x00F785A8, 8 bytes long.
Data: < } > DC 7D F7 00 00 00 00 00
{171} normal block at 0x00F78560, 8 bytes long.
Data: < } > BC 7D F7 00 00 00 00 00
{170} normal block at 0x00F78518, 8 bytes long.
Data: < } > 9C 7D F7 00 00 00 00 00
{169} normal block at 0x00F784D0, 8 bytes long.
Data: <|} > 7C 7D F7 00 00 00 00 00
{168} normal block at 0x00F78488, 8 bytes long.
Data: <X} > 58 7D F7 00 00 00 00 00
{167} normal block at 0x00F78440, 8 bytes long.
Data: <8} > 38 7D F7 00 00 00 00 00
{166} normal block at 0x00F783F8, 8 bytes long.
Data: < } > 18 7D F7 00 00 00 00 00
{165} normal block at 0x00F783B0, 8 bytes long.
Data: < | > F8 7C F7 00 00 00 00 00
{164} normal block at 0x00F78368, 8 bytes long.
Data: < | > D4 7C F7 00 00 00 00 00
{163} normal block at 0x00F78320, 8 bytes long.
Data: < | > B0 7C F7 00 00 00 00 00
{162} normal block at 0x00F782D8, 8 bytes long.
Data: < | > 90 7C F7 00 00 00 00 00
{161} normal block at 0x00F78290, 8 bytes long.
Data: <p| > 70 7C F7 00 00 00 00 00
{160} normal block at 0x00F78248, 8 bytes long.
Data: <D| > 44 7C F7 00 00 00 00 00
{159} normal block at 0x00F78200, 8 bytes long.
Data: < | > 0C 7C F7 00 00 00 00 00
{158} normal block at 0x00F781B8, 8 bytes long.
Data: < { > EC 7B F7 00 00 00 00 00
{157} normal block at 0x00F78170, 8 bytes long.
Data: < { > CC 7B F7 00 00 00 00 00
{156} normal block at 0x00F78128, 8 bytes long.
Data: < { > AC 7B F7 00 00 00 00 00
{155} normal block at 0x00F780E0, 8 bytes long.
Data: < { > 8C 7B F7 00 00 00 00 00
{154} normal block at 0x00F78098, 8 bytes long.
Data: <l{ > 6C 7B F7 00 00 00 00 00
{153} normal block at 0x00F78050, 8 bytes long.
Data: <L{ > 4C 7B F7 00 00 00 00 00
{152} normal block at 0x00F77FE0, 52 bytes long.
Data: < x > 08 8A F7 00 C0 8A F7 00 78 8B F7 00 CD CD CD CD
{151} normal block at 0x00F77F98, 8 bytes long.
Data: <4{ > 34 7B F7 00 00 00 00 00
{150} normal block at 0x00F77B30, 1068 bytes long.
Data: <h ` > 68 1F 60 01 98 7F F7 00 CD CD CD CD E0 7F F7 00
{133} normal block at 0x00F75558, 16 bytes long.
Data: < ` i > 00 00 00 00 60 FF 69 01 D0 07 00 00 0A 08 00 00
{132} normal block at 0x00F754E8, 52 bytes long.
Data: < 4j L i T i > 18 34 6A 01 4C F1 69 01 54 F1 69 01 00 00 00 00
{131} normal block at 0x00F75420, 140 bytes long.
Data: < X > 00 00 00 00 00 00 00 00 58 80 BE 00 FF FF FF FF
{128} normal block at 0x00F75338, 8 bytes long.
Data: < L > FC 4C F7 00 00 00 00 00
{127} normal block at 0x00F74CF8, 1540 bytes long.
Data: < 8S default > 00 00 00 00 38 53 F7 00 64 65 66 61 75 6C 74 00
Object dump complete.
The thread 'Win32 Thread' (0xf84) has exited with code 1 (0x1).
The program '[1616] world.exe: Native' has exited with code 1 (0x1).

I'll look over my install again.

[Shrabok]

It's OK that it can't find the symbols for Windows System files, no issues there, and it does also load the world.exe symbols.

<host>localhost</host> fails for me try <host>127.0.0.1</host> instead

[c0ncrete]

the first thing you want to do is drop to a command line and attempt to connect to your database the same way the server does (host/user/pass) in your configuration.

further explanation of the missing file messages you are seeing: pdb files are database files for debug builds. the reason you don't have those is that you don't have debug builds of the dlls that are in your system32 directory. this is normal.

[Disorder]

Finally I am home...

I am able to connect to mysql DB via command prompt as well as navicat. However, I cannot connect via georgeS tools. Perplexing indeed.

Thanks, c0ncrete.

[Disorder]

I got the editor working. Was missing an install of mysql-connector-odbc-3.51.25-win32.

Still can't get server to connect to DB. ><

I imagine it is a minor detail somewhere.

[c0ncrete]

have you tried <host>127.0.0.1</host> instead of localhost yet?

[Disorder]

Amazing.

Figured it was something small. Can you explain why this made the difference? I'm glad it works, but I'd also like to have a deeper understanding of how this web of minor details are related.

Thanks for your time, c0ncrete.