Hi,

I had installed MariaDB using docker (attached volumes for dbroots and MySQL) on an Ubuntu server. I then took a backup of my dbroots and MySQL directory.

I have now moved these backups on another Ubuntu server and tried to spin a new MariaDB docker attaching my dbroots and MySQL as a volume.

Please find the command which I used for the same:

pathVar="/mnt/backup"
mkdir -p $pathVar/database/mysql/db
mkdir -p $pathVar/database/mariadb/data
mkdir -p $pathVar/database/mariadb/data1
chmod -R 777 $pathVar
docker rm --force mariadb
docker run -d --restart=always -p 3306:3306 --name mariadb -v $pathVar/database/mysql/db:/usr/local/mariadb/columnstore/mysql/db -v $pathVar/database/mariadb/data:/usr/local/mariadb/columnstore/data -v $pathVar/database/mariadb/data1:/usr/local/mariadb/columnstore/data1 mariadb:10.3.28

After this, when I tried logging in to my MariaDB, I and getting the following error message.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mariadb/columnstore/mysql/lib/mysql/mysql.sock' (2)

I checked the issue, it's not able to create mysql.sock.

Can you pls help me to resolve this?

Thank you so much.