Taking backups and restoring databases using phpmyadmin :
You can easily take backups your website databases usign Phpmyadmin all you have to do is to login to your control panel and reach Phpmyadmin screen, select database you want to take backup of. choose ‘eExport’ tab and scrool down the page and click ‘Save as file’ proceed with clicking ‘GO’ button. Thus you have backup copy of your databases onto your local machine.
Once you have backup copy created of database onto your local machine you can easily restore it anytime you want, you need to login to your cpanel and will have to access PHPMyadmin select the database name which you want to restore from the dropdown list. Just select ‘import’ tab and locate file you wish to restore from your local machine by clicking ‘Browse’ button.
Finally you can restore database by clicking ‘GO’ button and you have done.
All backed-up databases are restored using PhpmyAdmin from your cPanel.
Posted under Linux cPanel Hosting, Reseller Hosting, cpanel Hosting, cpanel hosting tips
This post was written by on April 9, 2008
