How to take backup of mysql database and restore it ?
….
Backup –
mysqldump -u user -p databasename > backupname.sql
Create – empty database should be created before restoring.Database has to be created in mysql console
create database databasename;
Restore –
mysql -u user -p databasename < backupname.sql