JIYIK CN >

Backing up MySQL isn't hard—you just run mysqldump and output to a file —but it's also not really designed for a production environment. At first, running mysqldump took only a few seconds so everything being locked wasn't a big deal, b...

Kubernetes support for stateful applications has matured considerably over the past few years. It is now possible to co-locate your database within your cluster, allowing it to benefit from the same scalability as your other workloads. MySQ...

There are many reasons why we would want to restore a database from a backup file... but we should also test it on a test server to make sure our database backup is working properly. The syntax is as follows: mysql -h hostname -u username -...

Comma-separated value files ( CSV ) are a way to transfer data between applications. Databases such as MySQL and spreadsheet software such as Excel both support importing and exporting via CSV , so we can use CSV files to exchange data betw...

Backing up your database is a very important system administration task that should usually cron be run from a job at scheduled intervals. We will use mysqldump the dump utility that comes with mysql to dump the contents of the database to...

In this article, we will learn how to find error logs in MySQL database. Businesses and organizations must have access to error files in MySQL as it helps them to evolve and strengthen their database management system through efficient quer...

In this article, we aim to explore different ways to check the strings contained in a MySQL table. We will introduce the following technologies in MySQL. INSTR function LOCATE function LIKE Operators Before we get started, however, we creat...

In this article, we aim to explore the concept of finding entries in a table in MySQL based on conditions associated with dates. Most of the businesses and organizations using MySQL for data analysis or visualization need to sort or fetch d...

In this article, we aim to explore how to get the column names of a specific table in MySQL database. Often, when working with data in MySQL, we tend to forget the column names of a particular table in the database and the data types of dif...

The purpose of this article is to explore different ways to create a copy of a table in MySQL. The source table is also called the table to be copied, and the target table is called the clone table, which can be from the same or a different...

In this article, we aim to explore different ways to rename columns in MySQL. ALTER TABLE The command is mainly used to change the format of a given MySQL table. It can be used to add columns, change the data type within a column, delete co...

This article highlights different ways to check if a row exists in a MySQL table. We will use the EXISTS and NOT EXISTS operators. We can also use these two operators with IF() the function to get a meaningful message if a row (a record) is...

Today I will show you how to truncate all tables in Mysql. It is used when you want to delete the entire table TRUNCATE TABLE . TRUNCATE It is a type of DML statement, which means it cannot be rolled back once it is committed. There are two...

In this article, we aim to explore different ways to create temporary tables in MySQL. One of the main features of temporary tables is that it helps in storing temporary data. This feature is enabled in MySQL 3.23 and later versions. These...

In this article, we aim to understand how to create a table from CSV in MySQL database. Businesses and organizations must quickly generate tables from large amounts of data. These organizations typically have large CSV files with large amou...