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
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
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