MySQL Can’t create new tempfile

MySQL Can’t create new tempfile

When i try to repair a crashed database table, i get error Check the table with myisamcheck It reported some

MySQL

Split mysqldump backup file into tables

I had to restore a large MySQL backup file. When restoring one of the table resulted in error. To debug

MySQL

Auto Restart MySQL if Crashed

This bash script is used to auto-restart MySQL or MariaDB database if it crashes or stops for any reason. Create

Find MySQL Database and Table Size

Find MySQL Database and Table Size

To find size of database using SQL command, run following SQL in MySQL promt. Example FInd disk usage by tables

MySQL ERROR Unable to create or change a table without a primary key

MySQL ERROR Unable to create or change a table without a primary key

When trying to restore a database backup to Managed DigitialOcean MySQL 8 database, i get following error This is because

ERROR 1118 Row size too large  Changing some columns to TEXT or BLOB may help.

ERROR 1118 Row size too large Changing some columns to TEXT or BLOB may help.

When restoring a MySQL database, i get error I installed exactly same MraiaDB version on both source and destination server.

MariaDB ERROR 1524  Plugin unix_socket is not loaded

MariaDB ERROR 1524 Plugin unix_socket is not loaded

After upgrading MariaDB on Ubuntu server, i got following error Users created worked fine. Only root user had this error.

MySQL Initialize Data Directory

MySQL Initialize Data Directory

To initialize MySQL data directory, run This will create /var/lib/mysql dirrectory. For some version of MySQL you can use Example

MySQL

MySQL Database Character Set and Collation

To change MySQL database char set and collation, run To usee current char set and collation, run You can specify

MySQL cannot connect via localhost

On an Apache server, MySQL can’t connect when you use localhost, but it work when you chane to IP address

MySQL

MySQL ERROR 1193 Unknown system variable GTID_PURGED

When restoring MySQL backup taken on Amazon RDS, i get error To fix this, open db.sql in text editor, remove

MySQL create database

MySQL create database

To create a database, you can use Example To create a database with specific charset use Or You can use