Quote:
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!