IndianWebPortal.com

Something Different In Linux

Home » mysql » mysqldump: Got error

mysqldump: Got error

Posted by Rishikesh Vispute Categories: mysql

Error : When you try to run the mysqldump command to make a backup of database then encounter the following error-exception:

mysqldump databasename  > databasename.sql

mysqldump: Got error: 1016: Can’t open file: ‘./databasename/wp_142_term_taxonomy.frm’ (errno: 24) when using LOCK TABLES

Solution: Open the file /etc/my.cnf and  add the following line and restart the mysql service on the server

root@server [~]#vi /etc/my.cnf

open-files-limit=20000

root@server [~]#/etc/init.d/mysql restart

Done

 

One Response so far.

  1. biosoftcoder says:

    Hi, Thanks


Popular Posts

remove index.php fro

How to remove index.php from url in magento Ans : If you ...

PHP-Java bridge on p

  What is php-java bridge? The php-java bridge is the php ...

Set expiration for y

If you want to set the expiration to your site ...

Warning: Parameter 1

Error: Warning: Parameter 1 to modMainMenuHelper::buildXML() expected to be a ...

domain pointing to e

If you domain uses external MX record and it is ...