MySQl 错误 1046 与优化表的 cron

发布于 2024-11-29 18:19:22 字数 469 浏览 1 评论 0原文

按照我之前的问题之一，我开始遇到解决方案错误：

ERROR 1046 (3D000) at line 1: No database selected

具有执行权限的 Crong Job db-optimize.sh。

#!/bin/bash
chk="select concat(TABLE_SCHEMA,'.', TABLE_NAME) from information_schema.tables where data_free>0;"

for tbl in $(mysql -u root -ppass -N <<< $chk)
do
  mysql -u root -ppass -N <<< "optimize table $tbl"
done

我查了一下错误代码，它说我需要处于“MySQL”模式。尽管这看起来是代码已经在做的事情。

原文

Following one of my previous questions I have started to get a error with the solution:

ERROR 1046 (3D000) at line 1: No database selected

Crong Job db-optimize.sh with execute permissions.

#!/bin/bash
chk="select concat(TABLE_SCHEMA,'.', TABLE_NAME) from information_schema.tables where data_free>0;"

for tbl in $(mysql -u root -ppass -N <<< $chk)
do
  mysql -u root -ppass -N <<< "optimize table $tbl"
done

I have looked up the error code and it says that I need to be in "MySQL" mode. Although this looks to be what the code is already doing.

分享到QQ

分享到微博