1. How to check POstgresql version. [root@BMDB-02 ~]# psql –version psql (PostgreSQL) 8.1.11 ================= 2. How to create postgreSQL USER ? /usr/local/pgsql/bin/createuser skadam Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) n Shall the new role be allowed to create more new roles? (y/n) […]
See MoreTag: 1 dollar hosting
MySQL is disabled by sys admin while restarting MySql service
Sometimes it may happen that while restarting mysql service on server you are getting below error. mysql is disabled by sys admin Try running below script to bring mysql up again /scripts/mysqlup If it’s Up then ok, but sometime it will give below error Updates for mysql /etc/mysql disabled If it is not working then go to /etc folder cd /etc Run the […]
See MoreHow to restore crashed directadmin server from old HDD !!!
First of all mount the crash disk. In my case I am mounting it in /mnt Now, you have to copy the data from old disk to new disk using below commands cp -avprf /mnt/etc/passwd /etc/ cp -avprf /mnt/etc/group /etc/ cp -avprf /mnt/etc/shadow /etc/ cp -avprf /mnt/etc/gshadow /etc/ cp -avprf /mnt/etc/my.cnf /etc/ cp -avprf /mnt/etc/exim* […]
See More
You must be logged in to post a comment.