[TriLUG] mysql weirdness

[Kevin Miller]

MySQL has two modes of connectivity: 'localhost', which uses a Unix domain
socket (e.g. /tmp/mysql.sock) or TCP. If you specify -hlocalhost, it will
use the domain socket (default). If you specify
-hmyhostname.example.org<http://hmyhostname.example.org>,
it will use TCP. Often permissions are setup to allow access from localhost
but not TCP.

-Kevin

On 11/1/05, Jeff The Riffer <riffer at vaxer.net> wrote:
>
>
> I have a server with a monthly cron job that rotates a large mysql
> database (syslog records). It's been working fine for months. Than
> sometime in August it stopped working.I didn't notice until today thanks
> to not having previously been forwarding e-mail from root.
> (woops)
>
> Ok, so now the script does a mysqldump on an archive database, purges the
> database, copies the existing syslog data to the archive database and then
> deletes the archived data from the live DB.
>
> Now everyone one of these steps generates the same error:
>
> ERROR 2003: Can't connect to MySQL server on 'hostname' (110)
>
> Which is quite strange, since mysqld is running, I can interactively
> connect and everything is running normally as far as I can tell. It takes
> a rather long time for the error to pop-up but I can reproduce it from the
> command-line.
>
> So I'm stumped. Why would:
>
> mysqldump -a -B syslogarchiveDB -C -e -F -h hostname -u root -ppassword >
> syslog-dumps/syslog.0
>
> give an error but:
>
> mysql -u root -ppassword
>
> work fine? *scratches head*
>
> Any suggestions? If mysqld has a debug mode I'd like to enable it.
>
> ####################==============----
> ----==============####################
> # riffer at vaxer.net - Jeff The Riffer - Drifter... - Homo Postmortemus #
> # Disclaimer: I am not a number, I am a free man, and my thoughts are my
> own. #
> # GCS$ d-- H++ s:++ !g p+ au0 a31 w+ v?(*) C++ UA P? L 3 E---- N++ K- W--
> M+ V#
> # po--- Y+ t+ 5+ !j R G' tv b+ D++ B--- e+ u--- h--- f+ r+++ n- y+++* #
> --
> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
> TriLUG Organizational FAQ : http://trilug.org/faq/
> TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
>