We’ve been running MySQL on our servers for years, this was a first for us. We ran into this issue recently where migrating a database from one server to another generated the following error on the target box: At some…
If you get this error when trying to connect to a remote MariaDB or MySQL server then don’t fret. The MySQL log file doesn’t provide any help either, we had the following in ours: The solution to the problem is…
We recently migrated a client website to a new server and encountered the following error when trying to import their database: ERROR 1118 (42000) at line 2663: Row size too large (> 8126). Changing some columns to TEXT or BLOB…
We recently needed to upgrade a server from MySQL 5.7 to MariaDB 10.3 and one of the key steps in doing so is to disable strict mode after the upgrade. By default, MariaDB enables strict mode from version 10.2 and…
We’re running cPanel with MariaDB 10.2 on one of our servers and during a complete database dump we ran into this error: mysqldump: Got error: 1356: “View ‘sys.host_summary’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack…
We noticed load on one of our production servers recently and had to enable slow query log for our MariaDB server. Since this was a server in production, we feared that if we tried restarting the MariaDB server that it…
Today we’ll look at how to backup your MySQL databases. It’s a good idea to backup your databases on a regular basis so ]you have a working ‘good’ copy in the event of data loss due to failure or if…