MySQL, MariaDB Backup and Restore Step by Step
Muhammad Anwar
March 29, 2020
MySQL and MariaDB include a built-in backup utility that simplifies the process to create a backup of a database. With mysqldump , you can...
Results for
MySQL
Set Up a Highly Available MySQL Replication Cluster on Ubuntu, Debian
Muhammad Anwar
March 02, 2020
Database clustering is particularly useful for highly active website and application. With replication, at least two or more MySQL servers ...
Set Up a Help Desk System using osTicket on Ubuntu 19.04
Tech Support
July 19, 2019
osTicket is a widely-used open source help desk system. It seamlessly integrates inquiries created via email, phone and web-based forms into...
Set Up Asset Management using OCS Inventory on Ubuntu 18.04
Tech Support
July 05, 2019
Open computers and software inventory is an assets management solution. OCS Inventory queries its agents to know the soft and hard composit...
Set Up a Help Desk System using osTicket on Ubuntu 18.04
Tech Support
July 03, 2019
osTicket is a widely-used open source help desk system. It seamlessly integrates inquiries created via email, phone and web-based forms int...
Secure MySQL Remote Access with SSL/TLS on Ubuntu 18.04
Muhammad Anwar
May 22, 2019
MySQL by default is configured to only accept local connections, or connections that initiate from the same machine where MySQL is installed...
Set Up LEMP Stack (Linux, Nginx, MySQL, PHP) on Ubuntu 19.04
Muhammad Anwar
April 16, 2019
The LEMP software stack is a group of software that can be used to serve dynamic web pages and web applications. This is an acronym that de...
Set Up LAMP Stack (Linux, Apache, MySQL, PHP) on Ubuntu 19.04
Muhammad Anwar
April 16, 2019
A LAMP Stack is a group of open-source software that is typically installed together to enable a server to host dynamic websites and web ap...
How To Set Up Laravel, Nginx, and MySQL using Docker Compose on Ubuntu 18.04
Muhammad Anwar
November 19, 2018
This tutorial will take you through the steps to set up Laravel framework, with Nginx as the web server and MySQL as the database, everythi...
How To Set Up LEMP Stack (Linux, Nginx, MySQL, PHP) on Debian 9
Muhammad Anwar
September 24, 2018
The LEMP Stack is a group of software that can be used to serve dynamic web pages and web applications. This is an acronym that describes a...
How to Set Up a Multi-Node MySQL High Availability Cluster on Ubuntu 18.04
Muhammad Anwar
August 27, 2018
The MySQL Cluster distributed database provides high availability and throughput for your MySQL database management system. A MySQL Cluster...
Install Nginx, MySQL, PHP (LEMP Stack) on Ubuntu 18.04
Muhammad Anwar
May 24, 2018
The LEMP software stack is a group of software that can be used to serve dynamic web pages and web applications. This is an acronym that de...
How To Install and Secure MySQL on Ubuntu 18.04
Muhammad Anwar
May 07, 2018
MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) ...
Install Apache, MySQL, PHP (LAMP Stack) on Ubuntu 18.04
Muhammad Anwar
April 30, 2018
A "LAMP" stack is a group of open source software that is typically installed together to enable a server to host dynamic webs...
How To Set Up a Complete Web Hosting Solution on an Ubuntu 16.04 Server
Muhammad Anwar
December 07, 2017
This tutorial will walk you through the steps to set up an Ubuntu 16.04 a complete web hosting server with Apache2, Postfix, Dovecot, Bi...
How To Install Linux, Apache, MySQL, PHP (LAMP) Stack on Ubuntu 17.10
Muhammad Anwar
November 23, 2017
This tutorial will walk you through the steps to set up a LAMP on an Ubuntu 17.10. LAMP Stack is a group of open source software that is...
Import and Export Databases in MySQL or MariaDB
Muhammad Anwar
January 02, 2017
For database administrators, import and export database is an important skill to have. Data dumps can be used for backup and restoratio...
How to Create MySQL Cloud Service on Oracle Cloud
Muhammad Anwar
November 24, 2016
The Oracle MySQL Cloud Service let you quickly deploy MySQL databases on the Oracle Public Cloud. This guide will walk you through the...
Maximum identifiers in Oracle Database 12c Release 2 (12.2)
Muhammad Anwar
November 24, 2016
Oracle database 12c Release 2 (12.2) increases the maximum size of most identifiers from 30 to 128 bytes, which makes migration possib...
How to Set Up MySQL on Ubuntu 16.04
Muhammad Anwar
November 24, 2016
MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Pe...
Subscribe to:
Posts
(
Atom
)