79473
Creating an Option File
lf you need to specify startup options when you run the server, you can indicate them on the command
linę or place them in an option file. For options that are used every time the server starts, you may find
it most convenient to use an option file to specify your MySQL configuration. This is particularly true under the following circumstances:
• The installation or data directory locations are different from the default locations (c: \ Program
Files\MySQL\MySQL Server 5.6 and C:\Program Files\MySQL\MySQL Server 5.6\data).
• You need to tune the server settings, such as memory, cache, or InnoDB configuration information
When the MySQL server starts on Windows, it looks for option files in several locations, such as
the Wndows directory, C:\, and the MySQL installation directory (for the fuli list of locations, see
Section 4.2.3.3, “Using Option Files”). The Wndows directory typically is named something like c:
\Windows. You can determine its exact location from the value of the windir environment variable using the following command:
C: >echo %WINDIR%
MySQL looks for options in each location first in the my. ini file, and then in the my. cnf file. However,
to avoid confusion, it is best if you use only one file. If your PC uses a boot loader where c: is not the
boot drive, your only option is to use the my. ini file. Whichever option file you use, it must be a plain text file.
Wyszukiwarka
Podobne podstrony:
Viewing Online Redo Log File Information You can usc EM Express to view status and multiplexing infof You need to ^ wear safety glasses when doing any You only need ^ to wear safety gWIĘCEJ FILMÓW ^IpH no/IbLUA BMTe/ii % but to do this they need to pass through‘: Ęa nayigable straipage((1) 7 • Tape a loop of yarn to the back of the angel so you can hang her on your Chrip008 - Hmmm. Do you 1 think, that will be better, Sebastian? yf-1 don’t know../j > but you cInstalling MySQL on Mac OS X Using Native Packages You can install MySQL on Mac OS X 10.3.x (“PantheProgram Option Modifiers Some options are “boolean” and control behavior that can be turned on or ofYOU CAN ALWAYS DiPEND ON BUTTREYS SUPER STORĘ FOR Join tW? thrifty fhouvond* lhot sovo regulorly atToday = You Can Run, But You Can’t Hicie 1993 On the Internet, nobody knows you re a dog. 2013 On thsielsko Summer -Perfume If you can t be a pine on the top of the hill Be a scrub in the valley - .bu11001 Obrazek63 Need to knock up an emergency Christmas card fast? These easy designs won’t take youCreative Doughcraft2 Chapter 4 Basic technigues Joining dough together is a simple technique whichObrazek63 Need to knock up an emergency Christmas card fast? These easy designs won’t take you any tslajd z webinaru I lAll VIA> VkaA*na Rste What you’re going to need: Clickbank account An ebook t11001 Obrazek63 Need to knock up an emergency Christmas card fast? These easy designs won’t take youpage76 OOTHER ACCESS O RIES OMAGNET CARD HOLDER Decoratc magnets to make an elegant card holder. Youtmw?count Enter e-mail address and password. Select if you need to create an account. Cllck Next.więcej podobnych podstron