MySQL Server Errors

Databases

MySQL

MySQL Diagnostics & Tuning

MySQL Errors

ERROR 3 (HY000) at line x: Error writing file '...'

ERROR 1086 (HY000): File '...' already exists.

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option

[ERROR] Slave I/O for channel '': error connecting to master...

[MY-000011]: Can't unlock file (OS errno %d - %s)

[MY-000035] [Server] Disk is full writing '...'

[MY-000067] [Server] unknown variable ...

[MY-010020] [Server] Data Dictionary initialization failed.

ERROR 3 (HY000) at line x: Error writing file '...'

ERROR 3 (HY000) at line 1: Error writing file '/tmp/myfile.txt' (Errcode: 28 - No space left on device)

See OS Error Code 28

MySQL OS Errors

ERROR 1086 (HY000): File '...' already exists.

This error will be raised when you attempt to SELECT ... INTO OUTFILE where the target file already exists.

Database to Text

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

This error will be raised when you attempt to SELECT ... INTO OUTFILE where the target file is outside the location specified by the secure_file_priv parameter.
Check the correct location with...

SELECT @@secure_file_priv;

[ERROR] Slave I/O for channel '': error connecting to master...

MySQL Replication

[ERROR] Slave I/O for channel '': error connecting to master '...' - retry-time: 60 retries 88888, Error_code: 2003

See Client Error Code 2003

MySQL Client Errors

[MY-000011]: Can't unlock file (OS errno %d - %s)

[MY-000035] [Server] Disk is full writing '...'

[ERROR] [MY-000035] [Server] Disk is full writing './binlog.000023' (OS errno 28 - No space left on device). Waiting for someone to free space... Retry in 60 secs. Message reprinted in 600 secs.

[ERROR] [MY-000035] [Server] Disk is full writing './relay-bin.000005' (OS errno 28 - No space left on device). Waiting for someone to free space... Retry in 60 secs. Message reprinted in 600 secs.

See OS Error Code 28

MySQL OS Errors

[MY-000067] [Server] unknown variable ...

[ERROR] [MY-000067] [Server] unknown variable 'symbolic-link=0'.

Caused by a typo. In this case, the real variable is called symbolic-links (which is deprecated so, ideally, don't set it anyway).

[MY-010020] [Server] Data Dictionary initialization failed.

[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

See accompanying error messages.

Page updated

Google Sites

Report abuse