View source

<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.

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.

Return to SQL backup.

Retrieved from "http://myidealhost.com/tutorials/SQL_backup"

Navigation

Search