Building Container


buildDocker.sh
CONTAINER=mysql
IMAGE=mysql:5.5.59

docker stop $CONTAINER
docker rm $CONTAINER
#docker rmi $IMAGE

docker run -d \
--restart=always \
-p 3306:3306 \
--name $CONTAINER \
-v /share/Volume/CONTAINERS/mysql/conf:/etc/mysql \
-v /share/Volume/CONTAINERS/mysql/data:/var/lib/mysql \
-e MYSQL_DATABASE=mydb \
-e MYSQL_ROOT_PASSWORD=xxx \
$IMAGE

docker logs -f $CONTAINER



Optimize Database

> mysqlcheck -o <database>


> mysqlcheck -o mydb

mydb.authorized                              Table is already up to date
mydb.authrequest                             Table is already up to date
mydb.dbinfo                                  Table is already up to date
mydb.dbvar                                   OK
mydb.event                                   OK


  • No labels