Overview

I used to manually back up this blog's database like a caveman, so I decided to create a tool in Go that allows me to back up the database from a remote server to my local machine with a single command.

Packages

• "net"
  • Provides interfaces for network I/O, including TCP/IP, UDP, domain name resolution, and Unix domain sockets.
• "time"
  • Provides functionality for time calculations and formatting.
• "io/ioutil"
  • Offers utility functions for file I/O operations.
• "golang.org/x/crypto/ssh"
  • Provides SSH client and server implementations.
• "github.com/BurntSushi/toml"
  • A TOML parser.
  • Designed to work like Go's standard library parsers for JSON and XML.
  • Created by Burnt Sushi.

Implementation

I implemented a rough working version of the tool. Since I'm not very experienced with Go, the implementation might seem a bit naive... Also, I haven't written any tests yet.

GitHub

I've uploaded the code here:

• GitHub - bmf-san/go-mysqldump

Thoughts

For now, I'll keep exploring various Go implementations and building up my knowledge...

References

• GoDoc - package mysql
• GoDoc - package ssh
• Golang.org - Package net
• Golang.org - Package time
• Golang.org - Package ioutil
• golang.jp - net package
• Using authentication keys for SSH connections in Go
• github.com - siddontang/go-mysql
• Mysqldump Through a HTTP Request with Golang