Getting the database out of LOADING state When restoring multiple backups, each backup needs...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 my Windows server
In Network Connections, right-click the local area connection, and then click Properties. In...Change the DNS servers for the network interfaces on 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 a backup file of a SQL Server database?
Open Enterprise Manager and expand the registered SQL Server Expand Databases Right-click on...Create PostgreSQL user account
It is advisable to run PostgreSQL under a separate user account. This user account should only...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 -> MS...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...Fix Lame Nameserver Error
A lame server, is one that is specifed at the registrar to be authoritative for a domain, but...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 and configure DNS server in Windows Server 2003
Solution Install DNS 1. Open Windows Components Wizard. To do so, use the following...Install Microsoft SQL Server
The installation of Microsoft SQL Server, like that of various modern products is fairly easy,...Install PostgreSQL from source 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...redirect using .htaccess
1) Temporary Redirect : Redirect temp / http://www.test.com This will redirect...Reset the SQL Server ‘sa’ user password?
Open Enterprise Manager and expand the registered SQL server. Expand Security. Click on...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...