Do not post email addresses in a question, it is against the rules. The solutions here are supposed to help everybody. No, you may not harass me on MSN.
You edit my.cnf by... editing my.cnf. It's a text file, that you edit using a text editor, like vi or nano. The file may be placed under /etc/my.cnf, /etc/mysql/my.cnf, or something like that; it can vary from distribution to distribution. After you edit the configuration file, you restart the mysql server with something like
The exact command may vary from distribution to distribution.
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)
No help guys??? :(
Hi guys, i've got a question here... my intention is to write a script that would access a mysql db and extract some info and paste it into a file...
so the first move would be, to access the mysql interface right? hence...
#! /usr/bin/ksh
echo "Job Begin: " `date`
... (1 Reply)
Hi everyone,
I have an urgent requirement to get some table data from Linux-MYSQL server from HP-UX with oracle database.Is there any way we can get
connected through Shell script from HP-UX and issue select on mysql to get some table data?
Please help me out. (7 Replies)
Hi, we have some problem with mysql high cpu , would like some help with MySQL Tuning
here are the mysqltuner & tuning-primer details
mysqltuner:
# mysqltuner
>> MySQLTuner 1.1.1 - Major Hayden <major@mhtx.net>
>> Run with '--help' for additional options and output filtering
--------... (1 Reply)
Hi,
I have installed mysql in linux box as mysql-5.0.77-4.el5_6.6..
I would like to start the server. But there is no mysql file in this location /etc/init.d/
Please advice how to start the server now !!
Thnaks,
Mani (5 Replies)
Hi all,
I installed centos 5, with LAMP.
httpd is working fine, ssh, ftp all working ok.
But, when I try to use mysql its not,
when I give the command
mysql
I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (4 Replies)
Hello
Please advise me how can I optimize my MySQL server. Or advise which way to look. Maybe someone had similar problems?
Over the past two weeks the MySQL server dropped 2 times. I began searching for ways to optimize the server.
Overall the picture like that:
There is a separate... (2 Replies)
Gd evening
I am trying to run my website made in php-mysql on a HP-UX system but dont know how to install and run services of Mysql.
Kindly provide appropriate solution.
thanks in advance. (1 Reply)
Discussion started by: kumar.ashishcs
1 Replies
LEARN ABOUT OPENSOLARIS
mysqld_safe
safe_mysqld(1) MySQL database safe_mysqld(1)NAME
mysqld_safe - start the mysqld daemon on Unix.
SYNOPSIS
mysqld_safe [--basedir=path] [--core-file-size=#] [--defaults-extra-file=path] [--defaults-file=path] [--open-files=#] [--datadir=path]
[--err-log=path] [--ledir=path] [--log=path] [--no-defaults] [--open-files=#] [--pid-file=path] [--port=#] [--socket=path] [--timezone=#]
[--user=#]
DESCRIPTION
mysqld_safe adds some safety features such as restarting the server when an error occurs and logging run-time information to a log file.
--basedir=path
--core-file-size=#
Size of the core file mysqld should be able to create. Passed to ulimit -c.
--defaults-extra-file=path
--defaults-file=path
--datadir=path
--err-log=path
--ledir=path
Path to mysqld
--log=path
--no-defaults
--open-files=#
Number of files mysqld should be able to open. Passed to ulimit -n.
--pid-file=path
--port=#
--socket=path
--timezone=#
Set the timezone (the TZ) variable to the value of this parameter.
--user=#
NOTE
Note that all options on the command line to mysqld_safe are passed to mysqld. If you wants to use any options in mysqld_safe that mysqld
doesn't support, you must specify these in the option file.
SEE ALSO isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(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 war-
ranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurme-
dia.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 safe_mysqld(1)