docker-db-backup/dump_mysql.go

68 lines
1.2 KiB
Go
Raw Permalink Normal View History

2021-08-18 18:25:59 +00:00
package main
2021-08-18 19:29:32 +00:00
import (
"github.com/docker/docker/api/types"
"github.com/docker/docker/client"
2021-12-05 12:44:36 +00:00
"log"
2021-08-18 19:29:32 +00:00
)
2021-08-18 18:25:59 +00:00
type MysqlDumper struct {
Container *types.ContainerJSON
}
func NewMysqlDumper(container *types.ContainerJSON) *MysqlDumper {
return &MysqlDumper{
Container: container,
}
}
2021-08-18 20:34:28 +00:00
func (m *MysqlDumper) buildDumpArgs() []string {
2021-08-18 19:29:32 +00:00
env := parseEnv(m.Container.Config.Env)
user := "root"
if u, has := env["MYSQL_USER"]; has {
user = u
}
db := "--all-databases"
if d, has := env["MYSQL_DATABASE"]; has {
db = d
}
pw := env["MYSQL_ROOT_PASSWORD"]
if p, has := env["MYSQL_PASSWORD"]; has {
pw = p
}
port := "3306"
if p, has := env["MYSQL_PORT"]; has {
port = p
}
host := m.Container.NetworkSettings.DefaultNetworkSettings.IPAddress
2023-07-03 20:46:38 +00:00
args := []string{
"--lock-tables=0",
"--dump-date",
"--single-transaction",
"--routines",
"--triggers",
"--events",
"-u", user,
}
2021-08-18 20:34:28 +00:00
if pw != "" {
args = append(args, "-p"+pw)
}
return append(args, "--port", port, "-h", host, db)
}
func (m *MysqlDumper) Dump(c *client.Client) error {
2021-12-05 12:44:36 +00:00
log.Printf("Dumping mysql database from container %s...\n", m.Container.Name)
2021-08-18 20:34:28 +00:00
args := m.buildDumpArgs()
2024-02-13 15:45:10 +00:00
return runAndSaveCommandInContainer(c, m.Container, "mysqldump", args...)
2021-08-18 18:25:59 +00:00
}