Start-Process powershell with spaces

Question

I have been at this for a long while now, getting to the point where I'm very frustrated. I'm hoping someone can point me in the right direction.

I need to run mysqldump, for 6 specific databases. I need each spawn to run after the last has finished. It should not run all the commands at the same time. It needs to wait.

I've tried this:

$dump = "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe"
$args = @('-u','databaseUser','-pMySuperAwesomePasswordHere','--single-transaction','--log-error=c:\backups\mysqldump_error.log',"$database > $backupFilePath\$database.sql")
Start-Process $dump $args -Wait

I've tried this:

$cmd = $backupCmd + $database + " > " + "$backupFilePath\$database.sql"
Write-Host $cmd
invoke-expression $cmd | out-null

How do I execute a command, especially one with redirecting the output to a file on the filesystem?

Thank you.

Joey · Accepted Answer · 2014-03-03 11:26:48Z

2

Redirection is a shell feature. Start-Process will dutifully include the last argument with the database name and the > in the actual argument passed to mysqldump which in turn has no idea what to do with the > at all.

You probably want something like

$args = '-u','databaseUser','-pMySuperAwesomePasswordHere','--single-transaction','--log-error=c:\backups\mysqldump_error.log',"$database"
& "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe" @args | Out-File $backupFilePath\$database.sql

Since mysqldump is a console application it will wait anyway until it's done before continuing with the script.

answered Mar 3, 2014 at 11:26

Joey

357k88 gold badges705 silver badges700 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

andyb Over a year ago

A useful walk-through on handling external commands can be found here: edgylogic.com/blog/powershell-and-external-commands-done-right

Joey Over a year ago

@andyb: --% is handy; didn't know that yet.

TechFanDan · Accepted Answer · 2023-06-07 17:34:39Z

0

| Out-File wasn't working for me. I had to use the Parameter -RedirectStandardOutput $PATH_TO_FILE instead. HTH.

edited Jun 7, 2023 at 17:34

answered Jun 7, 2023 at 17:20

TechFanDan

3,53410 gold badges55 silver badges93 bronze badges

Collectives™ on Stack Overflow

Start-Process powershell with spaces

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related