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/mysql.pid ExecStart=/usr/sbin/mysqld --defaults-file=/etc/my.cnf --daemonize --pid-file=/var /lib/mysql/mysql.pid $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
Welcome to explore technology about Kubernetes, MySQL, Machine Learning | Deep Learning - Shrenik Parekh