mysql Open file limit error(solved)

This error will cause high load on your sever. There is a variable on mysql .cnf file. You may need to look at it check your variable and see if you can optimize your server. However, I found this file limit error was causing high load on my server.

Open your .cnf file with your favorite editor

nano /etc/my.cnf
change the open file limit to a number as high as 100 000
open_files_limit = 100000

Save and restart mysql server

service mysql restart

How to quikly backup and restore mysql database

This is a quick way of how to backup and restore your database.

TO backup issue this command
$ mysqldump -u root -p[root_password] [database_name] > backupfle.sql

To restore issue this command

$ mysql -u root -p[root_password] [database_name] < backupfile.sql

Notice > and < operators.

I usually put my database dumpfile in the database directory of mysql. For example for centos /var/lib/mysql so that the backed up file and restore database are in the same directory

Apache Yahoo News Feed

Drupal Yahoo News

Linux Yahoo News Feed

Mysql Yahoo News Feed