- AWS アプリケーションを走らせる環境を作る
pear install db
pear channel-discover pear.ethna.jp
pear
- もう一つのAll In One Redmine
redmine 0.8.4 (upstream tarball)
git-core 1:1.5.4.3-1ubuntu2.1
bzr 1.3.1-1ubuntu0.1
subversion 1.4.6dfsg1-2ubuntu1.1
mercurial 0.9.5-3
apache2 2.2.8-1ubuntu0.11
mysql-server 5.0.51a-3ubuntu5.4
ruby 4.1
rubygems 1.3.5
rails 2.3.4
rake 0.8.7
passenger 2.2.5
- VBA ODBCユーザーDSN（SQLServer認証）をプログラムで登録
set newtableitem = currentdb.createtabledef(tablename)
- Slax mysql-bugreport.002
please remember to set a password for the mysql root user ! to do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h slax password 'new-password'
- Slax mysql-bugreport.003
root@slax:~# /usr/share/mysql/mysql.server start --datadir=/mnt/sda1/tmp/ starting mysql............ error! manager of pid-file quit without updating file. root@slax:~# mysql manager_of_pid-file update mysql ver 14.12 distrib 5.0.67, for slackware-linux-gnu (i486) using editline wrapper copyright (c) 2000-2008 mysql ab this software comes with absolutely no warranty. this is free software, and you are welcome to modify and redistribute it under the gpl license usage: mysql [options] [database] -?, --help display this help and exit. -i, --help synonym for -? --auto-rehash enable automatic rehashing. one doesn't need to use 'rehash' to get table and field completion, but startup and reconnecting may take a longer time. disable with --disable-auto-rehash. -a, --no-auto-rehash no automatic rehashing. one has to use 'rehash' to get table and field completion. this gives a quicker start of mysql and disables rehashing on reconnect. warning: options deprecated; use --disable-auto-rehash instead. -b, --batch don't use history file. disable interactive behavior. (enables --silent) --character-sets-dir=name directory where character sets are. --default-character-set=name set the default character set. -c, --comments preserve comments. send comments to the server. the default is --skip-comments (discard comments), enable with --comments -c, --compress use compression in server/client protocol. -#, --debug[=#] this is a non-debug version. catch this and exit -d, --database=name database to use. --delimiter=name delimiter to be used. -e, --execute=name execute command and quit. (disables --force and history file) -e, --vertical print the output of a query (rows) vertically. -f, --force continue even if we get an sql error. -g, --named-commands enable named commands. named commands mean this program's internal commands; see mysql help . when enabled, the named commands can be used from any line of the query, otherwise only from the first line, before an enter. disable with --disable-named-commands. this option is disabled by default. -g, --no-named-commands named commands are disabled. use 。。* form only, or use named commands only in the beginning of a line ending with a semicolon (;) since version 10.9 the client now starts with this option enabled by default! disable with '-g'. long format commands still work from the first line. warning: option deprecated; use --disable-named-commands instead. -i, --ignore-spaces ignore space after function names. --local-infile enable/disable load data local infile. -b, --no-beep turn off beep on error. -h, --host=name connect to host. -h, --html produce html output. -x, --xml produce xml output --line-numbers write line numbers for errors. -l, --skip-line-numbers don't write line number for errors. warning: -l is deprecated, use long version of this option instead. -n, --unbuffered flush buffer after each query. --column-names write column names in results. -n, --skip-column-names don't write column names in results. warning: -n is deprecated, use long version of this options instead. -o, --set-variable=name change the value of a variable. please note that this option is deprecated; you can set variables directly with --variable-name=value. --sigint-ignore ignore sigint (ctrl-c) -o, --one-database only update the default database. this is useful for skipping updates to other database in the update log. --pager[=name] pager to use to display results. if you don't supply an option the default pager is taken from your env variable pager. valid pagers are less, more, cat [ filename], etc. see interactive help (。。h) also. this option does not work in batch mode. disable with --disable-pager. this option is disabled by default. --no-pager disable pager and print to stdout. see interactive help (。。h) also. warning: option deprecated; use --disable-pager instead. -p, --password[=name] password to use when connecting to server. if password is not given it's asked from the tty. -p, --port=# port number to use for connection or 0 for default to, in order of preference, my.cnf, $mysql_tcp_port, /etc/services, built-in default (3306). --prompt=name set the mysql prompt to this value. --protocol=name the protocol of connection (tcp,socket,pipe,memory). -q, --quick don't cache result, print it row by row. this may slow down the server if the output is suspended. doesn't use history file. -r, --raw write fields without conversion. used with --batch. --reconnect reconnect if the connection is lost. disable with --disable-reconnect. this option is enabled by default. -s, --silent be more silent. print results with a tab as separator, each row on new line. -s, --socket=name socket file to use for connection. --ssl enable ssl for connection (automatically enabled with other flags). disable with --skip-ssl. --ssl-ca=name ca file in pem format (check openssl docs, implies --ssl). --ssl-capath=name ca directory (check openssl docs, implies --ssl). --ssl-cert=name x509 cert in pem format (implies --ssl). --ssl-cipher=name ssl cipher to use (implies --ssl). --ssl-key=name x509 key in pem format (implies --ssl). --ssl-verify-server-cert verify server's common name in its cert against hostname used when connecting. this option is disabled by default. -t, --table output in table format. -t, --debug-info print some debug info at exit. --tee=name append everything into outfile. see interactive help (。。h) also. does not work in batch mode. disable with --disable-tee. this option is disabled by default. --no-tee disable outfile. see interactive help (。。h) also. warning: option deprecated; use --disable-tee instead -u, --user=name user for login if not current user. -u, --safe-updates only allow update and delete that uses keys. -u, --i-am-a-dummy synonym for option --safe-updates, -u. -v, --verbose write more. (-v -v -v gives the table output format). -v, --version output version information and exit. -w, --wait wait and retry if connection is down. --connect_timeout=# number of seconds before connection timeout. --max_allowed_packet=# max packet length to send to, or receive from server --net_buffer_length=# buffer for tcp/ip and socket communication --select_limit=# automatic limit for select when using --safe-updates --max_join_size=# automatic limit for rows in a join when using --safe-updates --secure-auth refuse client connecting to server if it uses old (pre-4.1.1) protocol --show-warnings show warnings after every statement.
|
