SQL backup

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" />
  
Using your cPanel you can create a database-driven site. It happens sometimes that something goes wrong with your site and you would like to restore the site to its previous state. 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.
+
<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 ''''[[File]]'''' 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.
  
{{#icon: SQL backup.png|Info}}
+
'''''Note: restoring the database dump will overwrite all changes made after the dump is created.'''''</div>
 
+
----
+
 
+
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.
+

Latest revision as of 10:55, 29 October 2012

rss feed for my website