MySQL database backup
If you store any database in MySQL, you do not want to lose, you should do weekly or even daily backups. Depending on the database you are using-whether it is storing forum information, employee information, or your expense information-you will need to select a backup schedule to meet your needs.
You may or may not know that MySQL's database is just files that are stored on your Web server. This fact makes the entire backup and recovery process very simple, painless once you know how to do it.
Different ways to make backups
There are many ways to take a backup of MySQL to build. However, regardless of which application, Control Panel tool, or SSH script is used, all backups will be available for two types of backups: dumps or raw material backups.
MySQL self-unloading
A MySQL dump is slightly below the raw material backup, as it creates all the SQL queries needed to create tables, databases, and all the data needed to insert the query into the database to be backed up to the table.
If you want to perform a database dump manually, without your assistance to host the control Panel, then run the SSH to your Web server and do the following (taken from mysql.com):
Mysqldump-tag =/path/to/some/directory-select DB _name
If you open a MySQL dump file you will see a series of SQL queries that you may be able to understand if you have read through the entire tutorial! ） 。
MySQL's original backup
A MySQL raw backup is fast because it has no translated content database to human readable SQL queries. However, there are not many control panels that support this type of backup, so don't worry if your hosting service provider does not have this option set for you.
The MySQL backup Control Panel in the cpanel www.111cn.net/cpanel is the most widely used web hosting control panel at this time, so we think it will make sense to provide a dedicated cpanel for roaming.
Click "Backup" from the application selection screen. This will make your backup application so that you can build and download the full backup of your site.
If you want to back up a database, individually, look for the title "Download SQL database Backup" or something like that. Below this heading should list each database that you have created. Just click the name of the database to back up and save it to your computer.
That's it! Now as long as you regularly back up the schedule, just in case it happens incredibly and your web host loses all the database information!
