- Uses mysqldump for faster back ups if they are available.
MySQL is one of the most popular database management systems for the development of interactive Websites that need to utilize persistent data sources. As with all other popular database management systems, MySQL offers several methods to backup your important data.
In this version backup your databases using the mysqldump utility that comes with MySQL.
What is mysqldump?
The mysqldump utility is a console-driven executable that lets us specify a host of options to backup a database to an external resource, such as a file, or even a completely different MySQL server running on the other side of the world!
I’m using the word “backup” rather loosely here, because MySQL doesn’t actually backup our data per se. Rather, it creates a set of “CREATE TABLE” and “INSERT INTO” commands that can be executed against a MySQL server to re-create our database(s).
The mysqldump utility can usually be found in c:mysqlbin on Windows operating systems, and in the /usr/local/mysql/bin directory on Unix/Linux systems where MySQL is installed. The mysqldump utility accepts several command-line arguments that you can use to change the way your databases are backed up.
In its simplest form, the mysqldump utility can be used like this:
mysqldump ---user [user name] ---password=[password] [database name] > [dump file]
The mysqldump utility is one of many ways to backup your MySQL databases. It has a wide range of options, is flexible, fast.
If you run a Website that uses a MySQL database, then you should make sure that your database is being backed up on a daily basis.