Docker MySQL Import Guide

—

### **1. Ensure MySQL is Running in Docker**
Make sure your MySQL container is up and running:

docker ps

Find your MySQL container name or ID. If it's not running, start it:

docker start <container_name>

—

### **2. Place the SQL File**
Ensure your `.sql` file is accessible to the container. You can place it in a folder and share it with the container or use absolute paths.

—

### **3. Run the Import Command**
Use the `docker exec` command to import the database:

docker exec -i <container_name> mysql -u<username> -p<password> <database_name> < /path/to/your/file.sql

#### Example:

docker exec -i my-mysql-container mysql -uroot -psecret my_database < /path/to/dump.sql

—

### **4. Alternate Method Using `docker cp`**
You can also copy the `.sql` file into the container and import it inside the container.

#### Copy File:

docker cp /path/to/dump.sql <container_name>:/dump.sql

#### Import Inside Container:

docker exec -it <container_name> bash
mysql -u<username> -p<password> <database_name> < /dump.sql
exit

—

### **5. Using `docker-compose`**
If you are using `docker-compose`, you can automate the import by adding a volume and an initialization script.

#### Example:
Add your `.sql` file to a folder (e.g., `./docker-entrypoint-initdb.d/`) and update your `docker-compose.yml`:

services:
  mysql:
    image: mysql:8
    environment:
      MYSQL_ROOT_PASSWORD: secret
      MYSQL_DATABASE: my_database
    volumes:
      - ./docker-entrypoint-initdb.d/:/docker-entrypoint-initdb.d/

MySQL will automatically run scripts in `/docker-entrypoint-initdb.d/` on container startup.

—

Let me know if you need assistance with your specific Docker and MySQL setup!

—

### **1. Copy the SQL File into the MySQL Container**
Use the `docker cp` command to copy the `.sql` file into a directory inside the MySQL container.

docker cp /path/to/your-dump.sql <container_name>:/path/in/container/

#### Example:

docker cp dump.sql my-mysql-container:/var/lib/mysql/

—

### **2. Access the MySQL Container**
Use `docker exec` to open a shell session inside the container.

docker exec -it <container_name> bash

#### Example:

docker exec -it my-mysql-container bash

—

### **3. Import the SQL File**
Inside the container, use the `mysql` command to import the SQL file into the desired database.

mysql -u<username> -p<password> <database_name> < /path/in/container/dump.sql

#### Example:

mysql -uroot -psecret my_database < /var/lib/mysql/dump.sql

—

### **4. Verify the Import**
Exit the container and verify that the database import was successful.

docker exec -it <container_name> mysql -u<username> -p<password> -e "SHOW TABLES;" <database_name>

#### Example:

docker exec -it my-mysql-container mysql -uroot -psecret -e "SHOW TABLES;" my_database

—

### Notes:
– Replace “, “, “, “, and file paths with actual values.
– Ensure your MySQL user has the necessary permissions for the database you are importing.

Let me know if you encounter any issues!