Articles

After restoring a SQL Server database, it show a status of “Loading”

Getting the database out of LOADING state When restoring multiple backups, each backup needs to...
Backing up and restoring a MySQL database from the command line

. Shell into your box as root, then: mysqldump -a -u USERNAME -p DATABASE > FILENAME.mysql...
Change the DNS servers for the network interfaces on Windows server

Solution In Network Connections, right-click the local area connection, and then click...
Change the DNS servers for the network interfaces on my Windows server

In Network Connections, right-click the local area connection, and then click Properties. In...
Change the root password for a *nix server

In order to change the root password login to the server as root and type the following, then...
ColdFusion DSN parameters are not updated

SYMPTOMS New CF DSN records are created.  Even the set of parameters is tried to be updated...
Connect to my MSSQL database via Enterprise Manager?

To connect to your MSSQL database using Enterprise Manager, please perform the following: 1....
Copy MySQL database to another server through shell?

Copying MySQL Databases to another server If you are using MySQL 3.23 or later, you can copy the...
Create PostgreSQL user account

It is advisable to run PostgreSQL under a separate user account. This user account should only...
Create a backup file of a SQL Server database?

Open Enterprise Manager and expand the registered SQL Server Expand Databases Right-click on...
Enable the full text indexing for a MSSQL database

Syntax sp_fulltext_database Initializes full-text indexing or removes all full-text catalogs...
Execute a SQL script (.sql file) on MsSql Server database

To execute a .sql file, you need to open the “Query Analyzer” Start -> Programs...
Execute a SQL script (.sql file) on my SQL Server database?

To execute a .sql file, you need to open the “Query Analyzer” Start -> Programs...
Export the data from different tables in our shared SQL environment?

Using Enterprise Manager Expand SQL Server group Expand the server name Expand Databases...
Finding what packages are installed on a Linux system

For distributions that use RPM format packages, use the command: $ rpm -qa You may want to pipe...
Fix Lame Nameserver Error

A lame server, is one that is specifed at the registrar to be authoritative for a domain, but the...
Fix nameservers not working for Linux servers

If you have your own namerservers or you are using nameservers provided by host, and these...
How does memory overcommit affect PostgreSQL?

In Linux 2.4 and later, the default virtual memory behavior is not optimal for PostgreSQL....
How is Linux Licensed?

Linus has placed the Linux kernel under the GNU General Public License, which basically means...
How to Install MRTG

Solution Steps for MRTG installation are documented as MRTG Installation Make sure MRTG is NOT...
Install Microsoft SQL Server

The installation of Microsoft SQL Server, like that of various modern products is fairly easy,...
Install PostgreSQL from source

The following are the commands for installing PostgreSQL from source, refer to the INSTALL file...
Install and configure DNS server in Windows Server 2003

Solution Install DNS 1. Open Windows Components Wizard. To do so, use the following...
Installation of Geotrust True Site Icon

Installation of True Site icon: Per the subscriber agreement, you are required to install the...
Manage Database Roles

Solution Database roles are conceptually completely separate from operating system users....
Manage Query Cache

You can check whether the query cache is present in your MySQL server using the following...
Manage Tablespaces

Tablespaces in PostgreSQL allow database administrators to define locations in the file system...
MySQL will not start, “MySQL File ‘/usr/share/mysql/charsets/?.conf’ not found” in error log.

The most common cause for this error, is a failed downgrade of MySQL from 4.1 to 4.0.  Many...
Reset the SQL Server ‘sa’ user password?

Open Enterprise Manager and expand the registered SQL server. Expand Security. Click on Logins....
Restore a database on SQL Server using .mdf, .ldf and .ndf files?

You need to attach the database rather than perform a restore. Using Enterprise Manager: Expand...
Restore the SQL Server master database?

Please see http:// techrepublic.com.com /5102-6268-5025441 . html for more details. Also, be...
Restrict clients using my SQL Server by their IP Address?

SQL Server has no built-in support for restricting clients by IP address. The most common...
Run MySQL with a normal user?

On Unix, the MySQL server mysqld can be started and run by any user. To change mysqld to run as a...
Shrink MsSql DB Logs

1. Open query analyser. Do not open Enterprise Manager. 2. Let the database be selected as...
The difference in using cluster vs. replication

In a replication setup, a master MySQL server updates one or more slaves. Transactions are...
Tune MySQL

Mysql set up (“my.cnf”). The MySQL config file, my.cnf. Here is what to add under...
Use mysql_fix_privilege_tables script

mysql_fix_privilege_tables — Upgrade MySQL System Tables Some releases of MySQL introduce...
View the contents of a table in a SQL Server database using Enterprise Manager?

Open Enterprise Manager and expand the registered SQL Server Expand Databases Expand the...
What is a reverse DNS record?

A reverse DNS record (also know as a PTR record), is a reverse mapping from IP to name. For...
What is round robin DNS?

Round robin DNS is a method by which a DNS record has more than one value. When a request is made...
What platforms does Linux support?

Linux runs on almost every general-purpose computer made in the last 10 years. It runs on systems...
What to do if MySql.sock file is missing

1. THIS IS THE MOST IMPORTANT! Back up the /var/lib/mysql directory!!!!!!! # cp -fr...
When I check my logs, I see a lot of messages about lame servers. What is that, and how do I fix it?

A lame server is one that is specified at the registrar to be authoritative for a domain, but the...
Why should I disable autocommit while dumping a database?

Turn off autocommit and just do one commit at the end. (In plain SQL, this means issuing BEGIN at...
redirect using .htaccess

1) Temporary Redirect : Redirect temp / http://www.test.com This will redirect http://test.com...
“Cannot connect to the database” errors

- Make sure that after you created your database and database user that you didn’t forget...