MySQL Administrator 1.2.15 is fails with the same problem. Do anyone have
any other suggestions ?
-- Forwarded message --
From: Tompkins Neil
Date: Fri, Oct 15, 2010 at 11:21 AM
Subject: Re: Backing up MySQL using PHPMyAdmin problem with UTF-8
To: Michael Dykman
Cc: "[MySQL]"
Hi,
I've the following query
SELECT COUNT(players_id) AS players_count
FROM players
WHERE teams_id > 0
GROUP BY teams_id
ORDER BY players_count DESC
However, I've another field called original_teams_id and want to include the
COUNT with players_count, when original_teams_id = teams_id
Cheers
Ne
Hiya
I run MySQL Master - Master Replication. Ive had an interesting
situation whereby I failed over using heartbeat but whats is
interesting is that via the application (vbulletin), I see that the
forums was showing that a weeks ago data.
I had to re fail over to the original server and th
Hello List,
i am trying to install mysql on debian lenny from source. Here is what
i did (yes, i did read the INSTALL-SOURCE):
./configure --prefix=/usr/local/mysql/
make -j 4 && make install
cp support-files/my-medium.cnf /etc/my.cnf
cd /usr/local/mysql
chown -R mysql .
chgrp -R mysql .
bin/m
Good afternoon...
I had a huge issue this weekend, we had a table crash (again), it is a
high usage table, where there are MANY writes, and reads from it all the
time (it is a radius accounting table). the problem is, is that i did:
check table radius.radacct201010 quick
and it came back fine...
you should read the INSTALL file more patient,and know the difference
between prefix & exec-prefix.
Best regards,
Sharl.Jimh.Tsin (From China)
2010/10/18 ml ml :
> Hello List,
>
> i am trying to install mysql on debian lenny from source. Here is what
> i did (yes, i did read the INSTALL-SOURCE)
Hi,
I am using the following version of MySQL on my Mac OS X Server 10.5.8:
*** Ver 14.14 Distrib 5.4.1-beta, for apple-darwin9.5.0 (i386) using
readline 5.1 ***
In order to restrict root account login from localhost only, I did the
following:
mysql> DELETE FROM user WHERE user = 'root' AND host
