How to take dump back of database on RDS web server with store procedure

sudo mysqldump -h <host-name> -u root –databases <database-names> –routines –single-transaction –compress –order-by-primary -p > all-database.sql
sudo mysql -h <host-name> -u root -p <database> < all-database.sql
Best art:  http://www.logikdev.com/2011/03/01/how-to-dump-mysql-functions-and-stored-procedures/
Note:  routines   is used for store procedure
Thanks
Vinod K Maurya
Advertisements