Explore information related to database

Zabbix Postgres vs MySQL

This article will help you give you more informations about #Zabbix Postgres vs MySQL and the criteria to choose between them. 

PostgreSQL is an Object Relational #Database Management System (#ORDBMS) whereas MySQL is a community driven DBMS system. PostgreSQL support modern applications feature like #JSON, XML etc. while MySQL only supports JSON.

PostgreSQL supports Materialized Views whereas #MySQL doesn't supports Materialized Views.

#PostgreSQL is known to be faster while handling massive data sets, complicated queries, and read-write operations. 

Meanwhile, MySQL is known to be faster with read-only commands.

Advantages Of Using MySQL:

1. It's Easy To Use.

2. Support Is Readily Available Whenever Necessary.

3. It's Open-Source.

4. It's Incredibly Inexpensive.

5. It's An Industry Standard.

6. It's Got A Few Stability Issues.

7. It Suffers From Relatively Poor Performance Scaling.

Read More



Galera cluster asynchronous replication

This article will guide you on steps to perform Galera cluster asynchronous replication for #MySQL.  Galera Cluster for MySQL is a true Multi-Master Cluster based on synchronous replication. It's an easy-to-use, high-availability solution, which provides high system up-time, no data loss and scalability for future growth.

To do you get a Galera Cluster:

1. Create a #Cloud Server. First, log in to your Cloud Server via an SSH tool such as putty.

2. Install #MariaDB Server on All Servers.

3. Configure Each Server in the #Cluster.

4. Initialize the Galera Cluster.

5. Test Galera Cluster #Replication.

Read More



Joomla error displaying the error page

This article will guide you on steps to resolve #Joomla #error displaying the error page which occurs due to trouble in the configuration file or a corrupt #database.

After you have determined the correct database settings, you are ready to update the configuration.php file. 

To do this, follow these steps:

1. In the FILES section of the cPanel home screen, click File Manager:

2. Navigate to the directory where Joomla is installed.

3. Right-click the configuration.php file, and then click Edit.

4. Locate the $db variable, and then replace the value with the name of the Joomla database that you obtained in the previous procedure. 

For example, if your database name is username_joom123, modify the text as follows:

public $db = 'username_joom123';

5. Locate the $user variable, and then replace the value with the database username that you obtained in the previous procedure. For example, if your database username is username_joomuser, modify the text as follows:

public $user = 'username_joomuser';

6. Locate the $password variable, and then replace the value with the database user's password. For example, if your database user's password is example_password, modify the text as follows:

public $password = 

7. Locate the $dbprefix variable, and then replace the value with the database table prefix that you obtained in the previous procedure. 

For example, if the database table prefix is jos_, modify the text as follows:

public $dbprefix = 'jos_';

8. irm that the $host variable is set to localhost as follows:

public $host = 'localhost';

9. Click Save Changes.

10. Use your web browser to go to the Joomla site's URL. The site should load.

Read More



DNN reset host password in database

This article will guide you on how to perform DNN reset host passwords in the database easily. 

Forgot DNN host password? 

1. DNN host account is the superuser or administrator of DotNetNuke websites. 

2. If you lost host or admin password for DNN site, you do not need to create a new DNN site again unless it is new installation. 

3. By the way, it is easy to create a new one if not yet. 

4. Do not miss out this guide to set up DNN website. 

5. DNN site has the password retrieval system which can help you recover password for non-superuser accounts. 

Read More



Wildcards in SQL Server

This article will guide to use #Wildcards in #SQL server. Also you will learn how to use and escape wildcards SQL-based databases. 

To use a wildcard character within a pattern: Open your #query in Design view. In the Criteria row of the field that you want to use, type the #operator Like in front of your criteria. Replace one or more characters in the criteria with a wildcard character.

i. The wildcard is an advanced search technique that can be used to maximize your search results in library databases. 

ii. Wildcards are used in search terms to represent one or more other characters. 

iii. The two most commonly used wildcards are: An asterisk (*) may be used to specify any number of #characters.

Read More



psql to restore a text dump How to do it

This article will guide you on steps to perform  text dump restoration. Basically, psql restores a text dump in the same file format.

You can backup a single table, a #schema, or a complete database. Select the name of the backup source in the #pgAdmin tree control, right click to open the context menu, and select Backup… to open the #Backup dialog. 

The name of the object selected will appear in the dialog title bar.

In #PostgreSQL, you can restore a database in two ways:

i. Using psql to restore plain #SQL script file generated by pg_dump and pg_dumpall tools.

