Restoring

Restoring from FILENAME.mysql is a three step process. This occurs, again, in a command shell:

1. Drop the database:

mysqladmin -u USERNAME -p drop DATABASE

or

mysqadmin -u USERNAME --password=[password] drop DATABASE

[spacer]

Red Hat Linux requires rm -rf owmetadb to drop this database.

2. Recreate the database

mysqladmin -u USERNAME -p create DATABASE

or

mysqadmin -u USERNAME --password=[password] create DATABASE

3. Import the backup data

mysql -u USERNAME -p DATABASE < FILENAME.mysql

or

mysql -u USERNAME --password=[password] DATABASE < FILENAME.mysql