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 add database access to MySQL from a remote host using Virtualmin
This article explains how to add remote access to a Virtualmin host so that the end-user can access their MySQL database. Go to Virtualmin Choose
How to troubleshoot ‘Call to undefined function mysql_connect’
Whilst loading a webpage, you get a server 500 error. You examine the log file, and find something like: [Wed Aug 08 13:28:27.449630 2018] [fcgid:warn]