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

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

Reply
 
Thread Tools Display Modes
  #1  
Old 03-19-2019, 09:52 AM
TigerFeet
Fire Beetle
 
Join Date: Feb 2019
Posts: 22
Default Making changes from Dev to Live

I used the stabdard installer and installed 2 copies of the server, one on my PC for development work, and one on the eventual server with full internet access, ports enabled etc. After a bit of effort i eventually got it all working.

I have now made lots of changes to several tables on the "dev" database and want to commit them to live.

But now I run into problems.

The live server connectts to eqemulator and downloads the updates the team have worked on since I last did an install. Checking these I find they don't conflict with anything I have done.

I tried just copying over my peq DB to live, hoping it would connect, update and then work with all the new changes I have made. But the update would not run properly.

Eventually I had to reinstall the live server and had to think again.

I exported the table I had changed into SQL format (using navicat) but can't get them import into the new database.

Obvioulsy I am doing something very stupid.

How can I make changes to a dev version of the peq database, then commit those changes to a live server?

Can someone please help me out?

Andrew
Reply With Quote
  #2  
Old 03-19-2019, 10:04 AM
belvino
Fire Beetle
 
Join Date: Feb 2019
Location: MS
Posts: 25
Default

If you Used Akkadius Peq installer then you should have a bat file named t_server_database_backup.bat run that and it will put a sql file zipped up in the backup folder.

To upload to new server you go into HeidiSQL then under File use Run Sql file and then select the unzipped backup file.
Reply With Quote
  #3  
Old 03-19-2019, 11:01 AM
TigerFeet
Fire Beetle
 
Join Date: Feb 2019
Posts: 22
Default

wow that was a fast response. I haven't even finished re-installing the "server" version yet.

I will try what you suggested and see what happens.

Thanks
Reply With Quote
  #4  
Old 03-19-2019, 02:45 PM
TigerFeet
Fire Beetle
 
Join Date: Feb 2019
Posts: 22
Default

Yep, worked like a charm. I used a fresh install of the server (as I'd spent 2 days trying to get this to work and messed it up many times) and the backup program and SQL import was brilliant.

Thanks again for your help
Reply With Quote
  #5  
Old 03-19-2019, 03:01 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

Quote:
Originally Posted by TigerFeet View Post
I exported the table I had changed into SQL format (using navicat) but can't get them import into the new database.
As far as exporting tables using Navicat, (I use this myself), when it generates the sql file, it will add this line to it : SET NAMES utf8mb4;
That "utf8mb4" needs to be changed to just utf8 (without the mb4). I usually just dump the table, then open it up with an editor (like notepad++) to correct that, then source it into database.
Reply With Quote
  #6  
Old 03-19-2019, 07:59 PM
phantomghost
Hill Giant
 
Join Date: May 2015
Posts: 126
Default

Also, when you export the a table to .SQL you can edit the file in notepad++ if the db name changes. So, peq to peq1 or peq to peq22 or whatever you name it. (If you name it something that won't be listed in the file you can use replace all. Db name is listed in top section a few times. Then you can source it in to your new db using the updated .SQL file

In case you only want to update 1 table. (Rules for example is one I tend to keep for most of my servers since I updated the description on most rules).
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 11:57 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