Recover MySQL Database from raw data files [XAMPP | MySQL | InnoDB]
Okay, So my PC was starting to run a bit sluggish so I reset windows, keeping my files. Because my brain wasn't turned on I forgot to make a backup of my MySQL DB beforehand. I still have all of the raw files, so I still actually have the database but so far have found no way to get it back into the new XAMPP/MySQL installation.
This is what is in my (OLD) ../xampp/mysql/ folder:
If any of you awesome people could help me get the raw files back into the MySQL DB, I would be beyond appreciative.
Try to rename the data folder in the new xampp/mysql to something else like data1 or data_backup, and copy the data folder from the old xampp/mysql to the new one to replace the one you renamed above.
NOTE: Please refer to Michael Longhurst's, the OP's comment above in case you had a password on the previous installation.
- How do I set the default schema for a user in MySQL?
- How to output geoJSON file from mysql spatial table?
- PHPMyAdmin Configuration not working because of MySQL user password?
- The best way of storing many to many hierarchical data in sql
- JDBC connection without database definition
- Can Magento Connect to Another MySQL database?
- PHP isset() with multiple parameters
- bootstrap table doesnot display data
- CakePHP-2.0: Refactor my code editing faster sql query, need a faster sql query
- ERROR 2006 (HY000): MySQL server has gone away
- Problems selecting multiple column
- Order rows based on another table?
- MySQL Workbench edit data
- brew start and brew restart wont start service
- Sort MySQL query result by calculated average DESC
- PHP MYSQL Array and sort
- Use queryset result as a parameter to a raw SQL in Django
- Getting multiple values for a date for Google Charts
- is there any way to check with cumulative way to get month based on the amount fields
- How to compare using bcrypt in a db query using node.js and express
- SQL query to check if a name begins and ends with a vowel
- MySQL JSON_OBJECT() datetime format
- Why is MySQL Sorting by mp.id in This Query Execution Plan?
- PHPExcel download not working properly
- MySqlCommand().ExecuteReader().GetString() does not work
- how to sum rows together but also leave the original rows in the results?
- Postgres vs MySQL index locking: Should I expect MySQL to be more tolerant to parallel write-heavy applications?
- Java - Having a huge ArrayList (1 million +), how to create a String of it in a acceptable amount of time?
- SQL filter for same values in different columns
- ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it