Restore just does analyze

[cupboy]

Why is it out of the last 4 database backups I have only the oldest one will restore. The others will only analyze. All it says is "The analyze operation finished successfully". How can I force it to restore from the latest backup?

No table changes have been made between the backups. There is some data that has changed.

This is mysql5.

[MarkR]

Please tell us the exact commands you used to create the backups and do the restores.

Bear in mind that tools such as PHPMyAdmin do not do backups or restores correctly in all cases, particularly for larger (i.e. non-toy) databases.

Mark

[cupboy]

MarkR wrote:

Please tell us the exact commands you used to create the backups and do the restores.

Bear in mind that tools such as PHPMyAdmin do not do backups or restores correctly in all cases, particularly for larger (i.e. non-toy) databases.

Mark

This is what would be a toy database. Less than 100 rows. I used MySQL Administrator. A backup that ran a few hours earlier restores fine, it's just the current backup that won't restore.. or any created later.

So in other words I used no commands at all. Just pressed buttons.