使用GOLang操作mysql, 去执行mysqldump命令;
package main
import (
"fmt"
"os"
"os/exec"
)
func main() {
// Set up the command to execute
cmd := exec.Command("mysqldump", "-u", "username", "-p", "password", "database_name")
// Create a file to write the output to
file, err := os.Create("dump.sql")
if err != nil {
panic(err)
}
defer file.Close()
// Redirect the output of the command to the file
cmd.Stdout = file
// Execute the command
err = cmd.Run()
if err != nil {
panic(err)
}
fmt.Println("mysqldump operation completed successfully")
}
注意:
1, 需要替换其中的用户名,密码,库名等信息;
2, 也可以根据需要添加更多的参数,如host, port, --sing-transaction, -q等相关信息;
3, 执行之后,会在当前目录下生成dump.sql文件,即dump的sql文件;