Saturday, April 11, 2009

backup from mysql database's routines

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

Labels: ,

0 Comments:

Post a Comment

<< Home