mysqldump backup & restore with stored procedure & function
Iam taking mysql backup from the below command
mysqldump -u root -pecare2@ softwareinfo > test1.sql
while restoring mysql backup iam using the below command
mysql -u root -pecare2@ softwareinfo < test1.sql
while restoring the mysqldump backup i was not able to get the database stored procedure,triggers& functions,can any one help on the command how to take database backup with stored procedure,triggers & functions.