MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file

Posted on : Mon, 12th Oct 15 11:43 am (Updated on : Mon, 12th Oct 15 11:43 am) GMT
Author : Code2care

This error may occur when creating a .frm file or copying it form one location to another fails.

If the .frm file is being moved or you do not have access permissions then you may get ER_CANT_CREATE_FILE.

It may also occur during creating of new table using LIKE clause.

What is a .frm file?

Example to access .frm file (Using XAMPP)

  1. Create table : mydb.mytable (name varchar(10));
  2. Now go to location where mysql is installed : XAMPP/xamppfiles/var/mysql/mydb/mytable.frm
  3. Note you may not have access to this file only if you have root access.

We are operating with limited resources due to COVID-19 - Stay Safe!

We stands in support of racial equality!

Follow us : Facebook - Twitter