Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Analyze all tables in a mysql database from the command line (bash)
#!/bin/bash
# To avoid doing things like putting your mysql password on the cli which is not secure
# Use mysql config editor http://dev.mysql.com/doc/refman/5.6/en/mysql-config-editor.html
for table in $(mysql --login-path=mylogins -D database_name -Bse "show tables");
do mysql --login-path=mylogins -D database_name -Bse "analyze table $table";
done
@hnhegde

This comment has been minimized.

Copy link

hnhegde commented Nov 18, 2017

Hello,
With MySQL 5.5 and above, we can use:
mysqlanalyze --login-path=mylogins --databases database_names

Regards,
Harsha

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.