Using mysqldump to Back Up Your MySQL Database

"Whether you host your website and database internally or you use a hosting provider, it is of paramount importance that you institute a rigorous backup policy. If you're using MySQL, several easily implementable options are at your disposal. This article introduces one such option by showing you how to backup your database using MySQL's native mysqldump client.

"In my professional IT career I've rarely experienced greater rage and frustration than when realizing that an important file or directory has been inadvertently deleted. The feeling is exponentially more nauseating when the data is related to an important client or other mission-critical project, particularly when that data cannot be easily recreated. Unfortunately, such data is plentiful in corporate environments, whether its sales records, carefully managed customer contact data, or archived support forum messages.

"Whether you host your website and database internally or you use a hosting provider, it is of paramount concern that you institute a rigorous backup policy in order to avoid such disastrous consequences. If you're using MySQL, several easily implementable options are at your disposal. In this article I'll introduce you to one such option by showing you how to backup your database using MySQL's native mysqldump client."

Complete Story

Related Stories:

• CouchDB - The Open Source NoSQL Database(Aug 30, 2010)
• Five Indispensable MySQL Tools(Mar 08, 2010)
• Secrets of the MySQL Client Command Line(Feb 06, 2008)
• Managing MySQL Table Relations with Rails' Active Record Association Types(Oct 11, 2007)
• Manage Your MySQL Database with Rails' Migrations(Sep 26, 2007)