09-23-2007, 11:38 PM
|
| D-Web Programmer | | Join Date: Mar 2007
Posts: 85
| |
 Re: mysql database dump tips and tricks
Hi,
To take a backup of particular table, we can use the following command... Syntax: mysqldump <options> <databasename> <tablename> > <file path> Example:
mysqldump -u root --extended-insert testdb testtable > /home/backup/dump_table.sql Options: --extended-insert => Use multiple-row INSERT syntax that include several VALUES lists. This results in a smaller dump file and speeds up inserts when the file is reloaded.
Regards,
S.Ashokkumar
|