MySQL

To initialize the MySQL data directory, run This will create /var/lib/mysql directory. For some versions of … MySQL Initialize Data DirectoryRead more

After upgrading MariaDB on Ubuntu server, i got following error root@server:~# mysql ERROR 1524 (HY000): Plugin … MariaDB ERROR 1524 Plugin unix_socket is not loadedRead more

When restoring a MySQL database, i get error root@server:~# mysql production < db.sql ERROR 1118 (42000) … ERROR 1118 Row size too large Changing some columns to TEXT or BLOB may help.Read more

When trying to restore a database backup to Managed DigitialOcean MySQL 8 database, i get following … MySQL ERROR Unable to create or change a table without a primary keyRead more

To find the size of databases using SQL command, run the following SQL in MySQL prompt. … Find MySQL Database and Table SizeRead more

This bash script is used to auto-restart MySQL or MariaDB database if it crashes or stops … Auto Restart MySQL if CrashedRead more

I had to restore a large MySQL backup file. When restoring one of the table resulted … Split mysqldump backup file into tablesRead more

When i try to repair a crashed database table, i get error mysql> repair table visitorstats_sessions; … MySQL Can’t create new tempfileRead more

When using systemctl, you can set value for open_files_limit in my.cnf file. Default installation of MariaDB … MariaDB Change Open Files LimitRead more

To reset MySQL root password on Bitnami server, first check MySQL server version you are running. … Reset MySQL root password on Bitnami serverRead more