Are you a 🤖?

MySQL

35 articles

MySQL is an open-source relational database management system. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data.

It’s free and open-source software under the terms of the GNU License, and is also available under a variety of proprietary licenses.

image 34 - MySQL: 5 ways to move data from huge ibdata file to .ibd files

MySQL: 5 ways to move data from huge ibdata file to .ibd files

ibdata file is used to store all tables of databases that use the innoDB engine, so if you delete it, you will lose all data. To keep each database files in a separate file add innodb_file_per_table in your my.cnf file under [mysqld] section. Here...

MobaXterm Personal 20.3 yNKz86a65v - [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables

[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with –with-aria-tmp-tables

MariaDB failed to start outputing this error: [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with –with-aria-tmp-tables to fix this move the aria_log_control file: mv...

MobaXterm Personal 20.3 P3fxw9aqzL - Lost connection to MySQL server during query - Assertion failure: ddl0buffer.cc:204:ptr

Lost connection to MySQL server during query – Assertion failure: ddl0buffer.cc:204:ptr

When importing a dump file from MariaDB to MySQL the following error appears and forces MySQL service to restart: ERROR 2013 (HY000) at line 2286533: Lost connection to MySQL server during query error in MySQL error log file: 2022-02-02T12:07:43...

mysql backup script - Shell Script to Backup All MySQL databases

Shell Script to Backup All MySQL databases

Here is a simple bash script that I use to backup all mysql databases from the server: #! / bin / bash TIMESTAMP = $ (date + "% F") //backups will be stored in /backup/mysql BACKUP_DIR = "/ backup / mysql" MYSQL = / usr / bin / mysql MYSQLDUMP = /...

remove script - Remove shell script after usage

Remove shell script after usage

Here is a small script that does two things: Determinate script’s locationDelete the file #!/usr/bin/env bash // determinate where the script is SCRIPT_DIR=$( cd -- "$( dirname -- "${BASH_SOURCE[0]}" )" &> /dev/null && pwd ) //...

chrome qEwlKegO7Y - How to fix Failed to start MariaDB error "Failed at step NAMESPACE spawning /bin/sh: Invalid argument"

How to fix Failed to start MariaDB error “Failed at step NAMESPACE spawning /bin/sh: Invalid argument”

Recently on a VPS running Cyberpanel, MariaDB service failed with the error: Failed at step NAMESPACE spawning / bin / sh: Invalid argument For VPS based on the openvz that are using old kernel you need to edit the service file to fix the problem:...

my cnf 868x601 1 - MySQL connections work only with localhost and not 127.0.0.1

MySQL connections work only with localhost and not 127.0.0.1

Recently encountered a strange issue on client VPS that MySQL connections were working only when using localhost and not with 127.0.0.1 This was due to the fact that the client had enabled skip_name_resolve in his my.cnf file which...

notepad 23Z4fPgsFR - Different Ways to Check MySQL version in cPanel or Linux

Different Ways to Check MySQL version in cPanel or Linux

By far MySQL is the most popular Relational database management system and knowing which MySQL version you are running can be important in some situations. Here are different ways to check the version of the MySQL server installed on your WHM/...

Cover Image by MilesAndryPrower on DeviantArt

MySQL Database Vulnerability Scanning

Here is how to check MySQL databases for malware: Open up PHPMyAdminLook for anything ‘weird’ It’s that simple. What’s ‘weird’ you ask? Well, anything that’s ‘not supposed to be in the database’...

what is php 3 1 - Tip: Storing MD5 Values (and other string/binary representations)

Tip: Storing MD5 Values (and other string/binary representations)

A common occurrence I have noticed in MySQL apps is that MD5 values are stored as 32 byte values rather than 16. Just to ‘rehash’, an MD5 value is a 16 byte hexadecimal value, typically used as a unique fixed-length signature of a...