PowerShell MySQL Dump Script does not dump correctly

Question

$d= Get-Date
$dString = $d.Year.ToString() + "-" + $d.Month.ToString() + "-" + $d.Day.ToString() + "_" + $d.Hour.ToString() + "-" + $d.Minute.ToString() + "-" + $d.Minute.ToString()
$backupFilePath = "C:\wamp\backupFileName_" + $dString + ".sql"
$cmd = "& 'C:\wamp\bin\mysql\mysql5.6.12\bin\mysqldump.exe' -u ipbform -p123123 wiki > " + $backupFilePath
Write-Host $cmd
invoke-expression $cmd | out-null

When I look at the MySQL dump file I get this:

ÿþ-(bunch of random symbols like its a compiled file)

Ansgar Wiechers · Accepted Answer · 2013-07-26 13:22:51Z

3

ÿþ is the Byte Order Mark of a file encoded in little-endian Unicode format. Try this:

$cmd = "& 'C:\wamp\bin\mysql\mysql5.6.12\bin\mysqldump.exe' -u ipbform -p123123 wiki"
Write-Host $cmd
Invoke-Expression $cmd | Out-File $backupFilePath -Encoding ASCII

answered Jul 26, 2013 at 13:22

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

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

Collectives™ on Stack Overflow

PowerShell MySQL Dump Script does not dump correctly

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related