I want to restore mysql database from a dump file.
mysql database restoration command is this :
$mysql -u user -pserpassword database_name < dumpfilename.sql
I want to log restoration. How do I log into a file ?
At the start of restoration , log file will log text "restoration started on [date & time] "
At the end of restoration , log file will capture text "restoration completed on [date & time]"