Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
MySQL Articles
Page 25 of 355
Entering MySQL Queries
Before entering queries on the console, it is important to ensure that the user is connected to the server. The below query would give the version number of the server being used, and the current date.mysql> SELECT VERSION(), CURRENT_DATE;Note: The function ‘VERSION()’ and ‘CURRENT_DATE’ are case−insensitive. This means ‘version()’, ‘Version()’, ‘vERsion()’, all mean the same. Same goes with ‘CURRENT_DATE’An SQL query is followed by a semi-colon.When a query is issued to mysql, it sends the query to the server for execution. The results are computed and displayed. Another ‘mysql>’ also gets printed, indicating that the server is ready for one ...
Read MoreUpgrading MySQL with the MySQL SLES Repository
MySQL can be upgraded using MySQL SLES repository. Let us see the steps required for this upgradation. By default, the MySQL SLES repository updates MySQL to the latest version in the release series that the user would have chosen during installationTo update to a different release series, the subrepository for the series that has been selected needs to be disabled. It is suggested to upgrade from one series to the next, instead of skipping a series. Inplace downgrading of MySQL is not supported while using MySQL SLES repository.Upgrade MySQLUpgrade MySQL and its components using the below command −shell> sudo zypper ...
Read MoreUpgrading MySQL with the MySQL APT Repository
The MySQL APT repository can be used to perform an in-place upgrade for the MySQL installation.It can be done using the below steps −Upgrade MySQLEnsure that MySQL APT repository is already present on user’s system's repository list.Ensure that the most up−to−date package information on the MySQL APT repository is present by running the below command −shell> sudo apt-get updateBy default, the MySQL APT repository updates MySQL to the release series that has been selected by the user when they add the MySQL APT repository to their system.In general rule, it is suggested to upgrade from one release series to another, ...
Read MoreUpgrading MySQL with the MySQL Yum Repository
Let us understand how to upgrade MySQL with the help of MySQL Yum repository −MySQL can be upgraded using MySQL Yum repository. Let us see the steps required for this upgradation. By default, the MySQL Yum repository updates MySQL to the latest version in the release series that the user would have chosen during installationTo update to a different release series, the subrepository for the series that has been selected needs to be disabled. The next step is to enable the subrepository for the target series. It is suggested to upgrade from one series to the next, instead of skipping ...
Read MoreUpgrading MySQL on Windows
MySQL can be upgraded on Windows using two methods. They have been listed below −Using MySQL installerUsing Windows ZIP archive distributionUpgrading MySQL with InstallerMySQL installer doesn’t support upgrades between the community and commercial releases. If such an upgrade is required, it can be done using the ZIP archive method.Let us understand how MySQL can be upgraded with MySQL installer. This is considered the best approach when the current server installation is performed along with it and the upgrade happens within the current release series.MySQL installer doesn’t support upgrades between release series, such as from 5.7 to 8.0 and so on. ...
Read MoreUpgrading a Docker Installation of MySQL
Before upgrading the docker installation of MySQL, ensure that the below mentioned steps have been followed −Download a MySQL server docker image.Start a MySQL server instance.Connect to MySQL server instance from within the container.Following are the steps to upgrade a Docker installation of MySQL 5.7 to 8.0 −Stop the MySQL 5.6 server using the below command. Here mysql56 is the name of the container.docker stop mysql56Download the MySQL 5.7 Server Docker image.Start a new MySQL 5.7 Docker container with the help of the old server data and configuration.Perform modifications if required.If MySQL community server is present, run the below command ...
Read MoreCopying MySQL Databases to another Machine
When databases need to be transferred between different architectures, the ‘mysqldump’ can be used to create a file. This file would contain SQL statements. The file transfers can be done from one machine to another, and this file can be used as an input to the ‘mysql’ client.Move Database between two machinesOne way to move database between two machines is to execute the commands on the machine on which database is present −mysqladmin −h 'other_hostname' create db_name mysqldump db_name | mysql −h 'other_hostname' db_nameCopy a database from a remote machine over a slow networkIf database needs to be copied from ...
Read MoreMySQL Environment Variables
Let us understand the environment variables that are directly or indirectly used by MySQL. We will name the environment variable and give a description about it in the below section −AUTHENTICATION_LDAP_CLIENT_LOG − It is the client-side LDAP authentication logging level.AUTHENTICATION_PAM_LOG − It is the PAM authentication plugin debug logging settings.CC − It is the name of your C compiler (to run CMake).CXX − It is the name of your C++ compiler (to run CMake).CC − It is the name of your C compiler (to run CMake).DBI_USER − It is the default user name for Perl DBI.DBI_TRACE − It is the ...
Read MoreGenerating MySQL Doxygen Documentation Content
The source code of MySQL contains a lot of internal documentation, which is written using Doxygen. This Doxygen content is available atahttps://dev.mysql.com/doc/index-other.html. This Doxygen content can be generated locally from a MySQl source distribution. This can be done by following the below mentioned steps −Install DoxygenThe first step is to install Doxygen 1.8.11 or a higher version of it. The distributions are available at https://www.doxygen.nl/.Once it has been installed, the version number has to be verified. This can be done using the below command −shell > doxygen −−version 1.8.13Install PlantUMLNext step is to install PlantUML. When this is installed on ...
Read MoreDowngrading Binary and Package-based Installations on Unix/Linux
Let us understand how to downgrade binary and package-based installation on Unix or Linux. Downgrading binary and package based installations on Unix or Linux can be done in a variety of ways. They have discussed below.In-Place DowngradeIn-place downgrade involves shutting down the new MySQL version.Once this is done, the new MySQL binaries or packages are replaced with the old binaries or packages.Once this is done, the old MySQL version is restarted on the existing data directory.MySQL has to be configured to perform a slow shutdown by setting innodb_fast_shutdown to 0.The below command would do the same −mysql -u root -p ...
Read More