Skip to content

Instantly share code, notes, and snippets.

@kekeimiku

kekeimiku/mysql

Last active January 18, 2024 15:36
Show Gist options
  • Save kekeimiku/e1da488d96727789de88332499a51d57 to your computer and use it in GitHub Desktop.
Save kekeimiku/e1da488d96727789de88332499a51d57 to your computer and use it in GitHub Desktop.
Download ZIP
Dbeaver connect to docker database unable to export and import temporary solutions. mysql/postgres
Raw
mysql
#!/bin/sh
docker exec -i mysql /usr/bin/mysql $@ -p2325373912
Raw
mysqldump
#!/bin/sh
docker exec -i mysql /usr/bin/mysqldump $@ -p2325373912
Raw
pg_dump
#!/bin/sh
docker exec -i postgres /usr/local/bin/pg_dump $@
Raw
pg_restore
#!/bin/sh
docker exec -i postgres /usr/local/bin/pg_restore $@
@acasaism
Copy link

@ssheduardo Assuming your container has the port 3307 exposed to your local machine, use the loopback IP address of your computer to access the container, 127.0.0.1 and port 3307

Same goes to the OP: if you use the host "localhost" the mysql client will use the socket connection to connect to the database for some unknown reason. Use the loopback address whenever you want to connect to the database from outside using the mysql client.

Thanks!!!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment