We had some problems with our MySQL server and somehow all I've got is a database.mysql file for the database I want to restore.
I've done a bit of googleing but I didn't find anything about how should I handle this type of file.
It's worth mentioning that the server was running Plesk and the database wasn't using InnoDB.
Edit: I've forgot to mention that I don't know what application created the .mysql file and that it's in binary format.
Thanks,
How was the database.mysql created? If it was just a standard mysqldump then all you should have to do is something like
cat database.mysql | mysql -h hostname -u username -p [database]
.You can tell it is a mysql dump file by looking at the file in a text editor. The first few lines of a mysqldump will look like this.
If it is a dump you may need to examine the dump file a bit. It may not perform the required
create database
statement, and you may need to do that. You will probably also need to recreate any accounts if the dump you have didn't include the database named mysql which includes the accounts and privileges.