ยปTag: MariaDB

Upgrade MySQL to MariaDB 10 (Part 2 – Upgrade MariaDB/MySQL 5.5 to Version 10.0)

MariaDB is a relational database management system (rDBMS) that was forked from MySQL, the de-facto database for most popular open-source web platform and apps. MariaDB is intended as the enhanced drop-in replacement for MySQL, so that developers [...]

Virtualmin: You Do Not Have Access to This MySQL Database After Changing Password

After changing password of MySQL or MariaDB administration user, such as root, Virtualmin no longer has access to the database of the virtual servers. When attempting to manage database of a virtual server via "Edit Databases," Virtualmin [...]

Duplicate, Copy or Backup Tables in MySQL, MariaDB, Oracle, PostgreSQL, DB2 and SQLite with Create Table As SQL

In Oracle, PostgreSQL, DB2, MySQL, MariaDB and SQLite database system, there is a nice command feature called Create Table As which allows easy duplicating of a table with data from another or a few other tables. The [...]