powershell与MySQL交互_使用Powershell针对MySQL运行SQL脚本

我有一个Powershell脚本,每晚使用mysqldump备份MySQL数据库.一切正常,但我想扩展脚本以从产品数据库(db2)的备份中更新报告数据库(db1).我已经编写了以下测试脚本,但是它不起作用.我觉得问题是将SQL文件读取到CommandText,但我不确定如何调试.

[system.reflection.assembly]::LoadWithPartialName("MySql.Data")

$mysql_server = "localhost"

$mysql_user = "root"

$mysql_password = "password"

write-host "Create coonection to db1"

# Connect to MySQL database 'db1'

$cn = New-Object -TypeName MySql.Data.MySqlClient.MySqlConnection

$cn.ConnectionString = "SERVER=$mysql_server;DATABASE=db1;UID=$mysql_user;PWD=$mysql_password"

$cn.Open()

write-host "Running backup script against db1"

# Run Update Script MySQL

$cm = New-Object -TypeName MySql.Data.MySqlClient.MySqlCommand

$sql = Get-Content C:\db2.sql

$cm.Connection = $cn

$cm.