Hello How can i run the repir and then the optimize command for my sql database like i do from phpmyadmin? Thank you
mysqlcheck --repair --optimize databasename I usually like to pip --auto-repair on rather than repair. Hope this helps!
Do you mean to run it as one command: mysqlcheck --repair --optimize databasename or like this? mysqlcheck --optimize databasename or i can run both?
You can run them both in one command. Just a tip though, run it in screen. Depending on the size of the db it can take some time.