Type this on SSH / command line
mysqldump -u username -p database_name --routines > /home/asim/database_backup_with_procedures.sql
Type in the password when prompted.
P.S. Replace username with actual mysql username and database_name with actual database name.
thanks a lot..it works
Thanks !!!!!I It works