How to restore database of mysql using bat
Today we are going to learn how to restore a database using commands from mysql
The easy way to do this is using a bat file.
open notepad and type
mysql –u root –proot databasename < c:/backup.sql
save this file in your mysql installed bin folder or c: as “restoredb.bat” The main think is that you have to store backup and this bat in same folder otherwise adjust the bat by entering into that directory ,now double click it you have stored database backup in c:/backup.sql.It will restore the database
Any doubt ask us Happy Coding.
