Troubleshooting of MySQL errors - Revision history

Planetoid: /* ERROR 1006 (HY000): Can't create database 'DATABASE_NAME' (errno: 28) */

2026-04-14T09:47:16Z

ERROR 1006 (HY000): Can't create database 'DATABASE_NAME' (errno: 28)

← Older revision		Revision as of 17:47, 14 April 2026
Line 67:		Line 67:
	* Check if the disk space where mysql data folder located is enough. e.g. Input {{kbd \| key=df -h}} on {{Linux}}		* Check if the disk space where mysql data folder located is enough. e.g. Input {{kbd \| key=df -h}} on {{Linux}}
	* 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 1010: Error dropping database (can't rmdir) ===
			Message: <pre>Error dropping database (can't rmdir '.\<db_name>\', errno: 17)</pre>

			Solution
			* Manually delete the leftover non-MySQL files (e.g. .sql files) inside the database directory, then retry DROP DATABASE — or simply delete the entire folder manually.

			Root Cause
			* MySQL's DROP DATABASE only removes files it manages. Foreign files left in the data directory (such as .sql dumps) prevent rmdir from removing the folder, causing errno 17 (ENOTEMPTY).

	=== ERROR 1017 - Can't find file: '.\DATABASE\TABLE.frm' (errno: 22 - Invalid argument) ===		=== ERROR 1017 - Can't find file: '.\DATABASE\TABLE.frm' (errno: 22 - Invalid argument) ===

2025-08-29T10:52:22Z

Transfer Data from MySQL to MSSQL

@@ Line 545: / Line 545: @@
 * (Manually method) Export MySQL data in a format compatible with Microsoft SQL Server: {{kbd | key=<nowiki>mysqldump --compatible=mssql [database_name]</nowiki>}}<ref>[https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html#option_mysqldump_compatible MySQL :: MySQL 8.4 Reference Manual :: 6.5.4 mysqldump — A Database Backup Program]</ref>
 * (Automated method) Use [https://learn.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-ver17 Microsoft SQL Server Migration Assistant] or ''$'' [https://www.webyog.com/product/sqlyog SQLyog] tool (for {{Win}}). Use query commands to specify the data to be transferred from MS SQL server to MySQL server.
 Related issues:

2025-08-29T10:49:54Z

Transfer Data from MySQL to MSSQL

← Older revision		Revision as of 18:49, 29 August 2025
Line 544:		Line 544:
	Solution:		Solution:
	* (Manually method) Export MySQL data in a format compatible with Microsoft SQL Server: {{kbd \| key=<nowiki>mysqldump --compatible=mssql [database_name]</nowiki>}}<ref>[https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html#option_mysqldump_compatible MySQL :: MySQL 8.4 Reference Manual :: 6.5.4 mysqldump — A Database Backup Program]</ref>		* (Manually method) Export MySQL data in a format compatible with Microsoft SQL Server: {{kbd \| key=<nowiki>mysqldump --compatible=mssql [database_name]</nowiki>}}<ref>[https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html#option_mysqldump_compatible MySQL :: MySQL 8.4 Reference Manual :: 6.5.4 mysqldump — A Database Backup Program]</ref>
	* (Automated method) Use ''$'' [https://www.webyog.com/product/sqlyog SQLyog] tool (for {{Win}}). Use query commands to specify the data to be transferred from MS SQL server to MySQL server.		* (Automated method) Use [https://learn.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-ver17 Microsoft SQL Server Migration Assistant] or ''$'' [https://www.webyog.com/product/sqlyog SQLyog] tool (for {{Win}}). Use query commands to specify the data to be transferred from MS SQL server to MySQL server.

	Related issues:		Related issues:

2025-07-15T03:32:46Z

2025-03-20T03:55:33Z

Transfer Data from MySQL to MSSQL

← Older revision		Revision as of 11:55, 20 March 2025
Line 543:		Line 543:

	Solution:		Solution:
	* (Manually method) Export MySQL data in a format compatible with Microsoft SQL Server: {{kbd \| key=<nowiki>mysqldump --compatible=mssql [database_name]</nowiki>}}		* (Manually method) Export MySQL data in a format compatible with Microsoft SQL Server: {{kbd \| key=<nowiki>mysqldump --compatible=mssql [database_name]</nowiki>}}<ref>[https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html#option_mysqldump_compatible MySQL :: MySQL 8.4 Reference Manual :: 6.5.4 mysqldump — A Database Backup Program]</ref>
	* (Automated method) Use ''$'' [https://www.webyog.com/product/sqlyog SQLyog] tool (for {{Win}}). Use query commands to specify the data to be transferred from MS SQL server to MySQL server.		* (Automated method) Use ''$'' [https://www.webyog.com/product/sqlyog SQLyog] tool (for {{Win}}). Use query commands to specify the data to be transferred from MS SQL server to MySQL server.

2025-03-20T03:40:04Z

Connection and Network Errors

@@ Line 537: / Line 537: @@
 Explanation:
 It typically occurs when your application is unable to establish a connection to the specified database server.
 == Resource and Environmental Errors ==

2024-12-18T03:06:47Z

References

2024-12-18T03:04:52Z

Error 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

@@ Line 281: / Line 281: @@
-=== Error 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ===
+=== ERROR 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ===
 Message
 <pre>
@@ Line 304: / Line 304: @@
 (2, 'A123', 'Bob', 'Great!', 5, '2024-01-02'),
 (3, 'A123', 'Bob', 'Nice!', 3, '2024-01-03');
 </pre>
 Solution: Fix the query by either (1) including all columns in GROUP BY or (2) using aggregate functions (like MAX, MIN, SUM, COUNT, GROUP_CONCAT)
 <pre>
--- Method 1: Add all columns to GROUP BY
+-- Method 1: disable `sql_mode=only_full_group_by`
 SELECT
     id,
@@ Line 318: / Line 355: @@
 GROUP BY post_id, author, id, content, likes;
--- Method 2: Use aggregate functions for non-GROUP BY columns
+-- Method 3: Use aggregate functions for non-GROUP BY columns
 SELECT
     MAX(id) as id,

2024-12-18T02:53:28Z

ERROR 1054 - Unknown column in 'where clause'

@@ Line 278: / Line 278: @@
 ) final
 WHERE final.rank <= 10
 </pre>

2024-11-23T14:35:20Z

← Older revision		Revision as of 22:35, 23 November 2024
Line 1:		Line 1:
	Troubleshooting of MySQL errors		Troubleshooting of MySQL errors

	{{LanguageSwitcher \| content = [[Troubleshooting of MySQL errors \| EN]], [[排除 MySQL 技術疑難問題\|漢字]]}}		{{LanguageSwitcher \| content = [[Troubleshooting of MySQL errors \| English]], [[排除 MySQL 技術疑難問題\|漢字]]}}