Jump to content

View source for Database dump & restore

← Database dump & restore

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: Users.

You can view and copy the source of this page.

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;

Return to Database dump & restore.

Retrieved from "https://www.reeltoreel.nl/wiki/index.php/Database_dump_%26_restore"