Database dump & restore

make database dump:

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

restore the dump:

mysql -u root -p [dbname] < pvdm.sql