Why should I backup my database?
A database a storage place by dynamic content. Even
if you have not changed your website html and pictures
for some time, you database would have changed as
your website script interacted with website visitors.
It is very important to do periodic backup of your
database even if you have not changed you website
for some time.
A lot of web applications use MySQL database(s)
for storing the content. This can be blogs, shopping
carts, content management systems, support systems
and most of the Fantastico scripts. You can check
your hosting control panel to verify how many MySQL
databases you are using.
We have PhpMyAdmin installed on our servers,
accessible via cPanel / HELM. Please Open phpMyAdmin
from the domain control panel.
Create Backup of MySQL database
-
Select you database from the left panel (if
you have multiple databases), Click Export in
the Menu to get to where you can backup you
MySQL database.
-
Make sure that you have selected to export your
entire database, and not just one table. There
should be as many tables in the export list
as showing under the database name.
-
Select "SQL"-> for output format,
Then,
-
Check "Structure".
-
Check "Add AUTO_INCREMENT" value.
-
Check "Enclose table and field name with
backquotes".
-
Check "DATA", check use "hexadecimal for
binary field".
-
Set Export type set to "INSERT".
-
Now, Check "Save as file", do not change the
file name, use compression if you want. Then
click "GO" to download the backup file.
Restoring a backup of a MySQL database
-
To restore a database,
Select you database from the left panel (if
you have multiple databases), Click the SQL
tab.
-
On the "SQL"-page
, unclick the show query here again.
-
Browse to your
backup of the database.
-
Click Go.
To read more about PhpMyAdmin,
see the documentation.
