Skip to main content


Showing posts from August, 2018

MySQL to 8.0.11 in place upgrade

MySQL in place upgrade from 5.6.11 to 8.0.11:   01. Install MySQL 5.7 latest version on MySQL database server such as 5.7.22. 02. Initialize MySQL     mysqld --defaults-file=/etc/my.cnf --initialize-insecure & 03. Start MySQL daemon     mysqld --defaults-file=/etc/my.cnf & 04. Configure systemd to start and stop Mysql daemon       * Shutdown mysqld           mysqladmin -uroot -S/var/lib/mysql/mysql.sock shutdown        * Edit file /usr/lib/systemd/system/mysqld.service and add following         [Service]         PIDFile=/var/lib/mysql/         ExecStart=/usr/sbin/mysqld --defaults-file=/etc/my.cnf --daemonize --pid-file=/var   /lib/mysql/ $MYSQLD_OPTS       * sudo systemctl daemon-reload       * sudo systemctl start mysqld       * sudo systemctl enable mysqld    05. Get MySQL dump from source server using following command     mysqldump -uroot –p<passwrod> --databases <db_name> > /tmp/bkup.sql 06. Restore MySQL dump of 5.6.11 to 5.7.22     my