Seeing 930.44 kB (204.8 kB loaded when loading a large database table in PHPStorm
Symptoms You’re looking at a database table in PHPStorm but all the records are not showing. The only clue you have is the words 930.44
Databases
What is the listen port network interface for MySQL and how can you change it?
Port Number The port number for MySQL is TCP port 3306. See where it’s listening How can you see if it’s listening on more than
How to backup and restore a MySQL database from the command line
Backing Up To backup a MySQL database from the command line, use the mysqldump command and pip the output to a file. For example: mysqldump
How to log queries in real time using MariaDB/MySQL
Background You have some sticky queries but you can’t see what’s happening. On certain website actions pages are just slow and you fully suspect the
How to upgrade for MariaDB 5.5 to 10.1 and then to 10.3
You might encounter a situation (e.g. on AWS) where you have a new CentOS 7 server, but an old version of MariaDB 5.5 on the
MySQL stops working: InnoDB: Fatal error: cannot allocate memory for the buffer pool
Background A MySQL server stop working. You’re confused as this is a new Virtualmin installation and everything went smooth. You start troubleshooting: # service mariadb
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