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?
|
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" |
Quote:
|
All times are GMT -4. The time now is 07:36 AM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.