tag:blogger.com,1999:blog-8545214922787541097.post4639278705923080480..comments2023-10-31T00:27:20.936-07:00Comments on Database Administration: mysqlcheck automatic scriptAftab Khanhttp://www.blogger.com/profile/17201066985732943851noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8545214922787541097.post-6768839617140047412011-06-06T06:23:46.936-07:002011-06-06T06:23:46.936-07:00No this is not right, actually, query_output.log f...No this is not right, actually, query_output.log file is used to capture output of one table status at a time i.e. via 'check table' but, you can modify this script according to your requirements.Aftab Khanhttps://www.blogger.com/profile/17201066985732943851noreply@blogger.comtag:blogger.com,1999:blog-8545214922787541097.post-31919296882572384512011-03-25T03:05:32.514-07:002011-03-25T03:05:32.514-07:00nice script! thanks!
but maybe
echo "$stats...nice script! thanks!<br /><br />but maybe<br /><br />echo "$stats_method;check table $table\G" | $mysql > ~/scripts/query_output.log<br /><br />should be :<br /><br />echo "$stats_method;check table $table\G" | $mysql >> ~/scripts/query_output.logUnknownhttps://www.blogger.com/profile/17575202578634136883noreply@blogger.com