Databases

»»Databases

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+00:00 December 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+00:00 December 9th, 2016|Categories: Databases|Tags: |1 Comment

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+00:00 January 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+00:00 January 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+00:00 January 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+00:00 December 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+00:00 December 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+00:00 December 9th, 2016|Categories: Databases|Tags: , |19 Comments

How to Remove and Drop Datafiles from Tablespace in Oracle Database

Oracle RDBMS databases stores data logically in the form of tablespaces and physically in the form of data files. The datafiles are added to the tablespaces as database space requirement grows bigger. However, there are several reasons [...]

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

Pin It on Pinterest