MySQL

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.

www.mysql.com

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...

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 ) //...

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’...