Database dump & restore

From www.ReeltoReel.nl Wiki
Revision as of 14:00, 5 August 2009 by Root (talk | contribs)
Jump to navigation Jump to search

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;