09-25-2007, 06:09 AM
|
| D-Web Programmer | | Join Date: Mar 2007
Posts: 85
| |
 Re: mysql database dump tips and tricks
Hi,
For generally, when taking the mysql database backup by using general options, the store procedure and functions are wont include in the backup script... so we use the some special options for take the backup to stored procedure and functions. Example : mysqldump -u root --routines testdb > /home/backup/dump_data.sql Options: --routines => Dump stored routines (functions and procedures) from the dumped databases Regards,
S.Ashokkumar
Last edited by write2ashokkumar : 09-25-2007 at 06:24 AM.
|