Thread: mysql database dump tips and tricks
View Single Post
  #8 (permalink)  
Old 09-26-2007, 06:07 AM
write2ashokkumar write2ashokkumar is offline
D-Web Programmer
  
Join Date: Mar 2007
Posts: 85
write2ashokkumar is on a distinguished road
Default Re: mysql database dump tips and tricks
Hi,

To take the backup of all the database, we can use the following command,


Example:
mysqldump -u root --routines --extended-insert --all-databases > /home/backup/mysql_dump.sql


Regards,
S.Ashokkumar
Reply With Quote