14,982
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
m
→Troubleshooting of MySQL
(ERROR 1114 (HY000): The table `TABLE_NAME` is full) |
|||
| Line 154: | Line 154: | ||
* More on [http://stackoverflow.com/questions/18719748/error-1006-hy000-cant-create-database-errno-13-mysql-5-6-12 ERROR 1006 (HY000) Can't create database (errno: 13) MySQL 5.6.12 - Stack Overflow]. | * More on [http://stackoverflow.com/questions/18719748/error-1006-hy000-cant-create-database-errno-13-mysql-5-6-12 ERROR 1006 (HY000) Can't create database (errno: 13) MySQL 5.6.12 - Stack Overflow]. | ||
==== | ==== ERROR 1017 - Can't find file: '.\DATABASE\TABLE.frm' (errno: 22 - Invalid argument) ==== | ||
Message: [Err] 1017 - Can't find file: '.\DATABASE\TABLE.frm' (errno: 22 - Invalid argument) | |||
Solutions | Solutions | ||
* Check the existence of file DATABASE\TABLE.frm. If not, you may need to create the TABLE before executed the MySQL query. | * Check the existence of file DATABASE\TABLE.frm. If not, you may need to create the TABLE before executed the MySQL query. | ||
| Line 166: | Line 169: | ||
* You may need to delete the existing account setting and re-config again. | * You may need to delete the existing account setting and re-config again. | ||
==== | ==== ERROR 1054 - Unknown column in 'where clause' ==== | ||
Message: [Err] 1054 - Unknown column 'xxx' in 'where clause' | Message: [Err] 1054 - Unknown column 'xxx' in 'where clause' | ||
| Line 260: | Line 263: | ||
* [https://support.rackspace.com/how-to/mysql-connect-to-your-database-remotely/ Connect to a MySQL database remotely] | * [https://support.rackspace.com/how-to/mysql-connect-to-your-database-remotely/ Connect to a MySQL database remotely] | ||
==== Error Code: 2013. Lost connection to MySQL server during query | ==== ERROR 2013: Lost connection to MySQL server during query ==== | ||
Message: Error Code: 2013. Lost connection to MySQL server during query | |||
Condition: After executed the following query contains number of rows which exceed 1,000,000 rows, I met the error message 'Error Code: 2013. Lost connection to MySQL server during query'. | Condition: After executed the following query contains number of rows which exceed 1,000,000 rows, I met the error message 'Error Code: 2013. Lost connection to MySQL server during query'. | ||
<pre> | <pre> | ||