Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Mysql
Top Forums UNIX for Advanced & Expert Users Mysql Post 83165 by Unbeliever on Monday 12th of September 2005 06:54:40 AM
Old 09-12-2005
You cannot simply create the mysql.sock file on your Redhat system. This is not a standard file but a 'socket' through which a process can communicate with the mysqld process. It is used on the local machine (rather than comunicating directly via tcp) because it's more efficient.

To be honest it looks like you've got 2 different versions of mysql on the your Redhat box and the mysqldump you are running is not from the same base install as the server.

Can you do a 'ps -elf' and check which mysqld (or possibly safe_mysqld) is currently running? Make sure its the one in /usr/local/mysql/bin. If it is then you need to check to see if the 'default socket file' has been overridden. This could of been done on the command line when mysqld was started or in the 'my.cnf' file. The 'my.cnf' file unfortunately could again be in a standard location (/etc/my.cnf, /etc/mysql/my.cnf, /usr/local/mysql/mf.cnf etc etc) or could be specified on the command line.
 

6 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

MySQL on my server is down.... I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock Any suggestions? Here's what I can't do: can't be root don't have physical access (do stuff via SSH) reinstall MySQL (need to keep the current MySQL... (8 Replies)
Discussion started by: _hp_
8 Replies

2. UNIX for Advanced & Expert Users

mysql would not start: missing mysql.sock

I recently installed mysql-standard-5.0.21-solaris9-sparc-64bit.pkg on a Solaris 9 machine (SunOS 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250). The package installation went very smooth, however, starting mysql is a different story. I get the message below everytime I try to start mysql: #... (2 Replies)
Discussion started by: xnightcrawl
2 Replies

3. Red Hat

MySQL conflicts with mysql-3.23.58-16.RHEL3.1

I am tring to install mysql 5.0 on redhat linux3. In this server mysql 3 is already installed and hence while I install mysql 5 it gives the following error. How I can install mysql 5 with out affect previous installation? bash-2.05b# rpm -i MySQL-server-community-5.0.41-0.rhel3.i386.rpm... (2 Replies)
Discussion started by: johnveslin
2 Replies

4. Linux

mysql

Hi all, How I can find out how long is mysql server is down and is it writing data or not? thanks, (2 Replies)
Discussion started by: email-lalit
2 Replies

5. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)... (3 Replies)
Discussion started by: jastanle84
3 Replies

6. Programming

Mysql++

code: #include <mysql/mysql.h> #include <my_global.h> int main(int argc, char **argv) { MYSQL *conn; conn = mysql_init(NULL); mysql_real_connect(conn, "localhost", "zetcode", "passwd", "testdb", 0, NULL, 0); mysql_query(conn, "use vobd_db"); mysql_query(conn, "select *... (1 Reply)
Discussion started by: raj6
1 Replies

LEARN ABOUT CENTOS

rhnreg_ks

RHNREG_KS(8)							   Red Hat, Inc.						      RHNREG_KS(8)

NAME

       rhnreg_ks - A program for non interactively registering systems to Spacewalk Server, Red Hat Satellite or Red Hat Network Classic.

SYNOPSIS

       rhnreg_ks [options]

DESCRIPTION

       rhnreg_ks  is  a  utility  for  registering  a  system with the "Spacewalk Server", "Red Hat Satellite" or "Red Hat Network Classic". It is
       designed to be used in a non-interactive environment  (a kickstart style install, for example).	All the information can  be  specified	on
       the command line or stdin.

OPTIONS

       --profilename
	      Specify  the profile name that should be used as an identifier for the system in Spacewalk Server, Red Hat Satellite or Red Hat Net-
	      work Classic

       --username
	      The username to register the system with under Spacewalk Server, Red Hat Satellite or Red Hat Network Classic. This can be an exist-
	      ing Spacewalk, Red Hat Satellite or Red Hat Network Classic username, or a new username.

       --password
	      The password associated with the username specified with the --username option. This is an unencrypted password.

       --activationkey
	      Specify/use a serial number to associate with the system. This is optional, but activation keys can really simplify the registration
	      process. Learn more about activation keys in the online RHN documentation.

       --contactinfo
	      This option has been deprecated. Please login to the server web user interface and update your contactinfo.

       --nohardware
	      Do not probe or upload any hardware information.

       --nopackages
	      Do not profile or upload any package information.

       --novirtinfo
	      Do not profile or upload any virtualization information.

       --norhnsd
	      Do not start rhnsd after completion.

       --force
	      Register the system even if it has already been registered.

       --version
	      Show the version of rhnreg_ks.

       --proxy
	      Specify a HTTP proxy to use.

       --proxyUser
	      Specify a username to use with an authenticated HTTP proxy.

       --proxyPassword
	      Specify a password to use with an authenticated HTTP proxy.

       --sslCACert
	      Specify a path to a SSL CA certificate to use.

       --serverUrl
	      Specify a URL to as the server.

       -h, --help
	      Show a help message and exit.

FILES

       /etc/sysconfig/rhn/systemid
	      The digital server ID for this machine if the system has been registered onto "Spacewalk Server", "Red Hat Satellite"  or  "Red  Hat
	      Network Classic".  This file does not exist otherwise.

       /etc/sysconfig/rhn/up2date
	      The common configuration file used by RHN client programs.

EXAMPLES

       Register a new system to Spacewalk / Red Hat Satellite / Red Hat Network Classic:

	      rhnreg_ks --profilename "example_profile_name" --username "someexampleuser" --password "foobar"

SEE ALSO

       rhn_check(8), rhn_register(8), rhnsd(8), rhn-profile-sync(8), rhnplugin(8), up2date(5).

AUTHORS

       See the AUTHORS file included with this software.

       This manual page was written by Adrian Likins <alikins@redhat.com> and James Bowes <jbowes@redhat.com>

BUGS

       Report bugs to <http://bugzilla.redhat.com>.

COPYRIGHT

       Copyright (C) 1999-2011 Red Hat, Inc.

       This is free software; see the source for copying conditions.  There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
       LAR PURPOSE.

Linux								  2011 February 4						      RHNREG_KS(8)
All times are GMT -4. The time now is 09:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy