When i try to repair a crashed database table, i get error Check the table with myisamcheck It reported some
I had to restore a large MySQL backup file. When restoring one of the table resulted in error. To debug
This bash script is used to auto-restart MySQL or MariaDB database if it crashes or stops for any reason. Create
To find size of database using SQL command, run following SQL in MySQL promt. Example FInd disk usage by tables
When trying to restore a database backup to Managed DigitialOcean MySQL 8 database, i get following error This is because
When restoring a MySQL database, i get error I installed exactly same MraiaDB version on both source and destination server.
After upgrading MariaDB on Ubuntu server, i got following error Users created worked fine. Only root user had this error.
To initialize MySQL data directory, run This will create /var/lib/mysql dirrectory. For some version of MySQL you can use Example
To change MySQL database char set and collation, run To usee current char set and collation, run You can specify
On an Apache server, MySQL can’t connect when you use localhost, but it work when you chane to IP address
When restoring MySQL backup taken on Amazon RDS, i get error To fix this, open db.sql in text editor, remove