Issue in starting Mariadb docker
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.