View Single Post
  #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