ii. Using pg_restore to restore tar file and directory format created by the pg_dump tool.


To Restore Postgres Database:

1. Restore a postgres database. $ psql -U erp -d erp_devel -f mydb.sql.

2. Backup a local postgres database and restore to remote server using single command: $ pg_dump dbname | psql -h hostname dbname.

3. Restore all the postgres databases.

4. Restore a single postgres table.

Read More



Plesk MSSQL remote connection

This article will guide you on how to enable and resolve #MSSQL related #errors. MSSQL remote connection is disabled in #Plesk servers by default.

To enable remote connections to MS SQL server:

1. Connect to the server via RDP.

2. Press the Start button, go to Microsoft SQL Server XXXX (where XXXX is the MSSQL version) and click the SQL Server XXX Configuration Manager.

3. Open the SQL Server Configuration Manager (Local) > #SQL Server Network Configuration menu and click the Protocols for MSSQLSERVERXXXX (where XXXX is the MSSQL version).

4. Make sure that the TCP/IP protocol has the Enabled status

5. Double-click the TCP/IP protocol, go to the IP Addresses tab and scroll down to the IPAll section.

6. Specify 1433 in the TCP Port field (or another port if 1433 is used by another MS SQL Server) and press the OK button:

Note: the specified port, e.g, 1433, must be opened in the firewall.

Read More



Executing queries from the MySQL Command Line

This article will guide you on how to run queries from the 3MySQL command line. The MySQL #Command Line Tool is a useful way to run #queries from the command line. It’s easy to run select queries and display the results in either a horizontal or vertical format, and the queries run are kept in a history file which you can navigate through. 

If you don't want to run a particular query after all you can use the c command to clear it.

The most common way to get a list of the MySQL #databases is by using the mysql client to connect to the MySQL server and run the SHOW DATABASES command. If you haven't set a password for your MySQL user you can omit the -p switch.

To Connect to a MySQL Database:

1. Click Services tab.

2. Expand the Drivers node from the Database Explorer.

3. Enter User Name and Password.

4. Click OK to accept the credentials.

5. Click OK to accept the default schema.

6. Right-click the MySQL Database #URL in the Services window.

Read More



ISPConfig 500 internal server error

This article will guide you on different ways to resolve #ISPConfig 500 internal server #error and also you will learn about some factors that triggers this error such as exceeded MaxRequest value or PHP-fpm issue. 

