MySql 8.0 Restore

[Stefano Landa]

I need create a script on powershell, twice on a day, restore production schema dump on test schema. I would like to take last dump created for restore operation

I've writed this
`$DumpPath ="C:\XXX\XXX"
$FileExt = "*.sql"

Get-ChildItem $DumpPath""$FileExt | Where-Object {$_.LastWriteTime} | Select-Object -Last 1 | mysql --batch --login-path=remote --defaults-extra-file="C:\XXX\XXX\AppData\Roaming\MySQL.mylogin.cnf" testschema`

It's correct or i'm completely full of?

Thanks