Posts Tagged ‘mysql’

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

Export users from MySQL with GRANTS

Posted: 27th October 2016 by admin in all
Tags: , , ,

When you moving the MySQL server from one server to another You might to copy users with their grants – the easiest and the rigth way to do this . Run this query on the source server: ### mysql -uroot -p{PASS} -B -N -e "SELECT DISTINCT CONCAT('SHOW GRANTS FOR \'', user, '\'@\'', host, '\';') AS […]

MySQL server is down and when you try to bring it up you got error: Another MySQL daemon already running with the same unix socket. Any attempts to starp up fails The best way is perform a graceful shutdown of the server from the command line rather than powering off the server. # shutdown -h […]

Plesk Panel was updated and released new panel -v 11.5 Couple of bugs were founded #1 File manager being reproduce errors when enter into file manager and get below error: ++++++ Internal error: Unable to lookup SID for name MISSEDUSERID: (1332) No mapping between account names and security IDs was done. (Error code 1) Message […]

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 […]