restore database from backup code example
Example 1: mysql backup database
mysqldump database_name > database_name.sql
Example 2: sql restore backup query
RESTORE FILELISTONLY
FROM DISK = 'D:BackUpYourBaackUpFile.bak'
Example 3: mysql restore database
mysql -u [user] -p [database_name] < [filename].sql