|
|
|
Tuesday, 31 January 2012 13:54 |
|
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (CentOS 6.2 x86_64)
This document describes how to install a Postfix mail server that is
based on virtual users and domains, i.e. users and domains that are in
a MySQL database. I'll also demonstrate the installation and
configuration of Courier, so that Courier
can authenticate against the same MySQL database Postfix uses. The resulting Postfix server is capable of SMTP-AUTH and TLS and quota. Passwords are stored in encrypted
form in the database. In addition to that, this
tutorial covers the installation of Amavisd, SpamAssassin, ClamAV and SquirrelMail. Read more: |
|
|
Monday, 19 December 2011 00:53 |
Database Publishing Wizard is very flexible and works with modes like schema only, data only or both. It generates a single SQL script file which can be used to recreate the contents of a database by manually executing the script on a target server.
You may find at following location in your machine:
File Name:
SqlPubWiz.exe
Path:
C:\Program Files\Microsoft SQL Server\90\Tools\Publishing
Download Database Publishing Wizard from here http://sqlhost.codeplex.com/wikipage?title=Database%20Publishing%20Wizard&ProjectName=sqlhos Read more: |
|
Thursday, 15 December 2011 00:32 |
Clear the transaction Log if you are facing a low disk space on the database server.
To truncate log, use the following commands:
DBCC SHRINKFILE('logfilename', 1)
BACKUP LOG redeoba WITH TRUNCATE_ONLY DBCC SHRINKFILE('logfilename', 1)
where log filename is usually database name, i.e., northwind.log.
 Read more: |
|
|
Sunday, 05 June 2011 11:10 |
|
How To Set Up MySQL Database Replication With SSL Encryption On Debian Squeeze
This tutorial describes how to set up database replication in MySQL
using an SSL connection for encryption (to make it impossible for
hackers to sniff out passwords and data transferred between the master
and slave). MySQL replication allows you to have an exact copy of a
database from a master server on another server (slave), and all updates
to the database on the master server are immediately replicated to the
database on the slave server so that both databases are in sync. This is
not a backup policy because an accidentally issued DELETE command will
also be carried out on the slave; but replication can help protect
against hardware failures though. Read more: |
|
|
|
|
|
|
Page 1 of 3 |
