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 12-02-2020, 12:49 PM
Bytebait
Sarnak
 
Join Date: Oct 2014
Location: Colorado
Posts: 74
Default How to restore from database_backup?

Alrighty! Fresh Windows 'eqemu_install' install and it's great! I ran the t_database_backup.bat file and found the sql file in the backups just fine. Now... In case I needed to, how do we restore to that backup?
Reply With Quote
  #2  
Old 12-04-2020, 11:32 PM
Kucerakov005
Fire Beetle
 
Join Date: Jul 2013
Posts: 3
Default SQL instructions

First, you would use HeidiSQL to delete your peq database. This is scary so instead of doing this, I always create a 'test' database first and restore my backup to that. If it looks good, then I go ahead and delete the peq database.

Once you have deleted it, now create a new one with the same name 'peq'.

Then, open a command prompt (not powershell because it won't take the less than symbol) and type

mysql -h localhost -u root -p peq < PATH TO SQL FILE

then it will prompt you for the password and start the restore.


For me, this looks like:
mysql -h localhost -u root -p peq < "C:\users\MyUser\Desktop\EQEmu\Server\Backups\peq_ 12_01_2020.sql"
Reply With Quote
  #3  
Old 12-05-2020, 02:35 PM
Bytebait
Sarnak
 
Join Date: Oct 2014
Location: Colorado
Posts: 74
Thumbs up

Quote:
Originally Posted by Kucerakov005 View Post
First, you would use HeidiSQL to delete your peq database. This is scary so instead of doing this, I always create a 'test' database first and restore my backup to that. If it looks good, then I go ahead and delete the peq database.

Once you have deleted it, now create a new one with the same name 'peq'.

Then, open a command prompt (not powershell because it won't take the less than symbol) and type

mysql -h localhost -u root -p peq < PATH TO SQL FILE

then it will prompt you for the password and start the restore.


For me, this looks like:
mysql -h localhost -u root -p peq < "C:\users\MyUser\Desktop\EQEmu\Server\Backups\peq_ 12_01_2020.sql"
Thank you! I hope to never have to use it, but it's good info to have for sure. Thanks again!
Reply With Quote
  #4  
Old 05-31-2024, 10:27 PM
mitrestre1
Fire Beetle
 
Join Date: May 2024
Posts: 1
Default Still works

This still works as of May 31-2024
Reply With Quote
Reply


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 03:00 PM.


 

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