Database dump & restore: Difference between revisions
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
#mysql -u root -p | #mysql -u root -p | ||
mysql> create database xyz; | mysql> create database xyz; | ||
mysql> quit; | |||
mysql -u root -p [dbname] < pvdm.sql | mysql -u root -p [dbname] < pvdm.sql | ||
delete database: | delete database: | ||
#mysql -u root -p | #mysql -u root -p | ||
mysql> drop database xyz; | mysql> drop database xyz; | ||
Revision as of 14:01, 5 August 2009
make database dump:
mysqldump -u root -p –all-databases > pvdm.sql
restore the dump:
#mysql -u root -p mysql> create database xyz; mysql> quit; mysql -u root -p [dbname] < pvdm.sql
delete database:
#mysql -u root -p mysql> drop database xyz;