13,468
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
could not open single-table tablespace file filename.ibd
No edit summary |
(could not open single-table tablespace file filename.ibd) |
||
| Line 98: | Line 98: | ||
#* new command {{kbd | key=<nowiki>/Applications/XAMPP/xamppfiles/bin/mysqldump -h 127.0.0.1 -u root -p --force --single-transaction DATABASE_NAME | pv | gzip -c > DATABASE_NAME.sql.gz</nowiki>}} | #* new command {{kbd | key=<nowiki>/Applications/XAMPP/xamppfiles/bin/mysqldump -h 127.0.0.1 -u root -p --force --single-transaction DATABASE_NAME | pv | gzip -c > DATABASE_NAME.sql.gz</nowiki>}} | ||
==== could not access the mysql log | ==== could not access the mysql log ==== | ||
Version: XAMPP 5.6.15-1 on {{Mac}} | |||
Cause: | |||
* the error log only be accessed by the mysql user | * the error log only be accessed by the mysql user | ||
Solution <ref>[http://computerplumber.com/2009/01/using-the-chmod-command-effectively/ Using the CHMOD command effectively @ Computer Plumber]</ref>: | |||
<pre> | <pre> | ||
find the path to the mysql log | find the path to the mysql log | ||
| Line 114: | Line 114: | ||
$ 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>. | |||
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 | |||
==== ERROR 1005 (HY000) at line xx: Can't create table 'TABLE_NAME' (errno: 28) ==== | ==== ERROR 1005 (HY000) at line xx: Can't create table 'TABLE_NAME' (errno: 28) ==== | ||