09-12-2005
If you use some sort of GUI to connect to the database, you may be able to find somewhere that display a list of server variables. If you use command-line, use the "show variables" command, and post here the value for the "socket" option displayed. Note that you should pass nearly the same set of arguments as mysql to mysqldump. If mysql works, so should mysqldump.
Last edited by cbkihong; 09-12-2005 at 08:27 AM..
6 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
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
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
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
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
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