Category: MySql
-
MySQL – Install(5.7) and Upgrade to (8.0.31) in Ubuntu 18.*
Installing MySQL in Ubuntu OS is very easy, you just need to follow 3 steps. Update, Install MySQL CE Server and Configure.
-
Install MySQL 5.7 Community Server Using RPM Bundle- CENTOS 7
To Install MySQL 5.7 we have To options. You can Download the RPM Or bundle Tar file from https://dev.mysql.com/downloads/repo/yum/ https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.9-1.el7.x86_64.rpm-bundle.tar – For 5.7 https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.30-1.el7.x86_64.rpm-bundle.tar for 8.0 Few Useful links to Download your desired Version. https://dev.mysql.com/downloads/repo/yum/ https://downloads.mysql.com/archives/community/ Install the Downloaded Packages/RPM Using Local-Install Option. Get the Temporary root password from /var/log/mysqld.log. You can either change the…
-
Upgrade MySQL Server from 5.7 to 8 CentOS 7 Linux
Quote from Mysql Website Upgrade Paths Reference: https://dev.mysql.com/doc/refman/8.0/en/upgrade-paths.html Download the Required RPM and place them in the Server. Take the Backup of all the Databases and stop the MySQL Service. Run the Following from Local Directory using yum localinstall mysql-community-{server,client,common,libs}-* This completes the Upgrade from 5.7 to 8.0(Or Latest) Start the Service again and verify.…
-
MySQL Load Data Statement – Performance
As mentioned in the MySQL Documentation here https://dev.mysql.com/doc/refman/8.0/en/load-data.html , The LOAD DATA statement reads rows from a text file into a table at a very high speed. The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. LOCAL also affects data interpretation and error handling. Lets Run a Quick Test…
-
Error using MySQL Workbench – unhandled exception list index out of range.
While Loading the data using MySQL Workbench, you may hit the error unhandled exception list index out of range There are no clues in the workbench log files, in such cases you can load the Data Using MySQL LOAD DATA Statement . Which will load the data very fast and without errors. mysql> LOAD DATA…
-
Install MySQL 8 Community Server (mysql-community-server) on Azure VM(IAAS) Linux 8 CentOS
Download and Add MySQL Yum Repository. wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm Install the downloaded release package. yum localinstall mysql80-community-release-el8-1.noarch.rpm You can check that the MySQL Yum repository has been successfully added by the following command (If Yum Is not available, you can use dnf , instead.) yum repolist enabled | grep “mysql.-community.” Installing MySQL Linux 8 includes a…
Sriram Sanka 