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. ...
This error happened after I try to run a Django project on Linux(Manjaro) after an sistem update. ImportError: libffi.so.7: cannot open shared object file: No such file or directory What Have I try: Install libffi using pacman pacman -Sy libffi The installation is successful but the error persists. Delete and recreate virtualenv it did not help neither. Solution Install That specific libffi.so.7 I use yay to search for suitable package to install ...
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: ...
Hi, test things