Skip to content
Search

DBeaver

lastmod 2025-05-21created 2021-01-1911 edits

DBeaver is an SQL client and database administration tool. For relational databases, it communicates with the database through a JDBC driver using the JDBC API. For other databases (NoSQL), it uses proprietary database drivers. It provides an editor that supports autocompletion and syntax highlighting. By providing a plugin architecture based on the Eclipse plugin structure, it allows much of the application's behavior to be modified to provide database-specific or database-independent features. It is a desktop application written in Java and based on the Eclipse platform.

DBeaver is free and open-source software distributed under the Apache License.

How to install

ArchLinux: 

sudo pacman -S dbeaver

Backing up a database

First, a local client must be installed. (Note: installing DBeaver includes mysqldump. If it is missing, proceed as below... or it may be a snap permission issue)

For mysql: 

sudo apt install mysql-client

For MariaDB: 

sudo apt install -y mariadb-client

Then check with the which command 

which mysqldump

and proceed as follows.

  1. In DBeaver, right-click the table you want to back up to open the context menu
  2. Click Tools > Dump database
  3. On the "MySQL Dump" screen, click the "Local Client ..." button
  4. Click "Browse ..." in the combo box
  5. Click the "Add Home" button
  6. Enter the directory of the mysqldump location you checked earlier

If you installed it with snap, permission issues may occur. Connect the permissions or reinstall with --classic.

Restoring from an identical database

If you have a "source Table" and a "target Table" with exactly the same table structure,

in the "target Table", go to 

마우스 오른쪽 버튼 > 컨텍스트 메뉴 > Import Data

and select the Table.

Even the uid is copied exactly.

Troubleshooting

When a Timeout occurs

In Connection settings, you can adjust the Timeout value under "Driver properties".

Permission denied

When you start a dump, the following error may occur: 

2025-05-21 11:14:27.396 - IO error: Cannot run program "/run/user/1000/doc/2891bed9/bin/mysqldump" (in directory "/run/user/1000/doc/2891bed9/bin"): error=13, Permission denied
2025-05-21 11:14:27.397 - java.io.IOException: Cannot run program "/run/user/1000/doc/2891bed9/bin/mysqldump" (in directory "/run/user/1000/doc/2891bed9/bin"): error=13, Permission denied
    at java.base/java.lang.ProcessBuilder.start(Unknown Source)
    at java.base/java.lang.ProcessBuilder.start(Unknown Source)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:227)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:285)
    at org.jkiss.dbeaver.ext.mysql.tasks.MySQLNativeToolHandler.doExecute(MySQLNativeToolHandler.java:47)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:88)
    at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:124)
Caused by: java.io.IOException: error=13, Permission denied
    at java.base/java.lang.ProcessImpl.forkAndExec(Native Method)
    at java.base/java.lang.ProcessImpl.<init>(Unknown Source)
    at java.base/java.lang.ProcessImpl.start(Unknown Source)
    ... 8 more

A path like /run/user/1000/doc/... may indicate a permission restriction caused by snap running in sandbox mode. See snap for details.

In this case, connect the permissions or reinstall with --classic.

See also

Favorite site

author Zer0 sitemap