How to take MySQL database backup using PHPMyAdmin

1\) log in to cpanel & look for phpmyadmin icon once you click on it you will open up new window 2\) choose the database you would like to take backup 4\) now look for export & click it choose the export method quick choose the format as sql 5\) now click go & save the file in your backup folder tips on backup based on project activiness we highly recommend to have regular manual & automatic backup policy in place name the file systematically backup date , this will help you to find the latest backup to restore easily you can easily setup backup reminder on your google calendar that will automatically alert you for the backup make sure to make the backup reminder repeatable every few days all majority hosting companies have phpmyadmin , in case if it is not there you can contact support on dedicated hosting you may have to install it, being an open source appplication it is easily available