- MSSQL on docker 部署方式:
微软官方文档
在Docker上安装MSSQL(SQL Server) - 命令记录
docker pull microsoft/mssql-server-linux
docker run --name MSSQL_1433 -m 512m -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=yourStrong(!)Password' -p 1433:1433 -d microsoft/mssql-server-linux
#docker run --name MSSQL_1433 -m 512m -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=yourStrong(!)Password' --net=host -d microsoft/mssql-server-linux
docker exec -it MSSQL_1433 /bin/bash
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P 'yourStrong(!)Password'
- docker容器的扩容
sudo docker -d --storage-opt dm.basesize=100G
- docker内启动jupyter
nohup jupyter notebook >/dev/null 2>&1 &
docker run -it -p 8888:8888 --ipc=host ufoym/deepo:all-py36-jupyter-cpu
nohup jupyter notebook --no-browser --ip=0.0.0.0 --allow-root --NotebookApp.token= --notebook-dir='/root' >/dev/null 2>&1 &
- docker复制文件的方法
docker 从容器复制文件到host 和 从宿主机复制到容器内
首先,要用docker inspect方法获得容器的完整ID
docker inspect -f '{{.Id}}' master
这里的master可以是container name也可以是短的container ID。
然后,使用通道拷贝数据
cp /usr/java/jdk-7u75-linux-x64.rpm /var/lib/docker/aufs/mnt/"id"/root/
- 启动MSSQL
sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd -S localhost \
-U SA -P '<YourNewStrong!Passw0rd>' \
-Q 'RESTORE FILELISTONLY FROM DISK = "/var/opt/mssql/backup/wwi.bak"' \
| tr -s ' ' | cut -d ' ' -f 1-2
LogicalName PhysicalName
------------------------------------------
WWI_Primary D:\Data\WideWorldImporters.mdf
WWI_UserData D:\Data\WideWorldImporters_UserData.ndf
WWI_Log E:\Log\WideWorldImporters.ldf
WWI_InMemory_Data_1 D:\Data\WideWorldImporters_InMemory_Data_1
调用RESTORE DATABASE命令在容器内的将数据库还原。 为每个文件上, 一步中指定新路径。
sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \
-S localhost -U SA -P '<YourNewStrong!Passw0rd>' \
-Q 'RESTORE DATABASE WideWorldImporters FROM DISK = "/var/opt/mssql/backup/wwi.bak" WITH MOVE "WWI_Primary" TO "/var/opt/mssql/data/WideWorldImporters.mdf", MOVE "WWI_UserData" TO "/var/opt/mssql/data/WideWorldImporters_userdata.ndf", MOVE "WWI_Log" TO "/var/opt/mssql/data/WideWorldImporters.ldf", MOVE "WWI_InMemory_Data_1" TO "/var/opt/mssql/data/WideWorldImporters_InMemory_Data_1"'