Knowledgebase


Portal Home > Knowledgebase > General

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 use the NORECOVERY option to keep the database in a loading state so additional backups can be...

 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 You will be prompted for your database password and then the DATABASE will be dumped to a plain-text...

 Change the DNS servers for the network interfaces on Windows server

Solution In Network Connections, right-click the local area connection, and then click Properties. In Local Area Connection Properties, select Internet Protocol (TCP/IP), 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 Local Area Connection Properties, select Internet Protocol (TCP/IP), and then click Properties. Click...

 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 press enter: passwd This will ask you for the new password twice.

 ColdFusion DSN parameters are not updated

SYMPTOMS New CF DSN records are created.  Even the set of parameters is tried to be updated through Plesk, Domains, domain.tld, ColdFusion DSN, issued DSN page, the new set of parameters is...

 Connect to my MSSQL database via Enterprise Manager?

To connect to your MSSQL database using Enterprise Manager, please perform the following: 1. Bring up Enterprise Manager. 2. Go to menu “Action”->”New SQL Server...

 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 .frm, .MYI, and .MYD files for MyISAM tables between different architectures that support the same...

 Create PostgreSQL user account

It is advisable to run PostgreSQL under a separate user account. This user account should only own the data that is managed by the server, and should not be shared with other daemons. (For example,...

 Create a backup file of a SQL Server database?

Open Enterprise Manager and expand the registered SQL Server Expand Databases Right-click on the database that you want to backup, select All Tasks -> Backup Database If you would like to...

 Enable the full text indexing for a MSSQL database

Syntax sp_fulltext_database Initializes full-text indexing or removes all full-text catalogs from the current database. sp_fulltext_database [@action =] 'action' Arguments [@action =] 'action'...

 Execute a SQL script (.sql file) on MsSql Server database

To execute a .sql file, you need to open the “Query Analyzer” Start -> Programs -> MS SQL Server -> Query Analyzer Connect to the database that you’re running the...

 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 -> MS SQL Server -> Query Analyzer Connect to the database that you’re running the...

 Export the data from different tables in our shared SQL environment?

Using Enterprise Manager Expand SQL Server group Expand the server name Expand Databases Expand the database that you’ll be exporting data from Click on Tables Right-click the table...

 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 the output to grep, a pager, or a text file. A: For Debian and derivative systems, the equivalent...

 Fix Lame Nameserver Error

A lame server, is one that is specifed at the registrar to be authoritative for a domain, but the server itself is not setup in this manner. This is not a configuration issue on your end, but...

 Fix nameservers not working for Linux servers

If you have your own namerservers or you are using nameservers provided by host, and these nameservers aren’t working : Solution – Edit the  file /etc/resolv.conf and put in the...

 How does memory overcommit affect PostgreSQL?

In Linux 2.4 and later, the default virtual memory behavior is not optimal for PostgreSQL. Because of the way that the kernel implements memory overcommit, the kernel may terminate the PostgreSQL...

 How is Linux Licensed?

Linus has placed the Linux kernel under the GNU General Public License, which basically means that you may freely copy, change, and distribute it, but you may not impose any restrictions on further...

 How to Install MRTG

Solution Steps for MRTG installation are documented as MRTG Installation Make sure MRTG is NOT installed. Type: rpm -e mrtg It should come back with: error: package mrtg is not installed....

 Install Microsoft SQL Server

The installation of Microsoft SQL Server, like that of various modern products is fairly easy, whether you are using a CD called SQL Server Developer Edition, a DVD or a downloaded edition. If you...

 Install PostgreSQL from source

The following are the commands for installing PostgreSQL from source, refer to the INSTALL file for explanation of each: ./configure gmake su gmake install adduser postgres mkdir...

 Install and configure DNS server in Windows Server 2003

Solution Install DNS 1. Open Windows Components Wizard. To do so, use the following steps: a. Click Start, click Control Panel, and then click Add or Remove Programs. b....

 Installation of Geotrust True Site Icon

Installation of True Site icon: Per the subscriber agreement, you are required to install the True Site icon on your home page. Please place the True Site icon on your home page by installing the...

 Manage Database Roles

Solution Database roles are conceptually completely separate from operating system users. Database roles are global across a database cluster installation. To create a role use the CREATE ROLE SQL...

 Manage Query Cache

You can check whether the query cache is present in your MySQL server using the following statement: mysql> SHOW VARIABLES LIKE 'have_query_cache'; You can defragment the query cache to better...

 Manage Tablespaces

Tablespaces in PostgreSQL allow database administrators to define locations in the file system where the files representing database objects can be stored. Once created, a tablespace can be...

 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 changes were made between MySQL 3.x, 4.0.x, and 4.1. The actual cause of the error itself, is...

 Reset the SQL Server ‘sa’ user password?

Open Enterprise Manager and expand the registered SQL server. Expand Security. Click on Logins. Right-click the user “sa” and select Properties. Type the new password in the...

 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 the registered SQL server Right-click Databases, select All Tasks -> Attach Database… Click...

 Restore the SQL Server master database?

Please see http:// techrepublic.com.com /5102-6268-5025441 . html for more details. Also, be certain that when you put the MSSQL server into single user mode that you connect quickly using query...

 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 work-arounds are firewalls, IPSec, or third-party network layer filters to allow only certain source IP...

 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 normal unprivileged Unix user user_name, you must do the following: Stop the server if it’s...

 Shrink MsSql DB Logs

1. Open query analyser. Do not open Enterprise Manager. 2. Let the database be selected as “Master” 3. Fire the command BACKUP LOG “DATABASE_NAME” WITH TRUNCATE_ONLY...

 The difference in using cluster vs. replication

In a replication setup, a master MySQL server updates one or more slaves. Transactions are committed sequentially, and a slow transaction can cause the slave to lag behind the master. This means...

 Tune MySQL

Mysql set up (“my.cnf”). The MySQL config file, my.cnf. Here is what to add under the [mysqld] heading. The two lines, “max_connections” and...

 Use mysql_fix_privilege_tables script

mysql_fix_privilege_tables — Upgrade MySQL System Tables Some releases of MySQL introduce changes to the structure of the system tables in the mysql database to add new privileges or support...

 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 database Click on Tables, all of the tables in the database will show up in the right pane Locate 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 instance, when a lookup is made on the IP of 1.2.3.4, it should come back with host.mydomain.com. It is a...

 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 to the DNS server which serves this record, the answer it gives alternates for each request. For...

 What platforms does Linux support?

Linux runs on almost every general-purpose computer made in the last 10 years. It runs on systems as small as PDAs and on systems as large as IBM mainframes.

 What to do if MySql.sock file is missing

1. THIS IS THE MOST IMPORTANT! Back up the /var/lib/mysql directory!!!!!!! # cp -fr /var/lib/mysql /var/lib/mysql.old 2. Check /var/lib/mysql and /tmp for the .sock file (is it in both places?)...

 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 server itself is not setup in this manner. This is not a configuration issue on your end, but...

 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 the start and COMMIT at the end) If you allow each insertion to be committed separately, PostgreSQL...

 redirect using .htaccess

1) Temporary Redirect : Redirect temp / http://www.test.com This will redirect http://test.com — to — http://www.test.com Redirect temp /folder http://www.test.com/folder This will...

 “Cannot connect to the database” errors

- Make sure that after you created your database and database user that you didn’t forget to ADD the database user to the database (at the bottom of the “Databases” section in...