Import 10GB SQL script successfully using source command

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. ...

2025-05-03

Dbeaver Jump Server Tunneling Problem On Linux

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: ...

2020-02-26