If you are using the MySQL database and you encounter an error like table is marked as crashed and last repair failed ?If this is the case this article will help you to fix it.This error can occur due to many reasons for instance, zero disk space on the server, difficult server reset, compelled MySQL ..
Category : Databases
Restoring a single database from a full dump is pretty easy, using the mysql command line client’s –one-database option: But what if you don’t want to restore the database, you just want to extract it out of the dump file? Well, that happens to be easy as well, thanks to the magic of sed: You ..
MariaDB is an open-source database engine system, commonly used.This tutorial will explain how to install MariaDB on a Debian server, and verify that it is running and has a safe initial configuration. Step 1 — Instalation Lets start this by updatings our repositories and install the package, and for that we will use the apt ..
TimescaleDB is one extension of PostgreSQL that uses time series under a SQL DB.Today we will explain how to install Zabbix 5.0 using TimeScaleDB extension that is very eficeient in terms of History Syncer e housekeeper. Start by download the package that will provide us the repositories to install zabbix from apt. Next install the ..
Here are some basic operations with the MySQL server. SQL Statements explains in detail the rich syntax and functionality of the SQL statements that are illustrated below. Showing existing databases. Use a SHOW DATABASES statement: Creating a new database. Use a CREATE DATABASE statement: Check if the database has been created: Creating a table inside ..
Imagine you need to create a new database for some project like a simple blog, and you plan to do that with MySQL. So, in that case all you need is to install MySQL/MariaDB and, after MySQL server is up and running, you can connect to it as the superuser root with the mysql client ..
In WordPress, there is more than one way to reset your password.The one that we are going to explain here today is by setting a new password directly in MySQL Worpress database. First access your wordpress website files and find a file config.php.inc.Inside this file you will find the username the password the database name ..
Installing and Configuring Redis In order to get the latest version of Redis, we will use apt to install it from the official Debian repositories.Update your local apt package cache and install Redis by typing: This will download and install Redis and its dependencies.Open this file with your preferred text editor: Inside the file, find ..
Recent Comments