Today, I saw that our mysql server suddenly went down and on checking mysql server logs, following thing was noticed. InnoDB: Unable to lock /path/to/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. To fix this issue, make a copy of …
Category Archive: Mysql
Jan 22
mysql :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 for this problem. 1) Set the following …
Nov 03
MySQLCouldn’t find MySQL manager
Restarting mysql was giving following error [root@server]# /etc/init.d/mysql restart MySQL manager or server PID file could not be found! [FAILED] Starting MySQLCouldn’t find MySQL manager (/var/lib/bin/mysql) or server (/var/lib/bin/mysqld_safe) FIX: Comment out or remove the basedir directive from /etc/my.cnf file [mysql.server ] server=mysql #basedir=/var/lib Then restart mysql That’s all contact@webhostingsupport.info
Dec 12
Downgrade mysql on cpanel
By default cPanel installs Mysql 5. If for some reason you wish to downgrade mysql then you will need to follow following steps. 1) If you already have database on server, then you will need to take backup of them in the format of .sql for simply copy/var/lib/mysql to /var/lib/mysql-bak . If server is newly …
Aug 17
How to install PostgreSQL
There are differnt steps to install PostgreSQL as per the control pnalel installed on your server. Say if you have cPanel/WHM installed on yuor server, then you can install it by going th following steps. 1) ssh to server and execute command /scripts/installpostgres Above command will take few sec/minutes to complte the installation. 2) Once this …
Recent Comments