Here's a simple command to optimize and auto repair all tables in your MySQL database.
mysqlcheck -uroot -p --auto-repair --optimize --all-databases
This is the same thing as using PHPMyAdmin, however, you don't need to do this one by one for each database, select all tables, and optimize--and not to mention if you wanted to repair a database prior to optimizing, it will take 2x as long.