unixboy

Mysql Cluster: The definitive HOWTO This guide was written over a year ago and is an excellent introduction however it has not been updated since! If you have any questions please email me or Buy my b...

加个\G在最后现就可以了. mysql> select * from mailbox \G*************************** 1. row ***************************username: unixboy@abc.compassword: $1$15d22544$D/Y8M.my6mHd6CPZSQJQB.    name: unixboy mai...

mysql> select * from DirectoryMaster limit 1000 into outfile '/tmp/DirectoryMaster.txt' fields terminated by '|'; Query OK, 1000 rows affected (0.02 sec)

25.4.4.6. Using Master/Slave Replication with ReplicationConnection Starting with Connector/J 3.1.7, we've made available a variant of the driver that will automatically send queries to a read/...

How To Control Mysql Replication ZT 1. Environment      In 192.168.1.202  Database: RMC_BILLING  DB Account: root  DB Password:   In 192.168.1.204  Database: RMC_BILLING  DB Account: root  DB Passwo...

MySQL provides a built-in data replication functionality for maintaining identical copies of its data to one or more backend servers, thus providing a simple High Availability mechanism. On the other ...

One very interesting thing I noticed with MySQL was that if you delete a database, ibdata file doesn’t shrink by that much space to minimize disk usage. I deleted the database and checked usage of /us...

MySQL DBA scripts The following various scripts as used for various different tasks when reviewing MySQL installations. Calculate Your MySQL Database Size Calculate Your Individual MySQL Schema...

1.如果客户端和服务器端的连接需要跨越并通过不可信任的网络，那么就需要使用SSH隧道来加密该连接的通信。 2.用set password语句来修改用户的密码，三个步骤，先“mysql -u root”登陆数据库系统，然后“mysql> update mysql.user set password=password('newpwd')”，最后执行“flush privileges”就可以了。...

虽然很少有人用linux下的mysql 客户端来维护数据，毕竟现在mysql 的客户端管理软件也多起来了，比较出名的有toad for mysql free . 不过像我这些习惯了unix 下用 sqlplus 管理oracle 的用户来说，还是觉得慢。   最近用 linux 下mysql 导入中文数据时老出问题。 在shell 下是正常的，但与php联后就乱码了。 原来ubuntu下mys...

mysql> SHOW CHARACTER SET LIKE 'latin%'; +---------+-----------------------------+-------------------+--------+ | Charset | Description                 | Default collation | Maxlen | +---------+...