Database dump & restore: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
mysql> create database xyz; | mysql> create database xyz; | ||
mysql> quit; | 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;