Installing MySQL and MariaDB - Learning MySQL and MariaDB - page 19

ages, there are 32-bit and 64-bit versions, which you would choose based on which kind
of processor is in your server.
Both the installer and TAR packages contain the essential files for running MySQL or
MariaDB, including all of the command-line utilities covered in this topic (e.g., mysql ,
mysqladmin , mysqlbackup ), some useful scripts for handling special needs, and the librar-
ies for APIs. They also contain the /usr/local/mysql/docs directory for the version that you
download.
If you decide to use the TAR package for Windows, because it does not include an in-
staller to handle everything for you, you will have to do a few things manually at the be-
ginning. First, you will need to unzip theTAR file to get at the installation files. To do
this, you need WinZip or anotherutility that you might have installed on your server to
uncompress the files. These files need to be copied into the c:\mysql directory. You'll have
to create that directory if it does not already exist on your server. Then, using a plain-text
editor (e.g., Notepad) you must create a configuration file that is generally called my.ini in
the c:\windows directory. Several examples of this configuration file are provided with the
distribution package. Once you have the files in the appropriate place, you can run the
setup program. It does provide some assistance, but not as much as the installer.
Before running the installer or the setup program, if MySQL is already installed and run-
ning on your server, and you want to install a newer version, you will first need to shut
down the one that's currently running on your server. For server versions of Windows, it's
generally installed as a service. You can enter something like the following within a com-
mand window to shut down the service and remove it:
mysqld -remove
If MySQL is running on your server, but not as a service, you can enter the following
within a command window to shut it down:
msyqladmin -u root -p shutdown
If that returns an error message, you may have to figure out the absolutepath for mysqlad-
min . Try entering something like the following, adjusting the file path to wherever mysql-
admin is located:
"C:\Program Data\MySQL\MySQL Server 5.1\bin\mysqladmin" -u root -p
shutdown
After you download the MySQL Installer for Windows from the Windows desktop,
double-click on the file's icon and the Windows Installer program will start. If you're in-
stalling from a ZIP package, look for the file named setup.exe wherever you put the