The HyperText Transfer Protocol (#HTTP) #500 Internal Server Error server error response code indicates that the server encountered an unexpected condition that prevented it from fulfilling the request. Usually, this indicates the server cannot find a better 5xx error code to response.

The 500 internal server error runs on every page of your site when there's a problem with the server or file system that's powering your site. 

The cause most likely occurs in the root directory, where your WordPress files are, but it can also be caused by a problem on your host's server.

To Resolve 500 Internal Server Error:

1. Debugging the Issue. The first step is to make sense of the situation and try to make sense of the error.

2. Check if the Admin Works.

3. Revert Recent Changes.

4. Audit Your #Plugins/Extensions/Modules.

5. Check File Permissions.

6. Increase PHP #Memory Limit.

Read More



Restore a database in Alwayson Availability Group

This article will guide you on steps to restore a #database in alwayson availability group.

If you receive an #error that the database is in use, try to set the user to single user mode: USE master; GO ALTER DATABASE Database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE; Then try the restore with #recovery command again. Also, make sure you are on the latest service pack or cumulative update.

Creating a #SQL #Server AlwaysOn Availability Group.

Open SQL Server Management Studio and connect to the SQL Server instance. Expand the AlwaysOn High Availability folder in the Object Explorer. Right-click on the Availability Groups folder and select the New Availability Group Wizard.

To Restore a Database in a SQL Server AlwaysOn Availability Group:

1. Make the secondary server from which the backups were taken the primary server.

2. Remove the database to be restored from the AlwaysOn Availability Group.

3. Restore the database.

4. Add the database back into the Always Availability Group.

Read More



Configure Reporting Services in SQL Server

The article will guide you on the steps to follow to configure #reporting services after renaming the #SQL server. Also , you will learn how to rename the SQL server instance. 

To Configure #Report Server After Renaming SQL Server #Instance:

1. Go to #Database Setup page. 

2. Enter SQL Server name in Server Name and then click Connect. 

3. If Reporting Services is configured using the server name, you must update the database connection information whenever the server name is changed.

To change the service account for SQL Server Reporting Services:

i. Open Reporting Services Configuration Manager, and then connect to the instance of SQL Server Reporting Services.

ii. Click #Microsoft service Identity on the left pane.

iii. Change the account and the password in the Account text box and the Password text box, and then click Apply.

Read More



RoundCube CONNECTION FAILED Database Error

This article will guide you on the different methods to fix Database Error: Connection Failed error shows up due to database errors or #PHP #errors. 

Establishing a Database Connection #Error basically means that for some reason or another the PHP code was unable to connect to your #MySQL database to retrieve the information it needs to fully build that page. That's why the error is always shown on a blank page because there is no information about your site as it is not connected to your database.

Establishing a Database Connection Error Occur due to:

1. Incorrect Login Credentials.

2. Corrupt #Database

Read More



New files of configuration for Apache error in Plesk

This article will guide you on methods to fix the Plesk error : new files of configuration for Apache.
The causes of this Plesk error:
1. Mailman package is not installed.
2. Database related error.
3. PHP memory issue.
To fix this Plesk issue:
Mailman package is not installed
When you try to reconfigure the domain, you will get the following error.
# /usr/local/psa/admin/sbin/httpdmng --reconfigure-all
No valid mailman bindir detected
So, in this case it is clear that the issue is causing because the mailman package is missing.
To fix the issue, you can follow the steps mentioned below.
a) Download and install the mailman package from  http://autoinstall.plesk.com
b) After that remove all entries from the ‘Configurations’ table of the ‘psa’ database.
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e"delete from Configurations"
c) Remove all ‘Include’ records from configuration files and all content from the directory below:
# sed -i /Include/d /usr/local/psa/admin/conf/ip_vhosts_bootstrap.conf&& sed -i /Include/d /usr/local/psa/admin/conf/vhosts_bootstrap.conf&& sed -i /include/d /usr/local/psa/admin/conf/nginx_vhosts_bootstrap.conf&& sed -i /Include/d /usr/local/psa/admin/conf/webmail_horde_bootstrap.conf&& sed -i /Include/d /usr/local/psa/admin/conf/webmail_atmail_bootstrap.conf&& sed -i /Include/d /etc/httpd/conf.d/zz010_psa_httpd.conf&& rm -f /usr/local/psa/admin/conf/generated/*
d) Now you can reconfigure and that will fix the issues.
/usr/local/psa/admin/bin/httpdmng --reconfigure-all
This will resolve the error.

Read More



Database version or build from backup file

This article will guide you on how to determine the database #version or build from a #backup file.
To know what #SQL version a #database is:
The first is by using either Enterprise Manager or SQL Server Management Studio and right clicking on the instance name and selecting Properties. In the general section you will see information such as on the following screenshots. The "Product version" or "Version" gives you a number of the version that is installed.
In order to find the SQL Server version from a bak file:
1. Here is the output returned by the RESTORE HEADERONLY statement. Here you will see a DatabaseVersion column that contains the value.
2. That's how you find out from which version of SQL Server a given backup file came.

Read More



Improve SQL Server Bulk Data Import Performance

This article will guide you improve #bulk #data #import #performance. The BULK INSERT command is much faster than bcp or the data pump to perform text file import operations, however, the BULK INSERT statement cannot bulk copy data from #SQL Server to a data file. Use the bcp utility instead of DTS when you need to export data from the SQL Server table into a text file.
To Speed up SQL Bulk Insert with #transactions:
1. Declare the variables that store the number of desired items ( @items ), the size of the chunks( @chunk_size ) and the counter of the number of executed inserts( @counter )
2. Open the first transaction and initialize the while loop.

Read More



Steps to create SQL server alias

Steps for Deleting an alias using SQL Server Configuration Manager ?
#SQL aliases are used to give a table, or a column in a table, a temporary name. Aliases are often used to make column names more readable. An alias only exists for the duration of the query.
To find my SQL Server #alias name:
Expand SQL Native client #configuration, and you can find a subfolder Alias. By default, we do not have any alias defined for the SQL Server #instance. In the screenshot, we can see it does not see any items for the Alias. Right-click on Aliases and click on New Alias.
1. Take SQL Server Configuration Manager and go to SQL Server Native #Client Configuration, then click Aliases.
2. We can right-click the alias that we want to delete, and then click Delete.
3. A warning will pop up, we can click on Yes to remove the alias. This removes the SQL Server alias.

Read More



Orphaned users in SQL Server

