![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mysql
unixboy_xujf
这个作者很懒,什么都没留下…
展开
-
Mysql Cluster: The definitive HOWTO
Mysql Cluster: The definitive HOWTOThis 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...原创 2008-07-29 14:55:20 · 108 阅读 · 0 评论 -
mysql 打竖显示结果
加个\G在最后现就可以了.mysql> select * from mailbox \G*************************** 1. row ***************************username: unixboy@abc.compassword: $1$15d22544$D/Y8M.my6mHd6CPZSQJQB. name: unixboy mai...2008-05-28 10:31:33 · 1192 阅读 · 0 评论 -
dump data into txt file
mysql> select * from DirectoryMaster limit 1000 into outfile '/tmp/DirectoryMaster.txt' fields terminated by '|';Query OK, 1000 rows affected (0.02 sec)2008-05-10 15:42:39 · 150 阅读 · 0 评论 -
Using Master/Slave Replication with ReplicationCon
25.4.4.6. Using Master/Slave Replication with ReplicationConnectionStarting with Connector/J 3.1.7, we've made available a variant of the driver that will automatically send queries to a read/...2008-04-28 15:51:04 · 75 阅读 · 0 评论 -
How To Control Mysql Replication
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...2008-04-28 15:46:42 · 69 阅读 · 0 评论 -
Implementing High Availability in MySQL
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 ...2008-04-16 08:04:51 · 120 阅读 · 0 评论 -
innodb data file per table
One very interesting thing I noticed with MySQL was that if youdelete a database, ibdata file doesn’t shrink by that much space tominimize disk usage. I deleted the database and checked usage of/us...2008-04-16 08:04:05 · 99 阅读 · 0 评论 -
MySQL dba Script
MySQL DBA scriptsThe following various scripts as used for various different tasks when reviewing MySQL installations.Calculate Your MySQL Database Size Calculate Your Individual MySQL Schema...原创 2009-10-17 11:56:02 · 174 阅读 · 0 评论 -
使用MySQL的23个注意事项
1.如果客户端和服务器端的连接需要跨越并通过不可信任的网络,那么就需要使用SSH隧道来加密该连接的通信。2.用set password语句来修改用户的密码,三个步骤,先“mysql -u root”登陆数据库系统,然后“mysql> update mysql.user set password=password('newpwd')”,最后执行“flush privileges”就可以了。...原创 2009-09-26 16:55:33 · 63 阅读 · 0 评论 -
linux shell 下 用 mysql的中文问题
虽然很少有人用linux下的mysql 客户端来维护数据,毕竟现在mysql 的客户端管理软件也多起来了,比较出名的有toad for mysql free . 不过像我这些习惯了unix 下用 sqlplus 管理oracle 的用户来说,还是觉得慢。 最近用 linux 下mysql 导入中文数据时老出问题。 在shell 下是正常的,但与php联后就乱码了。 原来ubuntu下mys...2009-09-18 10:30:50 · 246 阅读 · 0 评论 -
A sample to update mysqm column charecter set
mysql> SHOW CHARACTER SET LIKE 'latin%';+---------+-----------------------------+-------------------+--------+| Charset | Description | Default collation | Maxlen |+---------+...原创 2010-10-21 12:58:28 · 110 阅读 · 0 评论