How to restore from database_backup?

[Bytebait]

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?

[Kucerakov005]

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"

[Bytebait]

Originally Posted by Kucerakov005

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!

[mitrestre1]

This still works as of May 31-2024