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 …
Category Archive: Mysql
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 …
Aug
17
How to Backup and Restore PostgreSQL Database
pg_dump is an effective tool for PostgreSQL through which we can backup postgres database and to restore PostgreSQL database, command psql is enough. 1) backup postgres database Ssh to server and execute following command to take backup of database. #pg_dump -U Db_User Db_name -f database_name.sql Executing above command will prompt you for database password, once …
Reliable Hosting
Recent Comments