This article will help you to identify #Orphaned #Windows #Logins and Groups in #SQL Server.
To Resolve an Orphaned User:
To map an orphaned user to a login which already exists in master, execute the ALTER USER #statement in the user database, specifying the login name.
ALTER USER <user_name> WITH Login = <login_name>; When you recreate a missing login, the user can access the database using the password provided.
To fix orphaned users for all databases in SQL Server:
1. Login with same name as user exists – generate ALTER LOGIN to map the user to the login.
2. No login with same name exists – generate DROP USER to delete the orphan user.
3. Orphan user is [dbo] – change the database owner to SA (or whatever SA was renamed to).

Read More



Auto shrink feature in SQL server

This article will guide you on how to enable and disable AutoShrink #database property. Basically, it is not recommended to enable the AutoShrink database property as it can cause many issues in the #SQL Server.
Auto Shrink is database property that allow SQL Server to automatically shrink database files if its value set to ON/True. Shrinking a database is not a good practice because it is very expensive operation in terms of I/O, CPU usage, locking and #transaction log generation.
Users can enable and disable database auto shrink option using SSMS and T-SQL both ways.
To turn on auto shrink in SQL Server:
1. Activating the database auto shrink by using #SSMS:
2. Enable database auto shrink using T-SQL:
3. Database >> #Reports >> Standard Reports >> Disk Usage.
4. Check free space for the database files:
5. Shrink database file:

Read More



Share Data between Docker Containers

This article will guide you on steps to share #data between #docker #containers. To mount a data volume to a container add the --mount flag to the docker run #command. It adds the volume to the specified container, where it stores the data produced inside the virtual 3environment.

From the Docker #host, as Docker Volumes: Volumes are stored in an area of the host filesystem that's managed by Docker. Bind mounts can map to any folder in the host filesystem, so access can't be controlled from a Docker process and can pose a security risk as a container could access sensitive OS folders.

A Docker container image is a lightweight, standalone, executable package of software that includes everything needed to run an application: code, runtime, system tools, system libraries and settings.

To copy from Docker to local container:

1. First, set the #path in your localhost to where the file is stored.

2. Next set the path in your docker container to where you want to store the file inside your docker container.

3. Then copy the file which you want to store in your docker container with the help of CP command.

Read More



Install InfluxDB on CentOS 7

This article will guide you on steps to Install #InfluxDB on #CentOS 7. You can Turn any InfluxData #instance into a production-ready cluster that can run anywhere. Easily create and share a comprehensive monitoring solution.

InfluxDB is similar to a #SQL #database, but different in many ways. Relational databases can handle time series data, but are not optimized for common time series workloads. InfluxDB is designed to #store large volumes of time series data and quickly perform real-time analysis on that data.

The local InfluxDB configuration file is located here: Linux: /etc/influxdb/influxdb. conf. macOS: /usr/local/etc/influxdb.

To Install InfluxDB:

Option 1 : Download the InfluxDB archive via the browser.

Option 2 : Adding the #repositories to your package manager.

i – Start your InfluxDB service.

ii – Configure your InfluxDB instance.

iii – Test your InfluxDB instance.

iv – #Download InfluxDB 2.0 archive from the website.

Read More



Instant File Initialization in SQL server

