Re: slow.log by date

2008-11-30 Thread chaim . rieger
Syslog-ng combined with logrotate --Original Message-- From: Fayland Lam To: mysql@lists.mysql.com Subject: slow.log by date Sent: Nov 30, 2008 18:22 well, our slow.log is pretty huge and say I just want the logs in the last week. (tail -n XXX is not good enough) I'm wondering there is

Re: slow.log by date

2008-11-30 Thread chaim . rieger
Write a perl script Am sure there are some out there Look at addons for awstats. --Original Message-- From: Fayland Lam To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: slow.log by date Sent: Nov 30, 2008 18:37 [EMAIL PROTECTED] wrote: > Syslog-ng combined with logrotate >

Re: MYSQL startup problem

2008-12-11 Thread chaim . rieger
It says that is started mysql Can you telnet to port 3306 ? Sent via BlackBerry from T-Mobile -Original Message- From: "BAJAJ POOJA" Date: Fri, 12 Dec 2008 08:27:02 To: Chandru Cc: Subject: RE: MYSQL startup problem Hi, Pls find logs attached below in mail: 080605 15:28:08

Re: MYSQL startup problem

2008-12-11 Thread chaim . rieger
When you do the following Mysql -h localhost -u root. What do you get ? Sent via BlackBerry from T-Mobile -Original Message- From: "BAJAJ POOJA" Date: Fri, 12 Dec 2008 08:43:45 To: ; Chandru Cc: Subject: RE: MYSQL startup problem Hi, It doesn't allows me to telnet port 3306. If

Re: installation nightmare

2008-12-19 Thread Chaim Rieger
installed mysql on freebsd may times. -- -- Chaim Rieger www.jravel.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Resend: enabling storage engine with RPM install

2009-02-19 Thread chaim . rieger
Perhaps you disabled it via my.cnf Sent via BlackBerry from T-Mobile -Original Message- From: Jim Lyons Date: Thu, 19 Feb 2009 22:45:01 To: MySQL Subject: Re: Resend: enabling storage engine with RPM install Yes, I had a slip of the mind. The engine that was not supported by the in

Re: Resend: enabling storage engine with RPM install

2009-02-19 Thread chaim . rieger
Can you post you my.cnf please Sent via BlackBerry from T-Mobile -Original Message- From: Jim Lyons Date: Thu, 19 Feb 2009 23:06:33 To: Cc: MySQL Subject: Re: Resend: enabling storage engine with RPM install How does one do that in my.cnf? It is possible to disable a supported engi

Re: Resend: enabling storage engine with RPM install

2009-02-19 Thread chaim . rieger
The answer is no Sent via BlackBerry from T-Mobile -Original Message- From: Jim Lyons Date: Thu, 19 Feb 2009 23:50:13 To: Cc: MySQL Subject: Re: Resend: enabling storage engine with RPM install What configuration parameter in the config file could have an impact on whether a partic

Re: moving data to MySQL

2009-02-21 Thread chaim . rieger
There are products out there that convert from ms sql to MySql. Though I would test them before trusting them --Original Message-- From: Chris Rehm To: mysql@lists.mysql.com Subject: moving data to MySQL Sent: Feb 21, 2009 10:47 I want to write some programs to work with data from eveon

Re: MySQL Log and Data directories

2009-03-04 Thread Chaim Rieger
? we do this on netapp. -- -- Chaim Rieger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: A good US Hosting Site?

2009-04-19 Thread Chaim Rieger
Dreamhost is decent Sent via BlackBerry from T-Mobile -Original Message- From: Cameron Rogers Date: Sun, 19 Apr 2009 20:42:27 To: Subject: A good US Hosting Site? Hi everyone. I am starting my first web site. I have a temporary contract with godaddy but know there are better opti

Re: Best way to convert character set from "latin1 to utf8" for existing database?

2009-06-07 Thread Chaim Rieger
Export schema Export data Change exported schema to utf8 Import schema into new db Import exported data into new db Sent via BlackBerry from T-Mobile -Original Message- From: Darryle Steplight Date: Sun, 7 Jun 2009 22:52:22 To: Uma Bhat Cc: ewen fortune; Subject: Re: Best way to conv

Re: Join

