Adding a second slave and Load Data from master questions

stopped at log 'mysql-bin.000256' position 4 May 4 09:30:06 localhost mysqld[29920]: 060504 9:30:06 [ERROR] Slave I/O thread killed while reading event May 4 09:30:06 localhost mysqld[29920]: 060504 9:30:06 [ERROR] Slave I/O thread exiting, read up to log 'm

Conditionals in group by

SELECT sum(if(eventtype='click',1,0)) as clicks,sum(if(eventtype='view',1,0)) as view from xy group by somethingelse note the conditional inside the sum. wheres a good source of information on complex statistical queries like this

Re: 4.0 -> 4.1 lose timestamp [fixed]

the issue was because i was viewing the database through cocoamysql, which registered the timestamps as null. stupid me viewing the database through the commandline showed up fine --- Hunter Peress

4.0 -> 4.1 lose timestamp

i may just have to dump/load instead of copy files. --- Hunter Peress [EMAIL PROTECTED] Web Programer The Santa Fe New Mexican, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To