How to Backup and Restore MySQL Database using command line tool and PhpMyAdmin

Introduction This guide will show you how to backup and restore MySQL database using command line tool in VPS server on CentOS 7 and PhpMyAdmin. You need to take backup of your MySQL database on a daily basis to have minimal impact on your web site’s data loss. Similarly for some inconsistent situations you may need to restore your site’s data into MySQL database. The PhpMyAdmin tool may be found on your cpanel, webuzo or any other control panel.