Make sure you backup the mentioned folders before taking any action!
This worked for me,
- Quit the XAMPP
- Cut all files in C:\xampp\mysql\backup
- Paste and replace files into C:\xampp\mysql\data
- Run the XAMPP as administrator
More Related Contents:
- how to delete data from table A besides the customer service and director data in table B?
- How to solve “Error: MySQL shutdown unexpectedly”?
- xampp MySQL does not start
- MySQL error 1064 syntax but everything seems fine
- How can I access the MySQL command line with XAMPP for Windows?
- What is the location of mysql client “.my.cnf” in XAMPP for Windows?
- How can I change MariaDB to MySQL in XAMPP?
- Where to change the value of lower_case_table_names=2 in XAMPP on Windows?
- MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
- How repair corrupt xampp ‘mysql.user’ table?
- How to turn on/off MySQL strict mode in localhost (xampp)?
- How to get back Lost phpMyAdmin Password, XAMPP
- SQL select only rows with max value on a column [duplicate]
- What is the error “Every derived table must have its own alias” in MySQL?
- Generating Depth based tree from Hierarchical Data in MySQL (no CTEs)
- Authentication plugin ‘caching_sha2_password’ cannot be loaded
- How to grant remote access permissions to mysql server for user?
- Generating a series of dates [duplicate]
- MySQL comparison with null value
- Unique constraint that allows empty values in MySQL
- Matching all values in IN clause
- Having both a Created and Last Updated timestamp columns in MySQL 4.0
- Which is faster — INSTR or LIKE?
- Remove duplicate rows leaving oldest row Only?
- Show constraints on tables command
- Remove special characters from a database field
- Set user variable from result of query
- Mysql command not found in OS X 10.7
- The best way to remove value from SET field?
- Optimistic locking in MySQL