manipulating count group by statement

Hello everyone, I have a mysql table tha holds a variety of ip address. I am trying to work out a select statement that will give me a count(*) grouped by the first 2 octets of the ip. if the ip table contains: 10.102.1.1 192.168.123.34 192.168.123.4 192.168.123.43 192.168.123.3

safe_mysqld not letting go of tty on remote start

Hey guys, Anyone ever notice that when you restart mysql ( whether is be thru mysql.server or ${MYSQL}/bin/sae_mysqld the tty stays connected. Thanks, Chad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: safe_mysqld not letting go of tty on remote start

, and overwrites your shell prompt. Hit enter, and you will probably find that you have a prompt afterall. chad kellerman wrote: Hey guys, Anyone ever notice that when you restart mysql ( whether is be thru mysql.server or ${MYSQL}/bin/sae_mysqld the tty stays connected. Thanks

Re: MYSQL Quota

Alex, Mysql does not do quota for users (atleast as far as I know). But I read once in sysadmin mag that an programmer at an isp wrote a mysql quota daemon. The article is not on the web but here is the issue: http://www.sysadminmag.com/articles/2002/0202/ There is a link on the left

replication questions

Hello everyone, The mysql documentation about replication is great at describing how to replicate fomr one master server. If i want to replicate many db servers to one replication server is there a way I can edit the my.cnf file to do this. Or would it be better to have another conf

easy question

to have the timestamp automatically inserted when an insert statement is run? The timestamp of the insert statement. thanks for the help, chad -- Chad Kellerman - Before posting, please check: http://www.mysql.com

Reseting auto_incremented id's

calls thru my script? Is there any other way to do this? Thanks for the help -chad -- Chad Kellerman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: query mysql db from a bash script?

Takacs, I think you can use mysql --execute=select * from whatever databasename you should be able to execute mysql command thru bash that way. chad On Tue, 19 Mar 2002 10:20:08 +0100 Takacs Istvan [EMAIL PROTECTED] wrote: Hi Is that possible to query the database from a bash

Re: MySql on Solaris

Ahmed, Forget about it. I tried to do this, I tried for about two weeks, then got mad and downloaded the src and compile it mysql. It works great. -chad if you do get it working let me know On Thu, 07 Mar 2002 09:14:58 -0700 Ahmed S K Anis [EMAIL PROTECTED] wrote: Hi members, This

Re: MysqlReplication

It can be done. The slave server needs to hold mutiple slave databases corresponding to the masters. Each slave instance needs to be start separately. For example, each database wil need it's own my.cnf file holding with port the master is connecting to. I have seen this done with full

Re: MySQL replication error

(CreateStamp) VALUES (NOW())' Skip_counter: 0 1 row in set (0.00 sec) -Original Message- From: chad kellerman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 5:18 PM To: Luc Foisy Cc: [EMAIL PROTECTED] Subject: Re: MySQL replication error Luc, I new

Re: MySQL replication error

Luc, I new to this mailinglist ( this is my first posting) But I have worked a little with replication. Try if the replicator is still down. set sql_slave_skip_counter = 1; slave start on the slave as long as you are sure the master is ok. Let me know is this worked. -chad On Thu,