Tag: database

How To Install MySQL / MariaDB on Fedora 22

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at: MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB),…

Fixing WordPress Errors

Fixing WordPress Errors

Let’s face it. At some point, while running your WordPress site, you will run into issues and errors and may ultimately have to ask yourself… How Do I Fix My WordPress Site? A backup & restore may not resolve your issue, and a plugin may not display itself as the source of your problem, at…

Searching Through a Database with phpMyAdmin

Searching Through a Database with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin…

How to Install Nextcloud 15 on Ubuntu 18.04

How to Install Nextcloud 15 on Ubuntu 18.04

Similar to Dropbox and Google Drive, Nextcloud is self-hosting software that allows you to share files, contacts, and calendars. But, unlike Dropbox and Google Drive, your files will be private and stored on your server instead of a third party server. Nextcloud is HIPAA and GDPR compliant, so your files will be encrypted along with…

Installing SQL Express

Installing SQL Express

MSSQL Express 2017 on a Dedicated Server Microsoft SQL Server is a powerful database that is commonly used with ASP.NET and other website programming languages. However, licensing for MSSQL can be expensive and is sometimes prohibitive for smaller businesses and applications. Fortunately, Microsoft provides a free version of MSSQL server called MSSQL Express. Installing MSSQL…