Pastebin launched a little side project called HostCabi.net, check it out ;-)Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jul 15th, 2012  |  syntax: None  |  size: 1.59 KB  |  hits: 25  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. cd /Ap  # /etc/mysql/my.cnf: The global mysql configuration file.
  2.  
  3. # This file can be simultaneously placed in three places:
  4. # 1. /etc/mysql/my.cnf to set global options.
  5. # 2. /var/lib/mysql/my.cnf to set server-specific options.
  6. # 3. ~/.my.cnf to set user-specific options.
  7. #
  8. # One can use all long options that the program supports.
  9. # Run the program with --help to get a list of them.
  10. #
  11. # The following values assume you have at least 32M RAM!
  12.  
  13. [client]
  14. #password       = my_password
  15. port            = 3308
  16. socket          = __PREFIX/var/run/mysqld/mysqld.sock
  17.  
  18. [safe_mysqld]
  19. err-log         = __PREFIX/var/log/mysql/mysql.err
  20. pid-file        = __PREFIX/var/run/mysqld/mysqld.pid
  21. socket          = __PREFIX/var/run/mysqld/mysqld.sock
  22.  
  23. [mysqld_safe]
  24. err-log         = __PREFIX/var/log/mysql/mysql.err
  25. pid-file        = __PREFIX/var/run/mysqld/mysqld.pid
  26. socket          = __PREFIX/var/run/mysqld/mysqld.sock
  27.  
  28. [mysqld]
  29. #skip-networking
  30. skip-innodb
  31. user            = mysql
  32. pid-file        = __PREFIX/var/run/mysqld/mysqld.pid
  33. socket          = __PREFIX/var/run/mysqld/mysqld.sock
  34. port            = 3308
  35. log             = __PREFIX/var/log/mysql/mysql.log
  36. basedir         = __PREFIX
  37. datadir         = __PREFIX/var/db/mysql
  38. tmpdir          = /tmp
  39. language        = __PREFIX/share/mysql/english
  40. skip-locking
  41. set-variable    = key_buffer=16M
  42. set-variable    = max_allowed_packet=1M
  43. set-variable    = thread_stack=128K
  44.  
  45. [mysqldump]
  46. quick
  47. set-variable    = max_allowed_packet=1M
  48.  
  49. [mysql]
  50. #no-auto-rehash # faster start of mysql but no tab completition
  51.  
  52. [isamchk]
  53. set-variable    = key_buffer=16