Backup of mysql database
Use the following command to get backup of complete mysql database.
shell> mysqldump -u [username] -p[password] –all-databases > [backupfile.sql] –if you want to take backup of selective database then u need to specify database name like shell> mysqldump -u [username] -p[password] –databases [databasename] > [backupfile.sql]
Syntax in above commands are explained below
username – User name of mysql database
password – Password of mysql database
databasename – Name of the database you want to take backup
backupfile – Name of the backup file
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
Related Post
Comments
Leave a Reply