Restoring from FILENAME.mysql is a three step process:
Drop the database
Quote:
|
mysqladmin -u USERNAME -p drop DATABASE
|
Recreate the database
Quote:
|
mysqladmin -u USERNAME -p create DATABASE
|
Import the backup data
Quote:
|
mysql -u USERNAME -p DATABASE < FILENAME.mysql
|