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

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

Reply
 
Thread Tools Display Modes
  #1  
Old 04-26-2018, 10:18 AM
logikgear's Avatar
logikgear
Fire Beetle
 
Join Date: Apr 2018
Posts: 20
Default Moving server from windows to linux

My buddy and I are trying to copy the database from our active windows server to a test Linux server. With the Linux server fresh and nothing done to it we can connect no problem. But when we dump the database from the Linux server and import the SQL file that was exported from the windows server it acts like there is a firewall problem. We can see it but when we try and connect it kicks us back to the log in screen.

Anyone have any ideas?
Reply With Quote
  #2  
Old 04-26-2018, 06:45 PM
Tegila
Hill Giant
 
Join Date: Mar 2018
Location: NY
Posts: 125
Default

Make sure the login ip didnt get changed in the transfer from what it was when it worked. Thats exactly what mine was doing before i removed the last few digits.
Reply With Quote
  #3  
Old 04-26-2018, 09:19 PM
logikgear's Avatar
logikgear
Fire Beetle
 
Join Date: Apr 2018
Posts: 20
Default

What login ip are you referring too? is this something i need to change in the database? do the servers have to have the same name?
Reply With Quote
  #4  
Old 04-26-2018, 10:20 PM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 445
Default

Quote:
Originally Posted by logikgear View Post
import the SQL file that was exported from the windows server
Linux is case sensitive, but
This should not be an issue, but "just in case", after you have the database from windows
sourced into the linux server, take a good look at the table names to make sure the "case"
lettering did not get changed. For example: tblloginserveraccounts.

Log files are your best friend
Reply With Quote
  #5  
Old 04-27-2018, 02:25 AM
Mistmaker's Avatar
Mistmaker
Sarnak
 
Join Date: Feb 2014
Posts: 77
Default

During multiple moves of Midgard one of the moves I tried doing was Windows DB to Linux and I had the same issues your having even though the login json file had the same info. This was to a server that was freash installed and working fine before doing the dbdump into it. No errors on dump and looked fine. I never checked what Grumpy mentions but that would make sense to check I just didnt feel like spending any time troubleshooting it.

Just wanted to confirm that it does not work and others have also experienced the problem. I ended up just staying on Windows.
__________________
~ Mr. Gold ~ Pillage and Plunder ~
Reply With Quote
  #6  
Old 04-27-2018, 09:28 AM
logikgear's Avatar
logikgear
Fire Beetle
 
Join Date: Apr 2018
Posts: 20
Default

Where do I find the login.json file? I see a login.ini. the only json file I see is the eqemu_congif.json file. And I did check that after importing the database the config file didn't get changed.
Reply With Quote
  #7  
Old 04-27-2018, 11:20 AM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

I don't believe that the login server is setup to use json or xml files.

Your login.ini should still be current.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #8  
Old 04-28-2018, 12:17 AM
Night_Rider0
Fire Beetle
 
Join Date: Apr 2018
Posts: 2
Default

So why would the Linux install have more tables in the database then the Windows install the database we imported from windows has 215 while the original one that was installed has 234, in case anyone is wondering im the other person trying to set this up, thanks for any help you can provide
Reply With Quote
  #9  
Old 04-28-2018, 12:53 AM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 445
Default

When dumping the database from windows, try this from a CMD prompt :
(remember the folder you are in with prompt)
mysqldump --routines -u root -ppassword peqdbname > peqdbbackup.sql

(Replace all the characters in yellow with your own needs)

Then source that .sql into the linux peqdbname (database)
Reply With Quote
  #10  
Old 04-28-2018, 01:33 AM
Night_Rider0
Fire Beetle
 
Join Date: Apr 2018
Posts: 2
Default Solved

Quote:
Originally Posted by GRUMPY View Post
When dumping the database from windows, try this from a CMD prompt :
(remember the folder you are in with prompt)
mysqldump --routines -u root -ppassword peqdbname > peqdbbackup.sql

(Replace all the characters in yellow with your own needs)

Then source that .sql into the linux peqdbname (database)
Thank you sir!
Reply With Quote
  #11  
Old 04-28-2018, 01:33 AM
logikgear's Avatar
logikgear
Fire Beetle
 
Join Date: Apr 2018
Posts: 20
Default

GRUMPY You Sir Are A GOD!!
that export trick works perfectly!
Thank you SO much.
Reply With Quote
  #12  
Old 04-28-2018, 01:40 AM
logikgear's Avatar
logikgear
Fire Beetle
 
Join Date: Apr 2018
Posts: 20
Lightbulb

For anyone looking to migrate your database this did the trick for us.

Quote:
Originally Posted by GRUMPY View Post
When dumping the database from windows, try this from a CMD prompt :
(remember the folder you are in with prompt)
mysqldump --routines -u root -ppassword peqdbname > peqdbbackup.sql

(Replace all the characters in yellow with your own needs)

Then source that .sql into the linux peqdbname (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 08:10 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