Skip to main content

MySQL ;)

Gerar e restaurar backup

Método 1

Backup

docker exec some-mysql sh -c 'exec mysqldump --all-databases -u<user> -p<password> <database>' > /some/path/on/your/host/all-databases.sql

Restore

docker exec -i some-mysql sh -c 'exec mysql -u<user> -p<password> <database>' < /some/path/on/your/host/all-databases.sql

Método 2

Backup

docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

Restore

cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

Acesso via tunel ssh

Cria uma tunel ssh na porta local 3307

$ ssh -i ~/.ssh/id_rsa_site root@n4w3b.com.br -N -L 3307:127.0.0.1:932
$ telnet 127.0.0.1 3307
$ mysql -h127.0.0.1 -P3307 -uroot -p

Trocar senha e acesso externo

mysql v5.5

$ mysql -uroot -p
mysql> SELECT user, host, password FROM mysql.user;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root';
mysql> FLUSH PRIVILEGES;
mysql> SELECT user, host, password FROM mysql.user;