SQL backup

m
m
Line 4: Line 4:
  
 
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}}
 
  {{#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.
 
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.
 
Note: restoring the database dump will overwrite all changes made after the dump is created.

Revision as of 13:00, 25 October 2011

rss feed for my website