[ERROR] --initialize specified but the data directory has files in it. Aborting.

Read-only archive. These discussions are from Tracston's earlier technical forum and are kept online because the answers are still useful. New replies are closed. Need help with something like this? Talk to us.

Question 23 Mar 2023

Problem

User trying to deploy pod of mysql in kubernetes and get the following error when running the command “kubectl logs mysql-pod”

Solution

The directory of the mysql data i.e. /var/lib/mysql. has data or some other directories in it and the pod cannot start you need either to remove persistent volume and image from the kubernetes or mount the data directory in another dir for example

containers:

- name: mysql

image: “{{ .Values.mysql.image.registry }}/{{ .Values.mysql.image.repository }}:{{ .Values.mysql.version }}”

args:

- “–ignore-db-dir=lost+found”

imagePullPolicy: Always

env:

- name: MYSQL_ROOT_PASSWORD

value: root

- name: MYSQL_DATABASE

value: production

ports:

- containerPort: 3306

name: mysql

volumeMounts:

- name: mysql-{{ .Release.Namespace }}

mountPath: /var/lib/mysqld

and remove the helm chart and reinstall

helm delete mysql-services -n database-services

helm upgrade –install mysql-services -n databases-services -f dte.yaml . –create-namespace –set mysql.db_file=all.databases.sql.gz

Need this fixed properly?

We do this for a living.

Kubernetes, DevOps and platform engineering, delivered in days — not another weekend lost to a stack trace.

Start a project →