On Windows, MySQL Server supports only directory and file names that are compatible with the current ANSI code pages. For example, the following Japanese directory name does not work in the Western locale (code page 1252): 

datadir="C:/ 私たちのプロジェクトのデータ " 

The same limitation applies to directory and file names referred to in SQL statements, such as the data file path name in LOAD DATA . 

• The \  path name separator character 

Path name components in Windows are separated by the \  character, which is also the escape character in MySQL. If you are using LOAD DATA  or SELECT ... INTO OUTFILE , use Unix-style file names with /  characters: 

mysql> LOAD DATA INFILE ’C:/tmp/skr.txt’ INTO TABLE skr; mysql> SELECT * INTO OUTFILE ’C:/tmp/skr.txt’ FROM skr; 

Alternatively, you must double the \  character: 

mysql> LOAD DATA INFILE ’C:\	mp\\skr.txt’ INTO TABLE skr; mysql> SELECT * INTO OUTFILE ’C:\	mp\\skr.txt’ FROM skr; 

• Problems with pipes 

Pipes do not work reliably from the Windows command-line prompt. If the pipe includes the character ^Z / CHAR(24) , Windows thinks that it has encountered end-of-file and aborts the program. 

This is mainly a problem when you try to apply a binary log as follows: 

C:\> mysqlbinlog binary_log_file  | mysql --user=root 

If you have a problem applying the log and suspect that it is because of a ^Z  / CHAR(24)  character, you can use the following workaround: 

C:\> mysqlbinlog binary_log_file  --result-file=/tmp/bin.sql C:\> mysql --user=root --execute "source /tmp/bin.sql" 

The latter command also can be used to reliably read any SQL file that may contain binary data. 

## 2.4 Installing MySQL on macOS 

For a list of macOS versions that the MySQL server supports, see https://www.mysql.com/support/ supportedplatforms/database.html. 

MySQL for macOS is available in a number of different forms: 

•Native Package Installer, which uses the native macOS installer (DMG) to walk you through the installation of MySQL. For more information, see Section 2.4.2, “Installing MySQL on macOS Using Native Packages” . You can use the package installer with macOS. The user you use to perform the installation must have administrator privileges. 

•Compressed TAR archive, which uses a file packaged using the Unix tar  and gzip  commands. To use this method, you need to open a Terminal  window. You do not need administrator privileges using this method; you can install the MySQL server anywhere using this method. For more information on using this method, you can use the generic instructions for using a tarball, Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries” . 

