为什么mysql备份还原不了了_为什么mysql备份没有恢复到我的docker容器中？

我想dockerize

mysql数据库.我有.sh脚本用于准备环境,创建数据库,用户和其他东西. Mysql dump restore命令在我的.sh脚本中不起作用,但如果我在其中打开容器shell和exec命令,则工作正常.我想在我的.sh脚本中使用work命令.

我的剧本有什么问题？

Dockerfile：

FROM alpine:latest

WORKDIR /app

COPY startup.sh /startup.sh

COPY backup.sql /app/

RUN apk add --update mysql mysql-client && rm -f /var/cache/apk/*

COPY my.cnf /etc/mysql/my.cnf

EXPOSE 3306

startup.sh：

#!/bin/sh

if [ -d /app/mysql ]; then

echo "[i] MySQL directory already present, skipping creation"

else

echo "[i] MySQL data directory not found, creating initial DBs"

mysql_install_db --user=root > /dev/null

if [ "$MYSQL_ROOT_PASSWORD" = "" ]; then

MYSQL_ROOT_PASSWORD=111111

echo "[i] MySQL root Password: $MYSQL_ROOT_PASSWORD"

fi

MYSQL_DATABASE=myDb

if [ ! -d "/run/mysqld" ]; then

mkdir -p /run/mysqld

fi

tfile=`mktemp`

if [ ! -f "$tfile" ]; then

return 1

fi

cat << EOF > $tfile

EOF

if [ "$MYSQL_DATABASE" != "" ]; then

echo "[i] Creating database: $MYSQL_DATABASE"

echo "FLUSH PRIVILEGES;" >> $tfile

echo "CREATE DATABASE IF NOT EXISTS $MYSQL_DATABASE CHARACTER SET utf8 COLLATE utf8_general_ci;" >> $tfile

echo "CREATE DATABASE IF NOT EXISTS $MYSQL_DATABASE CHARACTER SET utf8 COLLATE utf8_general_ci;"

echo "CREATE USER 'myuser'@'localhost' IDENTIFIED BY '2E7A80BFD6Cwdct5q4i1r9l3';" >> $tfile

echo "CREATE USER 'myuser'@'localhost' IDENTIFIED BY '2E7A80BFD6Cwdct5q4i1r9l3';"

echo "CREATE USER 'myuser'@'%' IDENTIFIED BY '2E7A80BFD6Cwdct5q4i1r9l3';" >> $tfile

echo "CREATE USER 'myuser'@'%' IDENTIFIED BY '2E7A80BFD6Cwdct5q4i1r9l3';"

echo "GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'localhost' WITH GRANT OPTION;" >> $tfile

echo "GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'localhost' WITH GRANT OPTION;"

echo "GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'%' WITH GRANT OPTION;" >> $tfile

echo "GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'%' WITH GRANT OPTION;"

echo "FLUSH PRIVILEGES;" >> $tfile

fi

/usr/bin/mysqld --user=root --bootstrap --verbose=0 < $tfile

rm -f $tfile

fi

exec /usr/bin/mysqld --user=root --console

mysql -u root myDb < backup.sql # THIS LINE NOT WORKING! WHY ?

最佳答案 容器启动时,您实际上并未执行脚本.我不确定你要用这个来完成什么,我不应该要求澄清,所以我会尽可能地回答并希望这会有所帮助.

尝试类似的东西：

Dockerfile

FROM alpine:latest

WORKDIR /app

COPY startup.sh /startup.sh

COPY backup.sql /app/

RUN apk add --update mysql mysql-client && rm -f /var/cache/apk/*

COPY my.cnf /etc/mysql/my.cnf

EXPOSE 3306

ENTRYPOINT ["/startup.sh"]

CMD /bin/bash -c "/usr/bin/mysqld --user=root --console && mysql -u root myDb < backup.sql"

然后,您将修改您的启动脚本,如下所示：

startup.sh

#!/bin/sh

if [ -d /app/mysql ]; then

echo "[i] MySQL directory already present, skipping creation"

else

echo "[i] MySQL data directory not found, creating initial DBs"

mysql_install_db --user=root > /dev/null

if [ "$MYSQL_ROOT_PASSWORD" = "" ]; then

MYSQL_ROOT_PASSWORD=111111

echo "[i] MySQL root Password: $MYSQL_ROOT_PASSWORD"

fi

MYSQL_DATABASE=myDb

if [ ! -d "/run/mysqld" ]; then

mkdir -p /run/mysqld

fi

tfile=`mktemp`

if [ ! -f "$tfile" ]; then

return 1

fi

cat << EOF > $tfile

EOF

if [ "$MYSQL_DATABASE" != "" ]; then

echo "[i] Creating database: $MYSQL_DATABASE"

echo "FLUSH PRIVILEGES;" >> $tfile

echo "CREATE DATABASE IF NOT EXISTS $MYSQL_DATABASE CHARACTER SET utf8 COLLATE utf8_general_ci;" >> $tfile

echo "CREATE DATABASE IF NOT EXISTS $MYSQL_DATABASE CHARACTER SET utf8 COLLATE utf8_general_ci;"

echo "CREATE USER 'myuser'@'localhost' IDENTIFIED BY '2E7A80BFD6Cwdct5q4i1r9l3';" >> $tfile

echo "CREATE USER 'myuser'@'localhost' IDENTIFIED BY '2E7A80BFD6Cwdct5q4i1r9l3';"

echo "CREATE USER 'myuser'@'%' IDENTIFIED BY '2E7A80BFD6Cwdct5q4i1r9l3';" >> $tfile

echo "CREATE USER 'myuser'@'%' IDENTIFIED BY '2E7A80BFD6Cwdct5q4i1r9l3';"

echo "GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'localhost' WITH GRANT OPTION;" >> $tfile

echo "GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'localhost' WITH GRANT OPTION;"

echo "GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'%' WITH GRANT OPTION;" >> $tfile

echo "GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'%' WITH GRANT OPTION;"

echo "FLUSH PRIVILEGES;" >> $tfile

fi

/usr/bin/mysqld --user=root --bootstrap --verbose=0 < $tfile

rm -f $tfile

fi

exec "$@"

看一下在official mysql Docker image repo中设置Dockerfile和docker-entrypoint.sh的方式.