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
Code:
/etc/init.d/mysqld restart
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
mysql_zap
zap(1) MySQL database zap(1)NAME
zap - a perl script used to kill processes
USAGE
/usr/bin/mysql_zap [-signal] [-?Ift] pattern
SYNOPSIS
zap [-I|-?] [-f] [-t]
DESCRIPTION
zap supports by executing
-I|-? info
-f force
-t test
NOTE
If -f isn't given, ask user for confirmation for each process to kill. If signal isn't given, try first with signal 15 and after that with
signal 9. If -t is given the processes is only shown on stdout.
SEE ALSO isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
lege_tables(1), mysqlshow(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 zap(1)