The never ending game of MySQL :( - Now something weird happnes
I had mysql installed on my unix system but for some reason it wasn't starting up when I changed the datadir in my.cnf located in etc. It was saying that there's some permission problem. But, I double checked everything and everything looked fine. I wanted to install the latest version of mysql, so I removed the existing version.
Now I just downloaded the server, client and shared community libraries of mysql and installed them using rpm. Now, I don't find a my.cnf file nor does this command: "/etc/init.d/mysqld start" work. And here's the messages:
But when I type mysql it is running and gives me a prompt too and as far as I remember, it shows me the databases in /var/lib/mysql. Can someone help me out please?
Last edited by Legend986; 01-05-2008 at 04:56 AM..
hello,
I a problem. I would like write script in True64 Unix.see below.
last testerkl | head > mailfile.asc
wolteru < mailfile.asc
With the "last" command I get a list when testerkl logged on. And I would like to send this to a user. But how can I write in a "ctrl.-d" and "ctrl.-c" that... (2 Replies)
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)
Hi All,
I m very new to unix.
I have a basic doubt ..
In unix I m seeing that there is a * at the end of by executable name (exe1*)..
Wht is the significance of that
Thanks a lot in advance (2 Replies)
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)
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)
Hi,
The first if loop in the script not ending and going to infinite loop.
#!/usr/bin/ksh
set -vx
lc=1
st_date=$(date "+%Y%m%d")
LOGFILE=/home/infa_shared/OM_ftp_transfer.log.$st_date
file="/home/infa_shared/OM_WF.log.$st_date"
while ]; do
if ]
then
sleep 15
let lc=lc+1
print... (4 Replies)
Discussion started by: nag_sathi
4 Replies
LEARN ABOUT OPENSOLARIS
mysqld_multi
mysqld_multi(1) MySQL database mysqld_multi(1)NAME
mysqld_multi - is meant for managing several mysqld processes running in different UNIX sockets and TCP/IP ports.
USAGE
mysqld_multi [OPTIONS] {start|stop|report} [GNR,GNR,GNR...]
SYNOPSIS
mysqld_multi [--config-file=...] [--example] [--help] [--log=...] [--mysqladmin=...] [--mysqld=...] [--no-log] [--password=...]
[--tcp-ip] [--user=...] [--version]
DESCRIPTION
mysqld_multi
--config-file=...
Alternative config file. NOTE: This will not affect this program's own options (group [mysqld_multi]), but only groups [mysqld#].
Without this option everything will be searched from the ordinary my.cnf file.
--example
Give an example of a config file.
--help Print this help and exit.
--log=...
Log file. Full path to and the name for the log file. NOTE: If the file exists, everything will be appended.
--mysqladmin=...
mysqladmin binary to be used for a server shutdown.
--mysqld=...
mysqld binary to be used. Note that you can give mysqld_safe to this option also. The options are passed to mysqld. Just make sure
you have mysqld in your environment variable PATH or fix mysqld_safe.
--no-log
Print to stdout instead of the log file. By default the log file is turned on.
--password=...
Password for user for mysqladmin.
--tcp-ip
Connect to the MySQL server(s) via the TCP/IP port instead of the UNIX socket. This affects stopping and reporting. If a socket file
is missing, the server may still be running, but can be accessed only via the TCP/IP port. By default connecting is done via the
UNIX socket.
--user=...
MySQL user for mysqladmin.
--version
Print the version number and exit.
NOTE
Please see the mysql manual for more detailed information on this.
SEE ALSO isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_safe(1), mysqldump(1), mysql_fix_privilege_tables(1),
mysqlshow(1), mysql_zap(1), perror(1), replace(1)
For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
at http://www.mysql.com/doc/en/
BUGS
Please refer to http://bugs.mysql.com/ to report bugs.
AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no
warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur-
media.com)
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+------------------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+------------------------------------+
|Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
+--------------------+------------------------------------+
|Interface Stability | External |
+--------------------+------------------------------------+
NOTES
Source for mysql is available on http://opensolaris.org.
MySQL 4.0 19 December 2000 mysqld_multi(1)