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...
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...
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...
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 = /...
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 ) //...
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:...
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...
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/...
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’...
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...