如何使用Golang导入/加载/运行mysql文件？

Question

I’m trying to run/load sql file into mysql database using this golang statement but this is not working:

exec.Command("mysql", "-u", "{username}", "-p{db password}", "{db name}", "<", file abs path )

But when i use following command in windows command prompt it’s working perfect.

mysql -u {username} -p{db password} {db name} < {file abs path}

So what is the problem?

Answer 1

Go's exec.Command runs the first argument as a program with the rest of the arguments as parameters. The '<' is interpreted as a literal argument.

e.g. exec.Command("cat", "<", "abc") is the following command in bash: cat \< abc.

To do what you want you have got two options.

• Run (ba)sh and the command as argument: exec.Command("bash", "-c", "mysql ... < full/path")
• Pipe the content of the file in manually. See https://stackoverflow.com/a/36383984/8751302 for details.

The problem with the bash version is that is not portable between different operating systems. It won't work on Windows.