MariaDB: Webmin MySQL Startup Script /etc/rc.d/init.d/mysqld Was Not Found

MariaDB, the enhanced in-place upgrade of MySQL database management system, is getting more popular each passing day. We decide to upgrade from MySQL, which comes preinstalled in CentOS, to MariaDB 5.5, and subsequently to MariaDB 10, the [...]

By |2016-12-09T08:39:14+08:00December 9th, 2016|Categories: Databases|Tags: , , , , , , , |0 Comments

Convert PostgreSQL Template0 & Template1 Encoding to UTF8 (SQL_ASCII Incompatible)

After installing Odoo 8 (also known as OpenERP), and other web apps which runs on PortgreSQL databases, you'll be asked to create a new database for your company. However, when creating the database, Odoo returns the following [...]

By |2016-12-09T08:39:14+08:00December 9th, 2016|Categories: Databases|Tags: |2 Comments

Optimize SQL Server 2000 / 2005 / 2008 in Large RAM System by Locking Pages in Memory and AWE

Microsoft SQL Server is a data-intensive and disk I/O (read and write) intensive database management systems. For SQL Server which is running on a system with large amount or big size of physical RAM memory, such as [...]

Error Has Occurred While Establishing A Connection To SQL Server 2005 / 2008 / 2012 / 2014 Which Does Not Allow Remote Connections

When connecting to an instance of Microsoft SQL Server 2005 or Microsoft SQL Server 2008, Microsoft SQL Server 2012 or Microsoft SQL Server 2014 database, including SQL Server Express, Standard, Web, Workgroup, Business Intelligence, Developer and Enterprise [...]

Oracle PL/SQL ORA-00947 Not Enough Values Error

In Oracle database, the following error message may appear when an incorrect SQL statement is used, in SQL Plus or in anywhere that send SQL queries to the databases such as stored procedure or external programs. PL/SQL: [...]

By |2017-01-11T16:38:26+08:00January 11th, 2017|Categories: Databases|Tags: |1 Comment

Uninstall and Remove Multiple Database Instances of Microsoft SQL Server 2005

When database system administrator installs Microsoft SQL Server 2005 and creates a few database engine instances, there will be problem and hard time to remove and uninstall these multiple database instance components and the corresponding SQL Server [...]

By |2017-01-10T22:47:38+08:00January 10th, 2017|Categories: Databases|Tags: , |7 Comments

How to Read MySQL Binary Log Files (BinLog) with mysqlbinlog

MySQL database server generates binary log files for every transaction to the databases, provided administrator does not disable or comment out the "log-bin" parameter in my.cny configuration file. The binary log files are written in binary format. [...]

By |2017-01-08T00:43:43+08:00January 8th, 2017|Categories: Databases|Tags: , |9 Comments

Check and Optimize MySQL Database Automatically with Crontab/Cron

MySQL is a very popular free yet powerful database system. But even in great databases, the tables may get fragmented with overhead due to continuous update, or delete and insert operation on data stored in database. Beside, [...]

By |2016-12-09T08:39:19+08:00December 9th, 2016|Categories: Databases|Tags: |11 Comments

How to Rename or Move Oracle Tablespace Datafile to Another Location

Oracle database does not provide an easy user interface to rename a datafile of tablespace, nor database administrator can easily move or relocate the datafile to another location or directory that different from original location on creation [...]

By |2016-12-09T08:39:39+08:00December 9th, 2016|Categories: Databases|Tags: , |2 Comments

How Drop Tablespace and Recover Oracle Database When Accidentally Delete Datafile

Accident may happens, even though it's costly one. This is especially the case in Oracle database, which stores the database objects physically in data files on hard disk. Fast hand administrators may accidentally delete some of the [...]

By |2016-12-09T08:39:39+08:00December 9th, 2016|Categories: Databases|Tags: , |19 Comments