15,041
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
m
→Resource and Environmental Errors
m (→Other issues) |
|||
| Line 443: | Line 443: | ||
$ sudo chmod 774 /Applications/XAMPP/xamppfiles/var/mysql/XXXMacBook-Pro.local.err | $ sudo chmod 774 /Applications/XAMPP/xamppfiles/var/mysql/XXXMacBook-Pro.local.err | ||
</pre> | </pre> | ||
=== Could not open single-table tablespace file filename.ibd === | |||
Version: XAMPP 5.6.15-1 on {{Mac}} | |||
Condition: The Mac was shutdown accidentally and the database was not shutdown normally. After reboot the Mac, unable to start the MySQL service<ref>[http://stackoverflow.com/questions/35184367/error-could-not-open-single-table-tablespace-file-scrapers-records-ibd mysql - Error: could not open single-table tablespace file .\scrapers\records.ibd - Stack Overflow]</ref><ref>[http://chepri.com/our-blog/mysql-innodb-corruption-and-recovery/ MySQL Won't Start - InnoDB Corruption and Recovery. - Chepri]</ref>. | |||
Possible solution: | |||
# Edit the MySQL configuration file located: /Applications/XAMPP/xamppfiles/etc/my.cnf | |||
# Add this line: {{kbd | key=<nowiki>innodb_force_recovery = 1</nowiki>}} | |||
# Try to start the MySQL service | |||
# If the MySQL service started successfully, edit the MySQL configuration file and mark this line : {{kbd | key=<nowiki>#innodb_force_recovery = 1</nowiki>}} | |||
# Restart the MySQL service | |||
== References == | == References == | ||