.


:

:



,



( , )

:

































 

 

 

 
FAQ

. . MySQL.

C

 

 

充3

1. ,

MySQL.....4

2. MySQL...9

2.1. .....10

充.....22

...24

 

 

 

.

 

MySQL , . ? , , MySQL . PostgreSql, , *GNU GPL, . . , MySQL: .

MySQL . FreeBSD, OpenBSD, MacOS, OS/2, SunOS, Win9x/00/NT Linux. MySQL Linux Windows. .

MySQL , SQL (Structured Query Language, ) / , , , .

, MySQL MySQL.

 

 

,

MSQL.

MySQL, -, TCP . MySQL, 3306. , CGI- Perl C, SQL. , , . .

MSQL- mysqld.exe. . .

:

mysqladmin -u root shutdown.

, mysql.err . , MySQL.

MSQL . , . , . ( ) . .

, MSQL , msql. . mysql 1.1.

1.1.

  user MySQL
  db
  host , , ,
  tables_priv ,
  columns_priv ,

 

, 1.1. , (1.2.).

1.2. user

       
Host Char(60)   ,
User Char(16)  
Password Char(16)  
Select_priv Enum(N, Y) N SELECT
Insert_priv Enum(N, Y) N INSERT
Update_priv Enum(N, Y) N UPDATE
Delete_priv Enum(N, Y) N DELETE
Reload_priv Enum(N, Y) N MySQL,
       
Shutdown_priv Enum(N, Y) N MySQL
Process_priv Enum(N, Y) N
File_priv Enum(N, Y) N , , LOAD DATA INFILE
Grant_priv Enum(N, Y) N ,
References_priv Enum(N, Y) N ,
Index_priv Enum(N, Y) N ,
Alter_priv Enum(N, Y) N ,

 

Enum (N, Y) , Y, , N.

MSQL , , . . MySQL. File_priv, .

host IP- , . .

. , password ().

, .

user , Host, User password () , , .

db. , (. 1.3).

1.3.

Host     ,
Db    
User    
Select_priv Enum(N, Y) N SELECT
Insert_priv Enum(N, Y) N INSERT
Update_priv Enum(N, Y) N UPDATE
Delete_priv Enum(N, Y) N DELETE
Create_priv Enum(N, Y) N , CREATE TABLE
Drop_priv Enum(N, Y) N , DROP TABLE
Grant_priv Enum(N, Y) N ,
References_priv Enum(N, Y) N ,
Index_priv Enum(N, Y) N ,
Alter_priv Enum(N, Y) N ,

 

, db, , user, user.

, , Host. Host , host. Host Db, , User. host db, , host Host Db , .

MySQL ( tables_priv columns_priv), .

 

 

MySQL.

MySQL :

mysql

mysqlaccess

mysqladmin

mysqld

mysqldump

mysqlshow

isamchk

isamlog

safe_mysqld

. MySQL, .

comp_err

msql2mysql

mysqlbug

perror

replace

which1

zap

 

Mysql

MySQL.

:

mysql [OPTIONS] database

:

MySQL MySQL. MySQL, .

mysql . "" .
-\?, --help .
-d, --debug=[options] . 'd:t:o,filename`.
-d, --debug-info .
-e, --exec , --batch.
-f, --force , SQL .
-h, --hostname=[hostname] , .
-P, --port=[port] , MySQL.
-p, --password=[password] , MySQL. -p .
-q, --quick ( ), , .
-s, --silent ( ).
-u, --user=[user] MySQL. , , . .
-v, --verbose . -v .
-w, --wait , .
-B, --batch . STDOUT. / . . .
-I, --help , -\?.
-V, --version .

 

Mysqlaccess

.

:

mysqlaccess [host] [user] [db] OPTIONS

:

mysqlaccess , . , .

mysqlaccess ( "" ):

-?, --help .
-v, --version
-u, --user=... .
-p, --password=... , MySQL.
-h, --host=... , .
-d, --db=... , .
-U, --superuser=... .
-P, --spassword=... .
-b, --brief .
--relnotes .
--plan .
--howto `mysqlaccess'
--debug=N N (0..3)

, . , 'localhost'.

 

Mysqladmin

.

:

mysqladmin [OPTIONS] command command...

:

mysqladmin , MySQL. ( "" ):

-\?, --help .
-d, --debug=[options] . 'd:t:o,filename`.
-f, --force .
-h, --host=[hostname] , localhost.
-i, --sleep=[seconds] [] .
-p, --password[password] , MySQL. , -p .
-u, --user=[user] . , .
-P, --port=[port] , MySQL.
-V, --version .


mysqladmin :
create [ ] .
drop [ ] ( ).
processlist MySQL.
reload .
shutdown MySQL. MySQL- 'killed'. , , , , , , . 'mysql server has gone away'.
status .

 

Mysqld

MySQL (mysqld).

:

mysqld [OPTIONS]

:

mysqld MySQL. , . , .

--log-isam, . , 5-10%. , .

--log-isam , . ISAM .

UPDATE, DELETE INSERT 13 .

. , .

, / . mysql. , SELECT.

mysqld safe_mysqld.

