hi everbody
This is dhirendra ,i have a problem.when i try to create any database or table name in mysql it was not create and error messaege display:
error message : when try to create a table in database
ERROR 3:Error writing file'./<database name>/<table name>.frm (Errcode: 28)
approx same error was display when i try to create new databse
I put this error in google.com and there i found this is due to disk space,
then i try this command to know the about disk spaces
the output of 'df /var /usr' command
Filesystem 1k-blocks Used Available Use% Mounted on
/dev/hda5 5858512 500688 5060224 9% /usr
/dev/hda7 256667 243898 0 100% /var
it will show that /var have not enough space to write data,my mysql data folder is /var/lib/mysql
How i overcome from this problem its realy urgent kindly reply me as soon as possible i am watiting for your respose.
Thanks in advance
Dhirendra
This is dhirendra ,i have a problem.when i try to create any database or table name in mysql it was not create and error messaege display:
error message : when try to create a table in database
ERROR 3:Error writing file'./<database name>/<table name>.frm (Errcode: 28)
approx same error was display when i try to create new databse
I put this error in google.com and there i found this is due to disk space,
then i try this command to know the about disk spaces
the output of 'df /var /usr' command
Filesystem 1k-blocks Used Available Use% Mounted on
/dev/hda5 5858512 500688 5060224 9% /usr
/dev/hda7 256667 243898 0 100% /var
it will show that /var have not enough space to write data,my mysql data folder is /var/lib/mysql
How i overcome from this problem its realy urgent kindly reply me as soon as possible i am watiting for your respose.
Thanks in advance
Dhirendra