skip to Main Content

Exporting MySQL Data to CSV for Local Transfer

Sql-terminal

If you're a developer working with MySQL databases, you might need to export data from your database and transfer it to your local system. In this tutorial, we'll show you how to export data from a MySQL database to a CSV file and transfer it to your local system using SSH. Step 1: Login to the Server First, you need to login to the server where your MySQL database is located. Open your terminal and use the following command to…

Read more

Securing Docker Containers: Lessons Learned from a Data Loss Incident

Docker Security

Introduction We had set up MongoDB as a Docker container for a project and hosted it on our infrastructure server. We chose to use a Docker container for ease of deployment and management. However, one morning, we discovered that the MongoDB data was gone, prompting us to investigate the cause. Investigation Upon further investigation, we found that the ports exposed from the Docker container to the host were accessible from the world, even when the server was secured with UFW…

Read more
Search