How To Backup Your Database Using phpMyAdmin PDF Print E-mail
User Rating: / 0
PoorBest 
It is impossible to backup all your database when the backup features in your Cpanel was blocked by your webhosting administrator bcause you are using free webhosting package. Actually there are other option to backup your database by using phpMyAdmin in your Cpanel. With this alternative, you can backup all your important data especially CMS database like Joomla, Wordpress, PHPBB and other CMS.We will show you step to backup after the jump.

First, you need to login to your Cpanel and choose phpMyAdmin under the databases tab. Then on the left side bar, choose the database that you want to backup.

After that, click on the "export" button in the current database header tab like picture below.

Next, click on the "select all" to backup all the database or you can choose which database tree that you want to backup by highlight it with you cursor by simultaneously press the "Ctrl" button

Then, for the backup options, you must check this box

- Comments
- Structure
- Add IF NOT EXISTS
- Add AUTO-INCREMENT value
- Enclose table and field names with backquotes
- Data
- Complete inserts
- Extend inserts
- Use hexadecimal for BLOB

For the drop down box, choose "none" for the SQL compability mode and "insert" for export type like the picture below

Finaly, you can named your backup database by editing the value in the "File name template" and choose your compression type whether "none" for .sql extension, "zipped" for .zip or "gzipped" for .gzip before you click "GO" to start backup process.

(click to enlarge)


 

Add comment


Security code
Refresh

 

Custom Search

 

Main Menu

Donate To Us

Bookmark Us

Facebook MySpace Twitter Digg Delicious Stumbleupon Google Bookmarks RSS Feed 

Related Links

Song Download for Free at MP3 Downloads Website