m |
m |
||
| Line 1: | Line 1: | ||
<seo title="SQL backup" metakeywords="sql backup,database dump,create database backup" metadescription="SQL backup" /> | <seo title="SQL backup" metakeywords="sql backup,database dump,create database backup" metadescription="SQL backup" /> | ||
| − | + | <br> | |
| + | <div align="justify">All [http://myidealhost.com/hosting.shtml web hosting plans] offered by [http://myidealhost.com/about.shtml MyIdealHost hosting provider] support database management system called MySQL. Each MySQL database is a set of related files and like any file the database could be corrupted and you will be forced to restore it from your database backup. In this tutorial you'll find out how to create a database backup which will allow you to keep a copy of your DB on the local PC. | ||
First, log in to your '''[[cPanel]]''' and go to the ''''[[Files]]'''' section. There you are to look for ''''Backups'''' => ''''''Download a MySQL Database Backup''''''. This SQL backup will contain your DB copy. | First, log in to your '''[[cPanel]]''' and go to the ''''[[Files]]'''' section. There you are to look for ''''Backups'''' => ''''''Download a MySQL Database Backup''''''. This SQL backup will contain your DB copy. | ||
| + | {{#icon: SQL backup.png|SQL backup}} | ||
| − | - | + | Once you choose the database needed you'll get a pop-up window offering you to '''save''' the database dump (a database dump contains a record of the table structure and/or the data from a database and is usually in the form of a list of SQL statements.) It is being generated in .sql.gz format. Save this SQL backup file to be able to restore in the case of data loss. |
| − | + | '''''Note: restoring the database dump will overwrite all changes made after the dump is created.'''''</div> | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | Note: restoring the database dump will overwrite all changes made after the dump is created. | + | |
.jpg)