mysqld :

-\?, --help
-#, --debug=[options] . 'd:t:o,filename`.
-b, --basedir=[path] .
-h, --datadir [homedir] .
-l, --log=[filename] .
--log-isam=[filename] isam.
-O, --set-variable var=option . . .
-L, --language=[language] 'english/'. 'swedish/', 'germany/','french/' 'czech/'. share/mysql , MySQL.
-P, --port=[port] .
-T, --debug-info .
--skip-new-routines .
--skip-grant-tables . .
--skip-locking . , isamchk. , .
--skip-name-resolve mysqld IP , mysql. DNS , , .
--skip-networking localhost. MIT . , .
--skip-unsafe-select .
--socket=[socket] - MySQL. MySQL, MIT . : mysqld --socket=/tmp/mysql.sock
-V, --version .

 

-h , mysql , = "/my/data/sql/mysql".

[homedir]/[ ].

-l . , , . logfile, -l mysqld [homedir]/[hostname].log.

-O :

back_log  
keybuffer  
max_allowed_packet  
net_buffer_length  
max_connections  
table_cache  
recordbuffer  
sortbuffer  
max_sort_length  

Mysqldump

.

:

mysqldump [OPTIONS] [database [table [field]]]

:

mysqldump MySQL. SQL . SQL . MySQL, mysqldump, , .

mysqldump ( ):

-#, --debug=[options] . 'd:t:o,filename`.
-?, --help .
-c, --compleat-insert insert ( , ).
-h, --host=[hostname] hostname.
-d, --no-data ( ).
-t, --no-create-info , . -d.
-p, --password=[password] , MySQL. , -p .
-q, --quick , STDOUT.
-u, --user=[username] . , .
-v, --verbose mysqldump.
-P, --port=[port] .
-V, --version .

mysqldump MySQL, . , , !

Mysqlshow

, .

:

mysqlshow [OPTIONS] [database [table [field]]]

:

mysqlshow , , MySQL , , .

mysqlshow :

-#, --debug=[options] . 'd:t:o,filename`.
-?, --help .
-h, --host=[hostname] hostname.
-k, --key () ().
-p, --password=[password] , MySQL.
-u, --user=[username] . , .
-P, --port=[port] .
-V, --version .


Mysqlshow . Mysqlshow . Mysqlshow .

'?' '*', .

Isamchk

, , MySQL.

:

isamchk [-?adeiqrsvwzIV] [-k #] [-O xxxx=size] [-Si] [-Sr #] [-O keybuffer=#] [-O readbuffer=#] [-O writebuffer=#] [-O sortbuffer=#] [-O sort_key_blocks=#] files

:

isamchk , . Isamchk , , BLOB . , .

MySQL isamchk -r.

, -rq , "" . , , isamchk .

, , / . , $DATADIR/DBNAME.

isamchk:

-# . 'd:t:o,filename`.
-? .
-a . .
-d .
-e . mysqld.
-f . 'isamchk -r', .
-k# .
-i .
-q .
-r[o] , B-Tree, MySQL. , , , .
-s .
-u .
-v . , . v (, vv).
-w , .
-I .
-S[ir]# / #. .
-V .
-O var=# var=#[k][m]


'-q', . -ro : , -r. -r , , . -f , .

:

isamchk -r [table_name] , - BLOBS VARCHARS. .
isamchk -ei [table_name] .
isamchk [table_name] .
isamchk -rq [table_name] . , .
isamchk -d -v [table_name] .
isamchk -rq -Si [table_name] [table_name].

 

Isamlog

, isam-.

:

isamlog [-?iruvIV] [-c #] [-f #] [-p #] [-F filepath/] [-o #] [-R file recordpos] [-w write_file] [log-filename]

:

--log-isam=file_name mysqld.

file_name . isamlog .

, , , mysqld ISAM , ISAM .

-? or -I .
-V .
-c # # .
-f # . # , .
-F [path] ISAM . , . : -F '/var/mirror/' isamlog /var/mirror, , .
-i .
-o # #.
-p # # .
-r , .
-R ISAM, . : isamlog -R /usr/local/data/mysql/user.ISM 1234 /usr/local/data/mysql/user, 1234.
-u . , .
-v . v (, vv).
-w [filename] -R [filename]. , .

 

Safe_mysqld

mysqld.

:

safe_mysqld [options to mysqld]

:

, mysqld. , DATADIR MySQL, mysqld, DATADIR .

 

.

MySQL :

. .

.

.

.

16 . 15 .

CREATE.

1 4 (ints, float, double, fixed), .

C perl.

, .

(isamchk).

.

, .

. INSERT .

, .

, MySQL , , , , .

, , , , . MySQL . , .

, -. MySQL , MySQL c Internet, . - -.

 

 

1. . . MySQL Perl .: , 2001.

. . MySQL.

3. . . SQL.

4. -:

www.mysql.com

www.infocity.kiev.ua

 

<== | ==>
() | 
:

: 2017-03-18; !; : 504 |

:

:

, .
==> ...

1580 - | 1362 -


© 2015-2024 lektsii.org - -

: 0.111 .