Difference between revisions of "Backup MySQL"
From GWAVA Technologies Training
(Created page with "This article is a very bare bones "dummy's guide" set of information. If you'd like to learn more check out the [http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html MySQL p...") |
|||
| 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 here] | + | 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 that switch here] |
Now for the examples | Now for the examples | ||
Revision as of 17:35, 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.
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 switch Check out the MySQL documentation on that switch here
Now for the examples
Linux
At the command line type mysqldump
