mysql database backup and restore

today i am going to show how to get mysql backup and also how to restore it.

example -

all database full backup

        mysqldump -u root -p --all-databases >  all.sql

 only one(database name -kasun) database   

        mysqldump -u root -p kasun >  kasun.sql 

 restore database

  mysql -u root -p kasun <  kasun.sql

  mysql -u root -p --all-databases < all.sq  

  

thaz for all..:)