Database dump & restore

make database dump:

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

restore the dump:

#mysql -u root -p
mysql> create database xyz;
mysql -u root -p [dbname] < pvdm.sql

delete database:

#mysql -u root -p
mysql> drop database xyz;