SHARE
TWEET

adasdasd

a guest Jan 25th, 2016 105 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # Example MySQL config file for medium systems.
  2. #
  3. # This is for a system with little memory (32M - 64M) where MySQL plays
  4. # an important part, or systems up to 128M where MySQL is used together with
  5. # other programs (such as a web server)
  6. #
  7. # You can copy this file to
  8. # /etc/my.cnf to set global options,
  9. # mysql-data-dir/my.cnf to set server-specific options (in this
  10. # installation this directory is C:\mysql\data) or
  11. # ~/.my.cnf to set user-specific options.
  12. #
  13. # In this file, you can use all long options that a program supports.
  14. # If you want to know which options a program supports, run the program
  15. # with the "--help" option.
  16.  
  17. # The following options will be passed to all MySQL clients
  18. [client]
  19. #password   = your_password
  20. port        = 3306
  21. socket      = /tmp/mysql.sock
  22.  
  23. # Here follows entries for some specific programs
  24.  
  25. # The MySQL server
  26. [wampmysqld]
  27. port        = 3306
  28. socket      = /tmp/mysql.sock
  29. skip-locking
  30. key_buffer = 16M
  31. max_allowed_packet = 1M
  32. table_cache = 64
  33. sort_buffer_size = 512K
  34. net_buffer_length = 8K
  35. read_buffer_size = 256K
  36. read_rnd_buffer_size = 512K
  37. myisam_sort_buffer_size = 8M
  38. basedir=c:/wamp/bin/mysql/mysql5.1.53
  39. log-error=c:/wamp/logs/mysql.log
  40. datadir=c:/wamp/bin/mysql/mysql5.1.53/data
  41.  
  42. # Don't listen on a TCP/IP port at all. This can be a security enhancement,
  43. # if all processes that need to connect to mysqld run on the same host.
  44. # All interaction with mysqld must be made via Unix sockets or named pipes.
  45. # Note that using this option without enabling named pipes on Windows
  46. # (via the "enable-named-pipe" option) will render mysqld useless!
  47. #
  48. #skip-networking
  49.  
  50. # Disable Federated by default
  51. skip-federated
  52.  
  53. # Replication Master Server (default)
  54. # binary logging is required for replication
  55. log-bin=mysql-bin
  56.  
  57. # binary logging format - mixed recommended
  58. binlog_format=mixed
  59.  
  60. # required unique id between 1 and 2^32 - 1
  61. # defaults to 1 if master-host is not set
  62. # but will not function as a master if omitted
  63. server-id   = 1
  64.  
  65. # Replication Slave (comment out master section to use this)
  66. #
  67. # To configure this host as a replication slave, you can choose between
  68. # two methods :
  69. #
  70. # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
  71. #    the syntax is:
  72. #
  73. #    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
  74. #    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
  75. #
  76. #    where you replace <host>, <user>, <password> by quoted strings and
  77. #    <port> by the master's port number (3306 by default).
  78. #
  79. #    Example:
  80. #
  81. #    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
  82. #    MASTER_USER='joe', MASTER_PASSWORD='secret';
  83. #
  84. # OR
  85. #
  86. # 2) Set the variables below. However, in case you choose this method, then
  87. #    start replication for the first time (even unsuccessfully, for example
  88. #    if you mistyped the password in master-password and the slave fails to
  89. #    connect), the slave will create a master.info file, and any later
  90. #    change in this file to the variables' values below will be ignored and
  91. #    overridden by the content of the master.info file, unless you shutdown
  92. #    the slave server, delete master.info and restart the slaver server.
  93. #    For that reason, you may want to leave the lines below untouched
  94. #    (commented) and instead use CHANGE MASTER TO (see above)
  95. #
  96. # required unique id between 2 and 2^32 - 1
  97. # (and different from the master)
  98. # defaults to 2 if master-host is set
  99. # but will not function as a slave if omitted
  100. #server-id       = 2
  101. #
  102. # The replication master for this slave - required
  103. #master-host     =   <hostname>
  104. #
  105. # The username the slave will use for authentication when connecting
  106. # to the master - required
  107. #master-user     =   <username>
  108. #
  109. # The password the slave will authenticate with when connecting to
  110. # the master - required
  111. #master-password =   <password>
  112. #
  113. # The port the master is listening on.
  114. # optional - defaults to 3306
  115. #master-port     =  <port>
  116. #
  117. # binary logging - not required for slaves, but recommended
  118. #log-bin=mysql-bin
  119.  
  120. # Point the following paths to different dedicated disks
  121. #tmpdir     = /tmp/    
  122. #log-update     = /path-to-dedicated-directory/hostname
  123.  
  124. # Uncomment the following if you are using InnoDB tables
  125. #innodb_data_home_dir = C:\mysql\data/
  126. #innodb_data_file_path = ibdata1:10M:autoextend
  127. #innodb_log_group_home_dir = C:\mysql\data/
  128. #innodb_log_arch_dir = C:\mysql\data/
  129. # You can set .._buffer_pool_size up to 50 - 80 %
  130. # of RAM but beware of setting memory usage too high
  131. #innodb_buffer_pool_size = 16M
  132. #innodb_additional_mem_pool_size = 2M
  133. # Set .._log_file_size to 25 % of buffer pool size
  134. #innodb_log_file_size = 5M
  135. #innodb_log_buffer_size = 8M
  136. #innodb_flush_log_at_trx_commit = 1
  137. #innodb_lock_wait_timeout = 50
  138.  
  139. [mysqldump]
  140. quick
  141. max_allowed_packet = 16M
  142.  
  143. [mysql]
  144. no-auto-rehash
  145. # Remove the next comment character if you are not familiar with SQL
  146. #safe-updates
  147.  
  148. [isamchk]
  149. key_buffer = 20M
  150. sort_buffer_size = 20M
  151. read_buffer = 2M
  152. write_buffer = 2M
  153.  
  154. [myisamchk]
  155. key_buffer = 20M
  156. sort_buffer_size = 20M
  157. read_buffer = 2M
  158. write_buffer = 2M
  159.  
  160. [mysqlhotcopy]
  161. interactive-timeout
  162.  
  163. [mysqld]
  164. port=3306
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top