backup from mysql database's routines

by Hamid Reza Fahimi Madjd @ Apr 11, 2009

Sometimes we need get backup just from mysql database's routines.
command below shows us how we can do that:

mysqldump dbname -uusername -p -Rtd > /path/to/your/dump/file
-u username
-p prompt password
-R stored procedures and functions
-t prevent writing table creation
-d "       "       row information
mysql

last tweet