Database dump & restore: Difference between revisions
New page: make database dump: mysqldump -u root -p –all-databases > pvdm.sql restore the dump: mysql -u root -p [dbname] < pvdm.sql |
No edit summary |
||
| Line 2: | Line 2: | ||
mysqldump -u root -p –all-databases > pvdm.sql | mysqldump -u root -p –all-databases > pvdm.sql | ||
restore the dump: | restore the dump: | ||
#mysql -u root -p | |||
mysql> create database xyz; | |||
mysql -u root -p [dbname] < pvdm.sql | mysql -u root -p [dbname] < pvdm.sql | ||
delete database: | |||
#mysql -u root -p | |||
mysql> drop database xyz; | |||
Revision as of 14:00, 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 -u root -p [dbname] < pvdm.sql
delete database:
#mysql -u root -p mysql> drop database xyz;