Backing Up and Restoring A MySQL Database

This tutorial explains the how to backup and restore the MySQL Database. Databases are used to store large amount of precious data and it becomes very important to Backup your data. In case case of some hardware or software failures backup data can be used to restore the Database.

This tutorial explains the how to backup and restore the MySQL Database. Databases are used to store large amount of precious data and it becomes very important to Backup your data. In case case of some hardware or software failures backup data can be used to restore the Database.

Backing Up and Restoring A MySQL Database

This tutorial explains the how to backup and restore
the MySQL Database. Databases are used to store large amount of precious data
and it becomes very important to Backup your data. In case case of some hardware
or software failures backup data can be used to restore the Database.

Here is the video tutorial of: "How to backup and restore MySQL database?"

Copying the MySQL database files

MySQL uses the same table format on different
platforms, so it's possible to copy MySQL table and index files from one
platform and use them on another without any difficulties (assuming, of course,
that you're using the same version of MySQL on both platforms).

Exporting tables to text files

The MySQLDump is handy utility that can be used to
quickly backup the MySQL Database to the text files. To use the MySQLDump
utility it is required to logon to the System running the MySQL Databse. You can
use Telnet to remotely logon to the system if you don't have the physical access
to the machine.

Let's discuss the example of backing up
MySQL Database named "accounts" into text file accounts.sql. Here are
the scenarios of taking the backup assuming that both user name and password of
the database is "admin".

a) Taking the full backup of all the
tables including the data.
Use the following command to accomplish this:mysqldump -u admin -p admin accounts > accounts.sql