MariaDB

ยปTag:MariaDB

How to Change Auto Increment Value of MySQL / MariaDB Database

Almost all database tables have a unique column which serves as identifier and has a value that auto_increment by database engine for each new record. The auto increment value is stored in the tables' schema of the [...]

By | 2017-08-06T08:53:01+00:00 August 6th, 2017|Categories: Databases|Tags: , |0 Comments

How to Get Current Auto_Increment Sequence Number for MySQL / MariaDB Table

Most tables in database have a column with auto increment sequence number that serves as unique identifier for the rows of data. The auto_increment value is always set to increase when new data is added to the [...]

By | 2017-08-06T08:50:56+00:00 August 6th, 2017|Categories: Databases|Tags: , , |0 Comments

SQL Command to List & Show All Databases in MySQL & MariaDB

mysql is a simple and easy to use SQL shell with input line editing capabilities that supports interactive and noninteractive use. The hard part of using mysql is that the administrator needs to remember the SQL command [...]

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

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 [...]

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

Upgrade MySQL to MariaDB 10 (Part 1 – Install MariaDB 5.5)

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 [...]

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

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 [...]

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

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

How to Backup and Restore (Export and Import) MySQL Databases Tutorial

phpMyAdmin can be used to export or backup MySQL or MariaDB databases easily. However, if the database size is very big, it probably won't be a good idea. phpMyAdmin allows users to save database dump as file [...]

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

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 [...]

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

Pin It on Pinterest