How to upgrade MariaDB from 10.1 to 10.3 Ubuntu Bionic (18.04) LTS Server
Background This article explains how to upgrade the default MariaDB 10.1 installation provided with Linux Mint 19 Tara or Tessa to MariaDB 10.3. One reason
Databases
How do you alter a MySQL table to make a column nullable?
Do this: <span class="kwd" style="font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; box-sizing: inherit; color: #101094;">ALTER</span> <span class="kwd" style="font-style:
How to backup a MySQL database using the command line
The syntax is straightforward: mysqldump -uusername -ppassword database_name > db.backup.date
Backups Failing: …tables used by Event Scheduler were found damaged at server start (1577)
On your MySQL Server doing backups you get: Backups Failing: Dumping MySQL database database_name …. dump failed! mysqldump: Couldn’t execute ‘show events’: Cannot proceed because
Communication link failure: 1153 Got a packet bigger than ‘max_allowed_packet’ bytes (SQL: update…
Whilst updating a Trix Editor field box with many images, you get the following error: [2019-01-18 10:12:07] local.ERROR: SQLSTATE[08S01]: Communication link failure: 1153 Got a
Could not create the upgrade info file ‘/var/lib/mysql/mysql_upgrade_info’ in the MariaDB Servers datadir, errno: 13
Whilst doing this: mysql_upgrade -uusername -ppassword You get this: Could not create the upgrade info file ‘/var/lib/mysql/mysql_upgrade_info’ in the MariaDB Servers datadir, errno: 13 Solution:
How to rename a MySQL database
Apparently long ago there was a rename database command but this was dropped for security reasons. Now you have to do this: for table in
How do you rename a MySQL table?
rename table t1 to t2; Reference: https://blog.marceloaltmann.com/en-how-to-rename-table-in-mysql-pt-como-renomear-tabelas-no-mysql/
How to cluster / set up MySQL for redundancy
MySQL has two good methods for replication, the one called Master-Master Replication, and the other called Group Replication. Group replication is more powerful and is
Help! I’m getting access denied trying to access a remote / local MySQL database
Sometimes when you try to access MySQL, you will get an access denied message. There could be a multitude of reasons but if you are