10-29-2001
mysql problem
When I varify the mysql-server package it says that theres a problem with /var/log/mysqld.log . I went there and found nothing. Also when I do "mysql &" it comes back with a error saying connot connect to local mysql server through socket '/var/lib/mysql/mysql.sock . I went there and nothing was there. It seems that the mysql server package out of the redhat box may have a problem. I've varified the mysql server package right off the disk and it comes back with a problem warning.
6 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i am a newbie to unix admin stuff so bare with me. -- i get this message when executing mysql_install_db during the installation of mysql. what is the cause of this and how can it be fixed. btw - i have tried installing as root and other accounts also.
scripts/mysql_install_db:... (6 Replies)
Discussion started by: theDirtiest
6 Replies
2. UNIX for Advanced & Expert Users
I am new to mysql database ,
we have a mysql database running on linux , and we use mysql database for bugzilla, so we wanted to take a backup .
what is the command for taking the entire database backup
from the command prompt with all options.
Thanks in advance
Bache Gowda (4 Replies)
Discussion started by: bache_gowda
4 Replies
3. Web Development
hi all,
After installing MySQL Source Code on my RedHat machine and compiling it, i no longer have access to some of my DBs having this error message.
Unkown table Engine 'InnoDB'
Before this step, i used to have another MySQL instance that used to work properly with all the DBs i do have,... (7 Replies)
Discussion started by: mehdi1973
7 Replies
4. 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
5. Red Hat
Hello,
can someone please suggest me in configuring the mysql db on redhat cluster, I have few questions.
1. where do I have to configure heart beat links, and is there any file in the redhat cluster that we update it to use these ipaddress and these interface on the node.
2. I am configuring... (0 Replies)
Discussion started by: bobby320
0 Replies
6. UNIX for Advanced & Expert Users
Hi,
I am having a text file with the following contents
###########
File1
###########
some
page1.txt
text
page.txt
When I sort this file on Red Hat 5, then I get the following output
###########
File1
###########
page1.txt
page.txt
some (3 Replies)
Discussion started by: sarbjit
3 Replies
LEARN ABOUT OPENSOLARIS
mysqlshow
mysqlshow(1) MySQL database mysqlshow(1)
NAME
mysqlshow
- Shows the structure of a mysql database (databases,tables and columns)
USAGE
shell> mysqlshow [OPTIONS] [database [table [column]]]
SYNOPSIS
mysqlshow [-#|--debug=...] [-?|--help] [-c|--character-sets-dir=...] [-C|--compress] [-h|--host=...] [-i|--status] [-k|--keys]
[-p|--password[=...]] [-P|--port=...] [-S|--socket=...] [-u|--user=#] [-V|--version]
DESCRIPTION
-#|--debug=...
output debug log. Often this is 'd:t:o,filename`
-?|--help
display help and exit
-c|--character-sets-dir=...
Directory where character sets are
-C|--compress
Use compression in server/client protocol
-h|--host=...
connect to host
-i|--status
Shows a lot of extra information about each table
-k|--keys
show keys for table
-p|--password[=...]
password to use when connecting to server If password is not given it's asked from the tty.
-P|--port=...
Port number to use for connection
-S|--socket=...
Socket file to use for connection
-u|--user=#
user for login if not current user
-V|--version
output version information and exit
NOTE
If last argument contains a shell or SQL wildcard (*,?,% or _) then only what's matched by the wildcard is shown. If no database is given
then all matching databases are shown. If no table is given then all matching tables in database are shown If no column is given then all
matching columns and columntypes in table are shown
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), 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 mysqlshow(1)