m |
m |
||
Line 4: | Line 4: | ||
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 ''''[[File]]'''' 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|Info}} | {{#icon: SQL backup.png|Info}} | ||
+ | |||
+ | ---- | ||
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. |