/repair-xampp-mysql

Primary LanguagePowerShell

repair-xampp-mysql

Before running this make sure mysql is not running

In order to execute PS scripts you might have to this in a administrator terminal/powershell first:

Set-ExecutionPolicy RemoteSigned

Automatic repair a faulty mysql xampp database. This PS script automates the following steps:

  • rename C:\xampp\mysql\data to a new folder with the current date appended
  • copy the C:\xamp\mysql\backup folder to data
  • copy the user defined innoDB folder from the old data folder to the new one
  • copy existing ibdata1 and ib_logfile[0|1] from the old data folder to the new one

No garantues but the old data folder is still available. It should fix most of the problems.