I also using InnoDB Engine mainly for my small MRP Database.
And I usually do this to backup:
Code:
mysqldump database_name -u root -p rootpass > backup.sql
And to restore, just use these commands:
Code:
$mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 132
Server version: 5.0.32-Debian_7etch1-log Debian etch distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>source backup.sql;
I did the backup almost everyday, and the restoration is prefect..
I hope this will help
------Edited----------
Ah, sorry! I think you have found your solution... But it's no shame isn't it?
Regards