This article will guide you on how to enable Instant File Initialization (#IFI) in #SQL Server. 

Disk space reservation without initialization is called Instant File Initialization. 

To enable #database instant file initialization:

1. First, go to Start Menu and run secpol.msc to bring up Local #Security #Policy.

2. Expand the Local Policies Folder.

3. Click on User Rights Assignment.

4. Go to the Perform Volume Maintenance Tasks option and double click it.

5. Add your SQL Server Service account, and click OK.

6. Restart your SQL Server services (MUST DO).


Read More



Steps to Back Up And Restore Nagios System

This article will guide you on how to perform #Backup and #Restore of the #Nagios System are important aspects of the #administration and #maintenance of the #system. 

Backups are an important aspect of administration and maintenance of your system. They can easily facilitate the #migration of a Nagios XI #installation between a virtual server and physical server, and the design of a fail-over or #disaster #recovery instance of Nagios XI.

There are three main types of backup: full, incremental, and differential:

1. #Full backup. As the name suggests, this refers to the process of copying everything that is considered important and that must not be lost.

2. #Incremental backup. 

3. #Differential backup.

Read More



How to create bacpac file from SQL server

This article will guide you on how to export an existing #database into a #BACPAC file is through #SSMS. A bacpac is a dacpac + data, while a dacpac only contains the schema of the database.

To create a Bacpac file:

a. To #export a database using the Azure portal, open the page for your database and click Export on the toolbar.

b. Specify the BACPAC filename, select an existing Azure storage account and container for the export, and then provide the appropriate credentials for access to the source database.

c. Click OK.

To import from a BACPAC file into a new single database using the Azure portal:

1. Open the appropriate server page.

2. On the toolbar, select Import database. 

3. Select the storage account and the container for the BACPAC file and then select the BACPAC file from which to import.

Read More



How to modify MSSQL Database Autogrowth Configuration

This article will guide you on how #MSSQL Database Autogrowth Configuration works. Therefore do not rely on the default #SQL Server Data and Log file Autogrowth value and must always set it to more realistic values depending upon the usage of the database.

To see data file growth in SQL #Server:

1. Connect to a SQL instance and right-click on a database for which we want to get details of Auto Growth and Shrink Events. 

2. It opens the disk usage report of the specified #database. 

3. In this #disk usage report, we get the details of the data file and log file space usage.

To Change default database location via SQL Server Management Studio:

i. Right Click on Server and Select "Properties".

ii. In the "Server Properties" dialog box, navigate to "Database Settings" tab and data/log files location under "Database default locations" group. 

iii. Click on "OK" to apply changes.

Read More



Create a DigitalOcean Space and API Key

This article will guide you on the steps to create #DigitalOcean #Space and #API Key. You will also see the #server #URL, bucket name (or Space name), access key, and secret. With this information you can connect most any S3-compatible client or library to your new DigitalOcean Space!

Read More



Steps to install MySQL in Docker Container

This article will guide you on the steps to install and configure #MySQL in #Docker #container. MySQL is a well-known open-source relational #database management system and one of the most popular web server solutions. It stores and structures data in a meaningful manner, ensuring easy accessibility. Setting up a database in Docker is simply building a container based on a MySQL #image. 

To Set Up & Configure a MySQL Docker Container:

1. Running a MySQL Docker Container.

2. Installing a MySQL Docker Container.

i. Pull the MySQL Docker Image.

ii. Deploy the MySQL Container.

iii. Connect to the MySQL Docker Container.

3. Configure MySQL Container. Manage #Data Storage.

4. Start, Stop, and Restart MySQL Container.

5. Delete MySQL Container.

Read More



Backup MariaDB Databases to Linode Object Storage with Restic

This article will guide you on how to backup #MariaDB Databases to #Linode Object Storage which helps in restoration in the event of a server fault, a user #error, or a hacking or defacing of #website or #applications.

Read More



Last Restore Time of SQL server database

This article will guide you on how to collect #database restoration #history. The #SQL server database last restore time can be found using the system table in 'msdb'.
We get the following database #restoration history in my environment.
i. restore_date: It shows the database restoration #date.
ii. destination_database_name: We can get the destination database name using this #column.
iii. user_name: it gives user name that performed the restoration for that particular database.

Read More



How to install WordPress using One-Click Install on DigitalOcean

This article will guide you on the process to install #WordPress by using One-Click Install feature on DigitalOcean.
#DigitalOcean is a cloud hosting provider headquartered in New York City with data centers across the globe. Its seamless connectivity allows users to deploy and scale multiple web applications simultaneously without any lag. DigitalOcean offers private virtual Linux OS-powered machines called  ‘droplets’.

Read More



Working with Database Configuration in Laravel

This article will guide you on steps to set up #development and testing databases for Laravel by using database migrations and #seeders. Database migration means moving your data from one platform to another. To run #laravel migrations, first you have to configure your #database connection, and then you use Artisan, Laravel's #command line interface, to install the migrations table and run, revert, create. This command causes #Artisan to create a special table in your database to keep track of what #migrations have already been executed.

Read More



How to configure Redis as PHP Session Handler on Ubuntu 14 04

This article will guide you on the steps to configure Redis as a #PHP Session Handler.  #Redis is a powerful and fast key-value storage service. It can also be used as a #session handler for PHP, enabling scalable PHP #environments. Redis server can be used as a session handler for a PHP application running on Ubuntu and it is a data structure server. 

All of the data is stored in #RAM, so the speed of this system is phenomenal, often performing even better than #Memcached.

Redis is much more than a cache. But unlike a cache, Redis lets you operate on the values. There are 5 data types in Redis - Strings, Sets, Hash, Lists and Sorted Sets. Each data type exposes various #operations.

Read More



Installation and Configuration of ClamAV

This article will guide you on the steps to install #Clam #AntiVirus which is an open-source #antivirus tool to detect many types of #malicious #software, including #viruses. 

Read More



How To Connect to a Redis Database Different ways to do it

This article will guide you on the steps to connect to a #Redis #database using different commands like redis-cli using #commands.

Running redis-cli followed by a command name and its arguments will send this command to the Redis instance running on localhost at port 6379. You can change the host and #port used by redis-cli, just try the --help option to check the usage information.

Read More



Migrate data from Amazon S3 to DigitalOcean Spaces with rclone

This article will guide you on the steps to perform migration of data from #amazon #s3 to #DigitalOcean spaces. #Migration of #data is the primary task which #Website Administrators use for shifting from one object #storage service to another.

Read More



SQL server error 1101

This article will guide on the steps to resolve #SQL SERVER ERROR "1101 : Could not allocate a new page for database because of insufficient #disk space in filegroup".

You can make sure there is enough Hard Disk space where #database files are stored on #server and Turn on AUTOGROW for file #groups.

Read More



Types of SQL server backups

This article will guide you on the different types of SQL Server backups and how to use them to run #SQL Server #backups to safeguard our #databases from user #errors, media failure, #hardware failure, and so on.

A full database backup backs up the whole database. This includes part of the #transaction #log so that the full database can be recovered after a full database backup is restored.

Read More



Backup, Restore and Migrate a MongoDB database on CentOS 8

MongoDB is highly scalable, using shards. Horizontal scalability is a big plus in most #NoSQL databases. MongoDB is no exception. It is also highly reliable due to its replica sets, and the data is replicated in more nodes asynchronously.

This article will guide you on the steps to perform #backup, #restore and #migrate a #MongoDB #database on #CentOS 8.

Read More



Crashed Database Tables in Nagios XI

This article will guide you through the steps to fix Crashed #Database #Tables in #Nagios which occurs if the #MySQL process appears to be consuming large amounts of #CPU.

Read More



Recovering Zimbra LDAP database from backup

This article will guide you through the right steps to restore LDAP database from backup.

Read More



Steps to sync two Apache web servers

This article will guide you on how to setup syncing Apache web servers which involves a number of procedures such as installation and configuration of LSyncD, setting up Apache Configuration Replication, and so on.

Read More



Implementing SQL Constraints within Transactions

This guide will show you how SQL is can be used to defer constraints thin a transaction. If implemented correctly, the terminated transaction does not create any data that violates a constraint available to other transactions.

Read More



Recovering a database from suspect mode in SQL

This article will guide you through the process of repairing  a database which is in Suspect mode in SQL by performing consistency check on database in emergency mode and executing ALLOW DATA LOSS in single user mode.

Read More



MongoDB remote access configuration for Ubuntu

This article will guide you through the steps you can take to configure remote access for MongoDB on Ubuntu 18.04.

Read More



Using phpMyAdmin to manage Databases

With phpMyAdmin, the administration of the database is made easy by its user friendly interface.

Read More



how to solve cURL error 60 SSL certificate problem

How to fix cURL error 60 ssl certificate problem which occurs when cURL cannot find any valid certificate to communicate securely over https.

Read More



ioncube installation in Directadmin control panel

Steps taken to get ioncube loader installed in a Directadmin control panel.

Read More



Doing page level restore in SQL server

Best way to perform page level restore in SQL server.

Read More



Solution to error sql72045

How to fix error sql72045 as soon as possible.

Read More



Solution to Nagios access forbidden error 403

Most efficient way to fix Nagios access forbidden error 403.

Read More



Solve SQL server error 7416

Most sql users discover that the logins which they used before suddenly develops server error 7416.

Read More



Solve SQL Error 15421

We have dealt with numerous cases of SQL issues for our customers as part of our Server Support Services.

Read More



Solve phpMyAdmin Timeout error 1440 session

We have dealt with numerous cases of MySQL and phpMyAdmin Errors and support request from our customers regarding Databases related errors as part of our Linux Support Services.

Read More



How to fix Horde Fatal Error

Fatal Error in Horde Webmail is experienced by most users when they are about logging into their Email.

Read More



Fix CodeIgniter Error 404

An #Error 404 is very common and we have seen our customers complain about it in their #CodeIgniter application website. This error means that there is a an incorrect configuration in the server files. Errors in the .htaccess file as well as the application routes.php file can cause this.

Read More



Easy fix to SQL error 5023

From time to time, we do receive SQL related server bugs queries of which one of it was "SQL error 5023".

This SQL error is very catastrophic and it tends to disrupt the SQL server when it is trying to start up.

Read More