xxxxxxxxxx
docker run -d -p 8000:8000 -p 9443:9443 --name portainer --restart=always -v /var/run/docker.sock:/var/run/docker.sock -v portainer_data:/data portainer/portainer-ce:latest
xxxxxxxxxx
docker volume create portainer_data
docker run -d -p 8000:8000 -p 9000:9000 --name=portainer --restart=always -v /var/run/docker.sock:/var/run/docker.sock -v portainer_data:/data portainer/portainer-ce
xxxxxxxxxx
#First, create the volume that Portainer Server will use to store its database:
docker volume create portainer_data;
#Then, download and install the Portainer Server container:
# Get The latest version name form here
#htps://github.com/portainer/portainer/releases/
docker run -d -p 8000:8000 -p 9443:9443 --name portainer --restart=always -v /var/run/docker.sock:/var/run/docker.sock -v portainer_data:/data portainer/portainer-ce:latest
# https://localhost:9443
xxxxxxxxxx
docker volume create portainer_data
docker run -d -p 9000:9000 --name=portainer --restart=always -v /var/run/docker.sock:/var/run/docker.sock -v portainer_data:/data portainer/portainer-ce:latest
xxxxxxxxxx
$docker run -d -p 9000:9000 --name portainer --restart always -v /var/run/docker.sock:/var/run/docker.sock -v/data/portainer/data:/data portainer/portainer
xxxxxxxxxx
declare @SQL nvarchar(MAX) = ''
SELECT @SQL = @SQL + 'truncate table '+ t.TABLE_NAME + ';'
FROM sysindexes i
join INFORMATION_SCHEMA.TABLES t on t.TABLE_NAME = object_name(i.id)
WHERE t.TABLE_TYPE = 'BASE TABLE'
AND t.TABLE_NAME NOT IN ('Test')
GROUP BY t.TABLE_SCHEMA
, t.TABLE_NAME
HAVING MAX(i.rows) > 0
select @SQL
--exec sp_executesql @SQL