Posts Tagged ‘file’

mysqldump:Got error: 1016: Can’t open file: ‘*’ (errno: 24) when using LOCK TABLES

Bash File Testing

Posted: 2nd July 2014 by admin in Trick
Tags: , ,

Bash File Testing: -b filename – Block special file -c filename – Special character file -d directoryname – Check for directory existence -e filename – Check for file existence -f filename – Check for regular file existence not a directory -G filename – Check if file exists and is owned by effective group ID. -g filename – true if file exists and […]

Protect files starting with a dot in nginx

Posted: 20th May 2014 by admin in all
Tags: , , , , ,

Protect files starting with a dot in nginx: One of the things you have to get used to when switching from the Apache webserver to nginx is that you don’t use local .htaccess files anymore for configuring a vhost. To speed up operations nginx doesn’t allow to locally override settings, forcing you to make the […]

Here is MsSQL quere to shrink DB log file: For safity!!! DO BACKUP BEFORE Alter database invcenter SET RECOVERY SIMPLE; Go USE databasename; GO DBCC SHRINKFILE (logfilename); GO Alter database databasename SET RECOVERY FULL; Go  

Comments Off on mysqldump:Got error: 1016: Can’t open file: ‘*’ (errno: 24) when using LOCK TABLES

Sometimes, when you have got a large number of tables in your database and while taking the dump of that particular database, you would have encountered this strange error mysqldump: Got error: 1016: Can't open file: '.\database\certain_table.frm' (errno: 24) when using LOCK TABLES There are two solutions to avoid this error 1. Set the following […]