getting repeating events between two dates

--_000_405F5CB98828FA4E9720B6EC52211CEC0BCB7955DBIOWAEVS09io wa_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

I have a table of events like this:

Evtuid
Evtname
Startdate
Stopdate
Repeats enum('true', 'false')
Monday enum('true', 'false')
Tuesday enum('true', 'false')
Wednesday enum('true', 'false')
Thursday enum('true', 'false')
Friday enum('true', 'false')
Satday enum('true', 'false')
Sunday enum('true', 'false')

An event might start on Monday Nov. 2 and occur on every Monday and Thursda=
y until November 26th. In which case startdate would equal 2009-11-02, sto=
pdate would equal 2009-11-26, repeats =3D 'true', Monday=3D'true', and Thur=
sday=3D'true'. The other days are false. Assume that the Evtuid=3D1 and E=
vtname=3D'Test Event'.

Is there a query I can run that will give me a listing of every date with a=
n event like this:

2009-11-02 Test Event 1
2009-11-05 Test Event 1
2009-11-09 Test Event 1
2009-11-12 Test Event 1
2009-11-16 Test Event 1
2009-11-19 Test Event 1
2009-11-23 Test Event 1
2009-11-26 Test Event 1

And of course any other dates with other events that either repeat or not.

Is there a way to do that or am I better off just using php and looping thr=
ough every day in the range?

Thanks!

Bob








--_000_405F5CB98828FA4E9720B6EC52211CEC0BCB7955DBIOWAEVS09io wa_--

socket "/tmp/mysql.sock" (2)

Hello All, I desperately need your help.

I migrated from version 5.0.27 =20
To version 5.0.77

Here is the command I used to migrate my databases:=20

mysqldump -uxxxxx -pxxxxx --all-databases --master-data | mysql -h88.88.8=
9.889 -urxxxx -pxxxxx


Problem: after the migration, I have been getting these messages:=20

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/=
tmp/mysql.sock' (2)


My question is, is it possible that I have destroyed ( clobbered) the MYS=
QL catalog via my migration process?

Can someone please help me
********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: socket "/tmp/mysql.sock" (2)

________________________________________
From: Brown, Charles
Sent: Tuesday, November 03, 2009 2:54 PM
To: Ramsey, Robert L; mysql@lists.mysql.com
Subject: socket '/tmp/mysql.sock' (2)

Hello All, I desperately need your help.

I migrated from version 5.0.27
To version 5.0.77

Here is the command I used to migrate my databases:

mysqldump -uxxxxx -pxxxxx --all-databases --master-data | mysql -h88.88.8=
9.889 -urxxxx -pxxxxx


Problem: after the migration, I have been getting these messages:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/=
tmp/mysql.sock' (2)


My question is, is it possible that I have destroyed ( clobbered) the MYS=
QL catalog via my migration process?

Can someone please help me
********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: RE: socket "/tmp/mysql.sock" (2)

--00c09f7d569497c656047787bf38
Content-Type: text/plain; charset=ISO-8859-1

Hi Charles,

Try this:

mysql -uxxxx -pxxxx -h127.0.0.1 -P3306

to force tcp instead of socket

Let me know!
Cheers
Claudio

On Nov 4, 2009 4:34 AM, "Brown, Charles" wrote:



________________________________________
From: Brown, Charles
Sent: Tuesday, November 03, 2009 2:54 PM
To: Ramsey, Robert L; mysql@lists.mysql.com
Subject: socket '/tmp/mysql.sock' (2)

Hello All, I desperately need your help. I migrated from version 5.0.27 To
version 5.0.77 Here ...

--00c09f7d569497c656047787bf38--

Re: socket "/tmp/mysql.sock" (2)

Hi Charles,

the socket is created either in the default location or in the location
specified in the 'my.cnf' configuration file under the [mysqld] section,
you can have different 'my.cnf' files in the system in different default
locations that are read in a cascading style sheet fashion (for the
locations look in the manual),
you can also specify one and only configuration file using the flag
--defaults-file=/path/to/my.cnf
Keep in mind that the socket file connection method works only on the
local system and only on unix/linux o.s.
So to not have the need to specify anything when using the 'mysql'
client program just specify the same path for the socket file under the
[mysql] and [mysqld] section of the 'my.cnf'.

Hope this helps

Claudio

Brown, Charles wrote:
>
> Claudio, It worked but here is a follow up question. Is this a
> circumvention or permanent fix. Why is it pointing to a
> /tmp/Mysql.sock when one socket exists in /var/lib/Mysql
>
>
>
> *From:* Claudio Nanni [mailto:claudio.nanni@gmail.com]
> *Sent:* Wednesday, November 04, 2009 2:54 AM
> *To:* Brown, Charles
> *Cc:* mysql@lists.mysql.com
> *Subject:* Re: RE: socket '/tmp/mysql.sock' (2)
>
>
>
> Hi Charles,
>
> Try this:
>
> mysql -uxxxx -pxxxx -h127.0.0.1 -P3306
>
> to force tcp instead of socket
>
> Let me know!
> Cheers
> Claudio
>
> On Nov 4, 2009 4:34 AM, "Brown, Charles" > > wrote:
>
>
>
> ________________________________________
> From: Brown, Charles
> Sent: Tuesday, November 03, 2009 2:54 PM
> To: Ramsey, Robert L; mysql@lists.mysql.com
>
> Subject: socket '/tmp/mysql.sock' (2)
>
> Hello All, I desperately need your help. I migrated from version
> 5.0.27 To version 5.0.77 Here ...
>
> ********************************************
> This message is intended only for the use of the Addressee and
> may contain information that is PRIVILEGED and CONFIDENTIAL.
>
> If you are not the intended recipient, you are hereby notified
> that any dissemination of this communication is strictly prohibited.
>
> If you have received this communication in error, please erase
> all copies of the message and its attachments and notify us
> immediately.
>
> Thank you.
> ********************************************
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org