Skip to main content

Restoring MySQL on XAMMP

 Follow these steps and save your time and databases:-

  1. Go to your XAMMP installation, it’s mostly in C drive.
  2. Now inside mysql folder rename the folder data to data-old (or any other name you like)
  3. Create a new folder data under mysql folder
  4. Copy the contents of backup folder to the new data folder
  5. Now copy all your database folders that are in data-old folder to the new data folder (skip the mysql, performance_scheme and phpmyadmin folder)
  6. And the last, copy the ibdata1 file from data-old folder and replace it inside new data folder
  7. Restart your MYSQL server from XAMPP control panel.

And done!

Comments

Post a Comment

Popular posts from this blog

File upload in php

Simple way to upload file using php.     //HTML code <input type="file" required="" name="avatarUrl"/>   //On action page code where form is being submitted. if($_FILES['avatarUrl']['name']!='') {                        $fileTmpPath = $_FILES['avatarUrl']['tmp_name'];           $fileName = $_FILES['avatarUrl']['name'];           $fileSize = $_FILES['avatarUrl']['size'];           $fileType = $_FILES['avatarUrl']['type'];           $fileNameCmps = explode(".", $fileName);           $fileExtension = strtolower(end($fileNameCmps));              $dateMin = date('Ymdhms');           $rand = $dateMin;    ...
Post a Comment
Read more