blog.shakirov.com // MySQL

�� php mysql �� windows ��

Mon, 25 Feb 2008 08:47:00 -0500

�� :

File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2) Character set '#51' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22) Character set '#51' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file

�� :

1. � �� C:\mysql\share\charsets �� Index � �� cp1251.xml 51

2. �� cp1251.xml �� cp1251.xml.conf

�� mysql, �� C:\mysql\share\charsets �� cp1251.xml

�� cp1251.xml �� : http://blog.shakirov.com/entry/1000064/file/cp1251.xml

�� MySQL � �� .

Mon, 04 Feb 2008 12:58:00 -0500

� my.cnf:

[mysqld] long_query_time=10 log-slow-queries=/var/log/mysqld/slowquery.log

�� , �� mysqld --log=allquery.log

Mysql: �� .

Mon, 31 Dec 2007 14:52:00 -0500

[root@srv ~]# mysql -uroot -p
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4014
Server version: 5.0.45-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql
Database changed
mysql> UPDATE user SET max_questions=28800;

�� root �� MySql

Thu, 20 Dec 2007 05:55:00 -0500

[root@srv001 ~]# service mysqld stop [root@srv001 ~]# su mysql bash-3.00$ mysqld --skip-grant-tables �� : [root@srv001 ~]# mysql -u root; mysql> use mysql; mysql> UPDATE user SET PASSWORD=NULL WHERE USER='root'; mysql> FLUSH PRIVILEGES; [root@srv001 ~]# mysqladmin -h 127.0.0.1 -u root password 'new_pass' [root@srv001 ~]# killall -9 mysqld [root@srv001 ~]# service mysqld stop && service mysqld start

MySQL � ��

Tue, 20 Nov 2007 00:00:00 -0500

�� /�� Mysql �� :

ALTER TABLE table1 CONVERT TO CHARACTER SET cp1251_general_ci

ALTER TABLE table1 DEFAULT CHARACTER SET cp1251_general_ci

ALTER DATABASE database1 DEFAULT CHARACTER SET cp1251_general_ci

�� my.cnf

[mysqld]

basedir="/��/mysql/"

datadir="/��/mysql/data/"

character-sets-dir="/��/mysql/share/charsets"

default-character-set="koi8r"

default-collation="koi8r_general_ci"

character-set-server="koi8r"

��

Thu, 21 Dec 2006 06:23:00 -0500

�� Mysql, �� , �� :

# mysql --host=localhost --user=root --password=1111111 --default-character-set=cp1251 basename < dump.sql

�� Mysql �� :

# mysqldump --add-drop-table --host=localhost --user=$db_login --password=$db_pass $db_name > db.sql

blog.shakirov.com // MySQL

�������� php mysql �� windows �������

��������� ������� MySQL � ����������� ���� ��������.

Mysql: ����������� �� ����� ��������� � ���.

����� root ������ �� MySql

MySQL � ���������

��� ����

�� php mysql �� windows ��

�� MySQL � �� .

Mysql: �� .

�� root �� MySql

MySQL � ��

��