MySQL Administrator 1.2.15 is fails with the same problem. Do anyone have
any other suggestions ?
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Fri, Oct 15, 2010 at 11:21 AM
Subject: Re: Backing up MySQL using PHPMyAdmin problem with UTF-8
To:
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
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
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 .
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 mliebher...@googlemail.com:
Hello List,
i am trying to install mysql on debian lenny from source. Here is what
i did (yes, i did
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