Install MySQL 5.7 on Ubuntu 20.04 Rumi, January 9, 2024 Prerequisites Linux servers running Ubuntu 20.04 root privileges Step 1 – Add MySQL APT repository in Ubuntu Ubuntu already comes with the default MySQL package repositories. In order to add or install the latest repositories, we are going to install package repositories . Download the repository using the below command:… Continue Reading
Delete/Purging mysql-bin (binlog) files safely Rumi, January 7, 2021 The file mysql-bin.index keeps a list of all binary logs mysqld has generated and auto-rotated. The mechanisms for cleaning out the binlogs in conjunction with mysql-bin.index are: PURGE BINARY LOGS TO ‘binlogname’; PURGE BINARY LOGS BEFORE ‘datetimestamp’; These will clear all binary logs before the binlog or timestamp you just… Continue Reading
Installing MySQL on Debian Rumi, September 26, 2020 Step 1 – Prerequisites Login to your Debian 9 system using shell access. For remote systems connect with SSH. Windows users can use Putty or other alternatives applications for SSH connection. ssh root@debian9 Run below commands to upgrade the current packages to the latest version. sudo apt update sudo apt… Continue Reading
Install Mysql Client on Debian 10 (Buster) Rumi, August 6, 2020 Debian stopped packaging mysql-client as of buster. You can use apt-get install default-mysql-client Which will install mariadb-client-10.3. MariaDB is a fork of MySQL. The client can still be started with the command mysql. Continue Reading
How to increase memory size for MySQL Server Rumi, June 14, 2020June 14, 2020 To increase the memory size for a MySQL Server, follow these steps: 1.Enter management mode by typing your password and pressing Enter twice. Select Exit to terminal using the arrow keys and then press Enter 2.Type: nano /etc/my.cnf 3.Locate the line innodb_buffer_pool_size = 1024M and change the number to 50%… Continue Reading
Percona Mysql Service Force Stop Rumi, June 10, 2020 Service mysql stop is being ignored. How to fix? Try mysqladmin -u root -p shutdown Alternatively, In case you have started /etc/init.d/mysql bootstrap-pxc So in this case you should stop bootstrapped node using /etc/init.d/mysql bootstrap-stop Continue Reading
How To Install MySQL on Debian 9 (Stretch) with version selection Rumi, May 17, 2020May 17, 2020 Step 1 – Prerequisites Login to your Debian 9 system using shell access. For remote systems connect with SSH. Windows users can use Putty or other alternatives applications for SSH connection. ssh root@debian9 Run below commands to upgrade the current packages to the latest version. sudo apt update sudo apt… Continue Reading
Large Database Import Progress Using PV Rumi, March 24, 2020 PV can report progress for large data imports. In this example I will use a large (7 G) install on Ubuntu. First, download PV (http://linux.die.net/man/1/pv) sudo apt-get install pv A traditional mysql import may be formatted as: mysql -u USER -p DATABASE_NAME < DUMP.mysql but to leverage PV, pass the dump file ,then pipe the… Continue Reading
Fixing phpmyadmin login on MySQL 5.7 and Debian 9 Rumi, May 4, 2018 Once setting up the LAMP stack, you must be wondering to see that you no longer been able to login phpmyadmin using root credentials. MySQL 5.7 changed the secure model: now MySQL root login requires a sudo (while the password still can be blank). I.e., phpMyAdmin will be not able… Continue Reading
Error 2020: Got packet bigger than ‘max_allowed_packet’ bytes when dumping table `migrations` at row: 1 Rumi, April 26, 2018 You can add –max_allowed_packet=512M to your mysqldump command. Or add max_allowed_packet=512M to [mysqldump] section of your my.cnf Note: it will not work if it is not under the [mysqldump] section… Continue Reading