2009-06-28 Thread Chaim Rieger
Oops --Original Message-- From: Mark Farnsworth To: mysql@lists.mysql.com Subject: Join Sent: Jun 28, 2009 15:40 Join -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=chaim.rie...@gmail.com Sent via Bla

Re: strange authentication issue

2010-07-31 Thread chaim rieger
Just a stab but what's the max connect set to ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: strange authentication issue

2010-07-31 Thread chaim rieger
Another thing I just noticed In your first example you are using localhost, which probably means you are connecting via network The second option you don't define a host, which means you're prolly using socket connection -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: Matrix Stats Login

2010-09-24 Thread chaim rieger
Oops --Original Message-- From: Tompkins Neil To: [MySQL] Subject: Matrix Stats Login Sent: Sep 24, 2010 09:41 User fifaleagues Pass DrUch929eHek9Huwa7HAcH6wRUk5QaTr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:

Re: Design advice for hotel availability program

2012-02-20 Thread Chaim Rieger
On 2/17/2012 4:01 AM, Tompkins Neil wrote: Hi, I'm in the process of starting to design a hotel booking system that will eventually consist of over 10,000 hotels all with different room types, rates and availability for different dates. My question is does anyone have any experience with regard

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread chaim . rieger
Do you have skip networkin in my.cnf ? --Original Message-- From: Jesse To: Curtis Maurand Cc: MySQL List Sent: Jul 17, 2008 16:54 Subject: Re: Accessing remote machine (Ubuntu) from Window My settings are the same, except I have the bind-address set to my local IP of 192.168.1.128. I

Re: Spaces in sourced file names?

2008-07-21 Thread chaim . rieger
Ls -la file\ name.file \ Will escape the space for ya me believes --Original Message-- From: Jerry Schwartz To: mysql@lists.mysql.com Sent: Jul 21, 2008 13:48 Subject: Spaces in sourced file names? In the CLI, is there any way to source a file whose name has whitespace in it (particular

Re: Access denied for user 'debian-sys-maint'@'localhost'

2008-07-21 Thread chaim . rieger
Do you login via sock or network ? Didja change the passwd for localhost and % ? --Original Message-- From: Jesse To: MySQL List Sent: Jul 21, 2008 17:35 Subject: Access denied for user 'debian-sys-maint'@'localhost' OK. This is driving me Nutz 8-p Any time I try to restart mysql, I get

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Chaim Rieger
twork-wide configuration? can you post the output of ifconfig please thanx -- -- Chaim Rieger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Chaim Rieger
Skip Evans wrote: Chaim Rieger wrote: Skip Evans wrote: can you post the output of ifconfig please bge0: flags=8843 mtu 1500 options=1a inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1 inet 192.168.1.100 netmask 0xff00 broadcast 192.168.1.255 bge1

Re: Blocking HTML code in inserts?

2008-08-02 Thread chaim . rieger
Doubt this can be done easily if at all. Accept only text and no html. But even that should be the job of the form validator --Original Message-- From: Skip Evans To: mysql@lists.mysql.com Sent: Aug 2, 2008 14:16 Subject: Blocking HTML code in inserts? Hey all, What is the most effect

Re: mysqldump questions

2008-08-22 Thread chaim . rieger
Whatever you name it Wherever you place it Mysqldump (options) > filename --Original Message-- From: Nanu Kalmanovitz Sender: To: mysql@lists.mysql.com Sent: Aug 22, 2008 23:48 Subject: mysqldump questions Hi! What is the name dumped file and where it is created? System is :Novell 6

Re: multiple mysql service on the same server

2008-08-24 Thread chaim . rieger
Right Keep them in the datadir to make things easier for you Sent via BlackBerry from T-Mobile -Original Message- From: "Ananda Kumar" <[EMAIL PROTECTED]> Date: Sun, 24 Aug 2008 23:47:24 To: Jim Lyons<[EMAIL PROTECTED]> Cc: mysql Subject: Re: multiple mysql service on the same server

Re: STORE MYSQL DATA ON TWO HARDDISK

2008-10-13 Thread chaim . rieger
Move your logs to the second drive I wouldn't do this, but you can move a db to drive2 and link it into the /data/dir --Original Message-- From: Krishna Chandra Prajapati To: mysql@lists.mysql.com Sent: Oct 13, 2008 22:33 Subject: STORE MYSQL DATA ON TWO HARDDISK Hi, I have two hard di