Skip to content

Instantly share code, notes, and snippets.

@kraevit

kraevit/repair-mysql-data.ps1

Forked from josemmo/repair-mysql-data.ps1
Created December 25, 2021 09:26
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kraevit/6d5ab17a134884d2324e2265b92aa862 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kraevit/6d5ab17a134884d2324e2265b92aa862 to your computer and use it in GitHub Desktop.
Download ZIP
Repair MySQL data directory (for XAMPP)
Raw
repair-mysql-data.ps1
# Based on this answer: https://stackoverflow.com/a/61859561/1956278
# Backup old data
Rename-Item -Path "./data" -NewName "./data_old"
# Create new data directory
Copy-Item -Path "./backup" -Destination "./data" -Recurse
Remove-Item "./data/test" -Recurse
$dbPaths = Get-ChildItem -Path "./data_old" -Exclude ('mysql', 'performance_schema', 'phpmyadmin') -Recurse -Directory
Copy-Item -Path $dbPaths.FullName -Destination "./data" -Recurse
Copy-Item -Path "./data_old/ibdata1" -Destination "./data/ibdata1"
# Notify user
Write-Host "Finished repairing MySQL data"
Write-Host "Previous data is located at ./data_old"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment