The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Issue in starting Mariadb docker

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.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.