Home arrow MySQL arrow Backing Up Your MySQL Databases With MySQLDump
MYSQL

Backing Up Your MySQL Databases With MySQLDump


MySQL includes several ways to backup your important data. In this article Mitchell shows us how to backup our databases using the mysqldump utility that comes with MySQL. He looks at several examples including how to backup your database to a file, another server, and even a compressed gzip file.

Author Info:
By: Mitchell Harper
Rating: 4 stars4 stars4 stars4 stars4 stars / 126
January 30, 2002
TABLE OF CONTENTS:
  1. · Backing Up Your MySQL Databases With MySQLDump
  2. · The mysqldump utility
  3. · More examples

print this article
SEARCH DEVARTICLES

Backing Up Your MySQL Databases With MySQLDump
(Page 1 of 3 )

MySQL is one of the most popular database management systems to use when developing interactive web sites that need to utilize persistent data sources. As with all other popular database management systems, MySQL also includes several ways to backup your important data.

In this article I'm going to show you how to backup your databases using the mysqldump utility that comes with MySQL. We will look at several examples of using MySQL dump, including how to backup your database to a file, another server, and even a compressed gzip file.

This article assumes that you have MySQL installed locally on a Windows, Unix or Linux machine and have administrative privileges on that machine. This article also assumes that you have at least a small amount of exposure to MySQL and the SQL language syntax.
blog comments powered by Disqus
MYSQL ARTICLES

- MySQL and BLOBs
- Two Lessons in ASP and MySQL
- Lord Of The Strings Part 2
- Lord Of The Strings Part 1
- Importing Data into MySQL with Navicat
- Building a Sustainable Web Site
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- PhpED 3.2 – More Features Than You Can Poke ...
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- Security and Sessions in PHP
- Setup Your Personal Reminder System Using PHP
- Create a IP-Country Database Using PERL and ...
- Developing a Dynamic Document Search in PHP ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2014 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials