I've had currupted tables backup several times, however i've had the currupted data trunicated from the backup (using mysqldump).
As for optimize taking so long, it'd vary based on several variables, such as db size, available resources (memory/processor). If you have a busy server, at peak hours, and a large database, it'll definitely take longer than a server at off peak hours with available resources and a smaller database.
Also, executing the command via the MySQL command line interface will run much faster than issuing the command through a web script (such as PHPMyAdmin).
Last edited by Gizmo; 12/05/2006 1:59 AM.