Friday, August 21, 2009
MySQLDump Database with Stored Procedures
MySQLDump Database with Stored Procedures
The following query/commands shows the option to backup mysql database along with its stored procedures and routines
-R --> this will include all the information about routines, stored procedures, functions
Featured Blog Topics:
The following query/commands shows the option to backup mysql database along with its stored procedures and routines
MySQL> mysqldump -h hostname_or_ip -u root -p password --databases database1 database2 database3 ... databaseN -R
-R --> this will include all the information about routines, stored procedures, functions
Featured Blog Topics:
- Xml in MySQL - http://kathyravan.blogspot.com/2008/03/xml-in-mysql.html
- Forgot mySQL root Password? - http://kathyravan.blogspot.com/2008/02/forgot-mysql-root-password.html
- Samba - Installation & Configuration - http://kathyravan.blogspot.com/2008/02/samba-installation-configuration.html
- Enabling HTTP Authentication in Apache - http://kathyravan.blogspot.com/2008/08/enabling-http-authentication-in-apache.html
- PHP Function: isFTPFileExists (Searching a FILE in FTP) - http://kathyravan.blogspot.com/2008/12/php-function-isftpfileexists-searching.html
- Shell Scripting & Linux - http://kathyravan.blogspot.com/search/label/Shell%20Scripts
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment