If you’ve ever tried importing a large .sql file using GUI tools like DBeaver, SQLyog, or HeidiSQL, chances are you’ve seen them freeze, timeout, or crash when the file is too big. I’ve personally experienced this multiple times — especially when working with SQL files larger than 1GB. But here’s the tool that just works, even for a 10GB+ SQL script: the source command in the MySQL (or MariaDB) CLI. ...
Overview This is how I setup MySQL in docker for development so I can just copy and paste this. create volume create volume for saving data, by creating volume, it will make sure that tis volume is readable for our project. else it will use the parent directory name where the docker-compose.yml is located. If you use volume from inside MySQL container, the data will be lost when the container stops. ...
Previously I setup docker compose for golang application and PostgreSQL. It can run the application and can connect to PostgreSQL. While doing basic CRUD, I found that I need a tool to migrate my database structure and seed the database for easy onboarding and development. Thus I want to use golang-migrate to do that. What Is Golang Migrate Contrary to the name, it is not a migration tool specifically created for golang development, although we can use it as a golang package in your application. This tool is a CLI tool that can be installed on Windows, Mac, and Linux. As a CLI tool, it means that no matter what language you use to code, your migration can be managed using this golang-migrate. ...
Create Docker containers for Laravel, MySQL, and PhpMyAdmin without fiddling with Dockerfile and docker-compose.yml. ...
Overview I want to connect to remote MySQL server using DBeaver on linux. Note I need to connect jump server before I could open a connection to the database server. On Windows I could do that using Putty tunneling by SSH to first server, then from that server, I SSH second time to the DB server and tunnel the connection to a port. Using this recipe does not work on linux in my case. it will show error: ...