View Single Post
  #1 (permalink)  
Old 09-22-2007, 12:20 AM
write2ashokkumar write2ashokkumar is offline
D-Web Programmer
 
Join Date: Mar 2007
Posts: 85
write2ashokkumar is on a distinguished road
Default mysql database dump tips and tricks

Hi,
Here i share with you some tips and tricks about mysql dump options.

Generally we use the command "mysqldump" to take the mysql database dump.


Syntax:
mysqldump [options] db_name [tables] > File path
Example:
mysqldump -u root testdb > /home/backup/db_dump.sql
This command is used to take the backup of database "testdb" tables and its data's into specified file path.


i will share with you the more tips about mysqldump in the up coming posts.... till good bye...
Regards,
S.Ashokkumar
.
Reply With Quote
Sponsored Links