database

LDAP CONFIGURATION FOR USER AND GROUP CENTRALISED AUTHENTICATION ON UBUNTU 12.04 LTS – PART-1

Tags: autofsautomountcentralized authenticationdatabaseldap clientldap servernfsquotaubuntu server

Published on : June 12, 2012 by

LDAP CONFIGURATION FOR USER AND GROUP CENTRALISED AUTHENTICATION ON UBUNTU 12.04 LTS – PART-1

I’m breaking down the tutorial into three parts, where the first part (PART-1) explains the basic user and group centralization, the second part (PART-2) explains how to setup automatic mounting of ldap user home directory using nfs and autofs, setting up disk quotas for ldap users and allowing an ldap user to change his own […]

Continue Reading...


Simple backup script for remotely backing up databases

Tags: backupbackupscPanelcpanel mysql backupdatabaseMySQLmysqldumpremoteremote mysql backupscript

Published on : May 25, 2011 by

Simple backup script for remotely backing up databases

This database backup script is actually a small modification of another backup script available in Google. I am not able to get that URL to mark/link reference. The only modification I added is a four liner to remove a week old backup automatically. You may also see https://www.supportsages.com/2011/05/applying-wildcards-in-grant-option-of-mysql/ as well. Indenting in python is lost, […]

Continue Reading...


Applying wildcards in GRANT option of MySQL

Tags: backupscPanelcPanel server backupdatabaseMySQLmysqldump

Published on : by

Applying wildcards in GRANT option of MySQL

In MySQL server support, We had this particular requirement of creating a database user to be used to backup only the cPanel databases. Only recently the database mapping has been introduced by cPanel which allows the clients to create databases without the _ . However on all our client servers, we insist to have the […]

Continue Reading...


MySQL for Beginners

Tags: cPaneldatabaseMySQLmysqldumpphpmyadminrepairWHM

Published on : February 4, 2011 by

MySQL for Beginners

In this post, I’ll explain some MySQL basics that would be very useful for beginners Reset MySQL root password Log in as Root and Stop the MySQL daemon. Then Start the MySQL daemon and skip the grant tables which store the passwords. Now you should be able to connect to mysql without a password. If […]

Continue Reading...


PostgreSQL for the sage – Must know basics for the system administrators

Tags: backupcPaneldatabasePostgreSQLrestore

Published on : August 5, 2010 by

PostgreSQL for the sage – Must know basics for the system administrators

This PostgreSQL basics Tutorial providing the must know basics for the system administrators. PostgreSQL or Postgres is an object-relational database management system (ORDBMS). Unlike MySQL, PostgreSQL is not controlled by any single company, it is a community developed project. It is a advanced version of the ‘Ingres’ Database project (which is how the project gets […]

Continue Reading...


Let's Connect

Get new updates

Categories

$0.000 items