Difference between revisions of "Backup MySQL"
| Line 4: | Line 4: | ||
The mysqldump program bundled with MySQL is one of the best ways that has been found to backup a MySQL database. | The mysqldump program bundled with MySQL is one of the best ways that has been found to backup a MySQL database. | ||
| − | For Retain you'll want to use the --single-transaction switch [http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html#option_mysqldump_single-transaction Check out the MySQL documentation on | + | For Retain you'll want to use the --single-transaction and possibly the --quick switch [http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html#option_mysqldump_single-transaction Check out the MySQL documentation on those switches here]. |
| − | + | Using the --quick switch may depend on the size of your database, the bigger it is the more important it may become to use it for your dump script. | |
| − | ===Linux=== | + | ===Examples=== |
| + | ====Linux==== | ||
At the command line type mysqldump | At the command line type mysqldump | ||
| − | ===Windows=== | + | ====Windows==== |
Revision as of 17:42, 9 January 2015
This article is a very bare bones "dummy's guide" set of information. If you'd like to learn more check out the MySQL page on using MySQL dump: http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html Or this article on database backup methods if you'd like to look into other options. Plus there's a whole world of internet to search.
Contents |
MySQL dump
The mysqldump program bundled with MySQL is one of the best ways that has been found to backup a MySQL database.
For Retain you'll want to use the --single-transaction and possibly the --quick switch Check out the MySQL documentation on those switches here.
Using the --quick switch may depend on the size of your database, the bigger it is the more important it may become to use it for your dump script.
Examples
Linux
At the command line type mysqldump
