FAQ
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
単語検索
|
最終更新
|
ヘルプ
]
開始行:
-[[Home:http://www.mysql.gr.jp/frame/]]
-[[About MyNA]]
-[[Contrib]]
----
~
#contents
----
- Community : GPL
http://www.gnu.org/home.ja.html
~
~
----
~
~
~
~
~
~
http://ftp.iij.ad.jp/pub/db/mysql/Downloads/ ~
http://ftp.lab.kdd.co.jp/database/MySQL/Downloads/ ~
ftp://ftp.u-aizu.ac.jp/ftp/pub/dbms/mysql/mysql.com/Downl...
~
~
----
~
~
~
~
~
~
----
- Linux
- FreeBSD
~
~
~
CREATE TABLE ..... (.....) TYPE=InnoDB;
ALTER TABLE .... TYPE=MyISAM;
|BDB | berkley db |
~
~
~
mysqld --default-table-type=innodb
mysqld --default-storage-engine=InnoDB
~
~
~
~
mysqld --basedir=/usr/local/mysql-4.0.22 --datadir=/usr/...
/usr/local/mysql-4.0.22/my.cnf
[mysqld]
basedir=/usr/local/mysql-4.0.22
datadir=/usr/local/mysql-4.0.22/data
socket=/tmp/sock4.0.22
port=4022
mysqld --defaults-file=/usr/local/mysql-4.0.22/my.cnf &
~
~
CREATE TABLE .... (...) DATA DIRECTORY = '/path/to/direc...
[mysqld]
innodb_data_home_dir =
innodb_data_file_path=/path/to/file1:10M;/path/to/file2:...
[mysqld]
innodb_file_per_table
~
~
~
*** mysqlbinlog [#sf23477f]
- --start-datetime=
- --stop-datetime=
- --start-position=
- --stop-position=
~
~
- mysqldump
mysqldump --single-transaction --master-data --skip-opt ...
- InnoDB Hot Backup
~
~
REPAIR TABLE
OPTIMIZE TABLE
~
~
~
~
*** case sensitive? case in-sensitive? [#r359d37f]
~
~
** init-connect [#n46f9fc8]
ex. mysqld --init-connect='SET AUTOCOMMIT=0'
~
~
SET AUTOCOMMIT=0;
autocommit mode
SET AUTOCOMMIT=1;
~
~
mysqld --max_allowed_packet=
~
~
mysqld --max_connections=500
~
mysqld_safe --open-files-limit=
mysqld --back_log=
~
~
~
-- bdb_cache_size
-- bdb_log_buffer_size
-- innodb_additional_mem_pool_size
-- innodb_buffer_pool_awe_mem_mb
-- innodb_buffer_pool_size
-- innodb_log_buffer_size
-- key_buffer_size
-- query_cache_size
-- join_buffer_size
-- read_buffer_size
-- read_rnd_buffer_size
-- sort_buffer_size
~
~
mysqld --log
~
~
[mysqld]
default-character-set = ujis
[mysqldump]
default-character-set = ujis
[mysql]
default-character-set = ujis
~
~
~
----
~
~
SHOW VARIABLES LIKE 'char%';
~
~
mysql> SHOW VARIABLES LIKE 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | binary |
| character_set_connection | binary |
| character_set_database | ujis |
| character_set_results | binary |
| character_set_server | ujis |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
7 rows in set (0.00 sec)
~
~
| character_set_client | ujis |
| character_set_connection | ujis |
| character_set_database | ujis |
| character_set_results | ujis |
| character_set_server | ujis |
~
~
| character_set_client | binary |
| character_set_connection | binary |
| character_set_database | ujis |
| character_set_results | binary |
| character_set_server | ujis |
~
~
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | ujis |
| character_set_results | latin1 |
| character_set_server | ujis |
~
~
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | ujis |
| character_set_results | utf8 |
| character_set_server | ujis |
~
~
~
~
~
~
[mysqldump]
default-character-set=binary
skip-opt
create-options
set-charset
hex-blob
single-transaction
master-data
http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib
~
~
||Password|
|4.1|*59170D1E4A5E56267B6ED9C51ED62619FB817E6B|
[mysqld]
old-passwords
~
~
~
~
~
~
+ upgrade
[mysqld]
default-character-set = ujis
old-passwords
skip-character-set-client-handshake
[mysqldump]
default-character-set = ujis
skip-opt
[mysql]
default-character-set = ujis
~
~
mysql -f -uroot mysql < mysql_fix_privilege_tables.sql
~
http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib
~
~
[mysqld-4.1]
old-passwords
~
~
~
~
~
~
~
~
~
~
[mysqld-4.1]
old-passwords
[mysqld]
[mysqldump]
skip-opt
[mysql]
~
~
~
mysql -f -uroot mysql < mysql_fix_privilege_tables.sql
~
~
~
~
~
~
~
~
~
~
#define MYSQL_DEFAULT_CHARSET_NAME "latin1"
#define MYSQL_DEFAULT_CHARSET_NAME "binary"
~
#define MYSQL_DEFAULT_COLLATION_NAME "latin1_swedish_ci"
#define MYSQL_DEFAULT_COLLATION_NAME "binary"
~
~
~
~
~
~
~
~
~
~
~
~
| |
| connect() |
+------------------------+
+------- PHP -------------+
| mysql.so (UNIX) |
| mysql.dll (Windows) |
+-------------------------+
+----------------------------+
| libmysql.dll (Windows) | | ...
+-------------------...
~
4.1(ujis) : +----+-----+-----+
1 2 3
~
~
--- http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib ...
--- http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib ...
--- http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib ...
--- http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib ...
~
~
~
~
~
~
~
----
~
~
** C [#vcc2883f]
- mysql_real_escape_string()
~
ulong STDCALL
mysql_escape_string(char *to,const char *from,ulong leng...
{
return escape_string_for_mysql(default_charset_info, t...
}
ulong STDCALL
mysql_real_escape_string(MYSQL *mysql, char *to,const ch...
{
return escape_string_for_mysql(mysql->charset, to, fro...
}
CHARSET_INFO *default_charset_info = &my_charset_latin1;...
mysql_options(&mysql, MYSQL_READ_DEFAULT_FILE, "/etc/my....
mysql_options(&mysql, MYSQL_READ_DEFAULT_GROUP, "groupna...
~
~
** PHP [#xd3019ac]
- mysql_real_escape_string()
~
http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib
mysqli_options(connection, MYSQLI_READ_DEFAULT_FILE, "/e...
mysqli_options(connection, MYSQLI_READ_DEFAULT_GROUP, "p...
~
~
** Ruby [#p54d4fd7]
my.options(Mysql::READ_DEFAULT_FILE, "/etc/my.cnf")
my.options(Mysql::READ_DEFAULT_GROUP, "ruby")
~
~
** Perl [#e4c50f0d]
$dsn = "DBI:mysql:test;mysql_read_default_group=perl;mys...
~
~
----
~
| |InnoDB|BDB|NDB|
~
~
~
~
~
~
./configure --with-embedded-server
~
~
| |MyISAM |InnoDB |h
~
~
** SELECT COUNT(*) [#b6492d58]
~
~
** InnoDB [#wb6368f1]
~
~
*** auto_increment [#x913272a]
~
ROLLBACK
~
~
~
~
~
~
*** REPEATABLE READ, SERIALIZABLE [#q6dc0af4]
~
~
----
aclocal
autoheader
libtoolize --automake --force
automake
autoconf
cd innobase
aclocal
autoheader
libtoolize --automake --force
automake
autoconf
bk clone bk://mysql.bkbits.net/mysql-5.0 mysql-5.0
bk pull
gcc-2.96, egcs-1, gcc-2.8
~
~
----
** bitkeeper [#kf19be60]
bk clone bk://mysql.bkbits.net/mysqldoc mysqldoc
bk pull
~
~
texi2html -Verbose -nomenu manual.texi
texi2html -nomenu -split=chapter manual.texi
~
texi2dvi manual.texi
~
~
~
~
----
~
~
-
終了行:
-[[Home:http://www.mysql.gr.jp/frame/]]
-[[About MyNA]]
-[[Contrib]]
----
~
#contents
----
- Community : GPL
http://www.gnu.org/home.ja.html
~
~
----
~
~
~
~
~
~
http://ftp.iij.ad.jp/pub/db/mysql/Downloads/ ~
http://ftp.lab.kdd.co.jp/database/MySQL/Downloads/ ~
ftp://ftp.u-aizu.ac.jp/ftp/pub/dbms/mysql/mysql.com/Downl...
~
~
----
~
~
~
~
~
~
----
- Linux
- FreeBSD
~
~
~
CREATE TABLE ..... (.....) TYPE=InnoDB;
ALTER TABLE .... TYPE=MyISAM;
|BDB | berkley db |
~
~
~
mysqld --default-table-type=innodb
mysqld --default-storage-engine=InnoDB
~
~
~
~
mysqld --basedir=/usr/local/mysql-4.0.22 --datadir=/usr/...
/usr/local/mysql-4.0.22/my.cnf
[mysqld]
basedir=/usr/local/mysql-4.0.22
datadir=/usr/local/mysql-4.0.22/data
socket=/tmp/sock4.0.22
port=4022
mysqld --defaults-file=/usr/local/mysql-4.0.22/my.cnf &
~
~
CREATE TABLE .... (...) DATA DIRECTORY = '/path/to/direc...
[mysqld]
innodb_data_home_dir =
innodb_data_file_path=/path/to/file1:10M;/path/to/file2:...
[mysqld]
innodb_file_per_table
~
~
~
*** mysqlbinlog [#sf23477f]
- --start-datetime=
- --stop-datetime=
- --start-position=
- --stop-position=
~
~
- mysqldump
mysqldump --single-transaction --master-data --skip-opt ...
- InnoDB Hot Backup
~
~
REPAIR TABLE
OPTIMIZE TABLE
~
~
~
~
*** case sensitive? case in-sensitive? [#r359d37f]
~
~
** init-connect [#n46f9fc8]
ex. mysqld --init-connect='SET AUTOCOMMIT=0'
~
~
SET AUTOCOMMIT=0;
autocommit mode
SET AUTOCOMMIT=1;
~
~
mysqld --max_allowed_packet=
~
~
mysqld --max_connections=500
~
mysqld_safe --open-files-limit=
mysqld --back_log=
~
~
~
-- bdb_cache_size
-- bdb_log_buffer_size
-- innodb_additional_mem_pool_size
-- innodb_buffer_pool_awe_mem_mb
-- innodb_buffer_pool_size
-- innodb_log_buffer_size
-- key_buffer_size
-- query_cache_size
-- join_buffer_size
-- read_buffer_size
-- read_rnd_buffer_size
-- sort_buffer_size
~
~
mysqld --log
~
~
[mysqld]
default-character-set = ujis
[mysqldump]
default-character-set = ujis
[mysql]
default-character-set = ujis
~
~
~
----
~
~
SHOW VARIABLES LIKE 'char%';
~
~
mysql> SHOW VARIABLES LIKE 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | binary |
| character_set_connection | binary |
| character_set_database | ujis |
| character_set_results | binary |
| character_set_server | ujis |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
7 rows in set (0.00 sec)
~
~
| character_set_client | ujis |
| character_set_connection | ujis |
| character_set_database | ujis |
| character_set_results | ujis |
| character_set_server | ujis |
~
~
| character_set_client | binary |
| character_set_connection | binary |
| character_set_database | ujis |
| character_set_results | binary |
| character_set_server | ujis |
~
~
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | ujis |
| character_set_results | latin1 |
| character_set_server | ujis |
~
~
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | ujis |
| character_set_results | utf8 |
| character_set_server | ujis |
~
~
~
~
~
~
[mysqldump]
default-character-set=binary
skip-opt
create-options
set-charset
hex-blob
single-transaction
master-data
http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib
~
~
||Password|
|4.1|*59170D1E4A5E56267B6ED9C51ED62619FB817E6B|
[mysqld]
old-passwords
~
~
~
~
~
~
+ upgrade
[mysqld]
default-character-set = ujis
old-passwords
skip-character-set-client-handshake
[mysqldump]
default-character-set = ujis
skip-opt
[mysql]
default-character-set = ujis
~
~
mysql -f -uroot mysql < mysql_fix_privilege_tables.sql
~
http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib
~
~
[mysqld-4.1]
old-passwords
~
~
~
~
~
~
~
~
~
~
[mysqld-4.1]
old-passwords
[mysqld]
[mysqldump]
skip-opt
[mysql]
~
~
~
mysql -f -uroot mysql < mysql_fix_privilege_tables.sql
~
~
~
~
~
~
~
~
~
~
#define MYSQL_DEFAULT_CHARSET_NAME "latin1"
#define MYSQL_DEFAULT_CHARSET_NAME "binary"
~
#define MYSQL_DEFAULT_COLLATION_NAME "latin1_swedish_ci"
#define MYSQL_DEFAULT_COLLATION_NAME "binary"
~
~
~
~
~
~
~
~
~
~
~
~
| |
| connect() |
+------------------------+
+------- PHP -------------+
| mysql.so (UNIX) |
| mysql.dll (Windows) |
+-------------------------+
+----------------------------+
| libmysql.dll (Windows) | | ...
+-------------------...
~
4.1(ujis) : +----+-----+-----+
1 2 3
~
~
--- http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib ...
--- http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib ...
--- http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib ...
--- http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib ...
~
~
~
~
~
~
~
----
~
~
** C [#vcc2883f]
- mysql_real_escape_string()
~
ulong STDCALL
mysql_escape_string(char *to,const char *from,ulong leng...
{
return escape_string_for_mysql(default_charset_info, t...
}
ulong STDCALL
mysql_real_escape_string(MYSQL *mysql, char *to,const ch...
{
return escape_string_for_mysql(mysql->charset, to, fro...
}
CHARSET_INFO *default_charset_info = &my_charset_latin1;...
mysql_options(&mysql, MYSQL_READ_DEFAULT_FILE, "/etc/my....
mysql_options(&mysql, MYSQL_READ_DEFAULT_GROUP, "groupna...
~
~
** PHP [#xd3019ac]
- mysql_real_escape_string()
~
http://www.mysql.gr.jp/frame/modules/bwiki/?Contrib
mysqli_options(connection, MYSQLI_READ_DEFAULT_FILE, "/e...
mysqli_options(connection, MYSQLI_READ_DEFAULT_GROUP, "p...
~
~
** Ruby [#p54d4fd7]
my.options(Mysql::READ_DEFAULT_FILE, "/etc/my.cnf")
my.options(Mysql::READ_DEFAULT_GROUP, "ruby")
~
~
** Perl [#e4c50f0d]
$dsn = "DBI:mysql:test;mysql_read_default_group=perl;mys...
~
~
----
~
| |InnoDB|BDB|NDB|
~
~
~
~
~
~
./configure --with-embedded-server
~
~
| |MyISAM |InnoDB |h
~
~
** SELECT COUNT(*) [#b6492d58]
~
~
** InnoDB [#wb6368f1]
~
~
*** auto_increment [#x913272a]
~
ROLLBACK
~
~
~
~
~
~
*** REPEATABLE READ, SERIALIZABLE [#q6dc0af4]
~
~
----
aclocal
autoheader
libtoolize --automake --force
automake
autoconf
cd innobase
aclocal
autoheader
libtoolize --automake --force
automake
autoconf
bk clone bk://mysql.bkbits.net/mysql-5.0 mysql-5.0
bk pull
gcc-2.96, egcs-1, gcc-2.8
~
~
----
** bitkeeper [#kf19be60]
bk clone bk://mysql.bkbits.net/mysqldoc mysqldoc
bk pull
~
~
texi2html -Verbose -nomenu manual.texi
texi2html -nomenu -split=chapter manual.texi
~
texi2dvi manual.texi
~
~
~
~
----
~
~
-
ページ名:
<
webmaster@mysql.gr.jp
>
Copyright 2000-2005 ©
MyNA
. All Rights Reserved. Feel free to link.
