Quick way to change the schema name in all mysql dump files in a directory using Powershell. Or you could just use it to change a string in files of particular type in a directory
|
1 2 |
C:\Users\SloshDev> foreach($f in gci("*.sql")){ (Get-Content $f.fullname) | %{ $_ -replace "magento_1_9","magento_1_12" } | Set-Content $f.fullname } |
Here’s how I changed the default character set from latin1 to utf8. May not want to use if different columns use different character sets.
|
1 2 3 |
C:\Users\SloshDev> foreach($f in gci("*.sql")){ (Get-Content $f.fullname) | %{ $_ -replace "latin1","utf8" } | Set-Content $f.fullname } |