How to backup my database?

[sperko]

Hey all

I've been using my database recently and I would like to back it up manually so I can restore it at a later date if anything goes wrong

Any ideas how to do this?

Thank you

 

[sperko]

I found a way to do this if anybody else needs help

To export a backup of the database OR table

• Go to your cPanel
• Open phpMyAdmin
• Click on the database name OR table name you want to back up
• At the top of phpMyAdmin, click Export
• At the bottom, click Go
• You will be asked to save a file called database_OR_table_name.sql and that will be your back up so keep it in a safe place

To import (restore) a backup of the database OR table

• Go to your cPanel
• Open phpMyAdmin
• Click on the database name OR table where you want to restore your backup
• At the top of phpMyAdmin, click Import
• Click Browse and select the database_OR_table_name.sql file you saved in a safe place previously
  
• At the bottom, click Go

Done!