02-25-2010
How to get protocol, characterset, mysql info?
Hi,
I know the API to get protocol version, character set etc. If I want to find out the current protocol version, current user character set, mysql info, mysql server info wihtout using these API -
mysql_get_server_info()
mysql_info()
mysql_get_proto_info()
mysql_character_set_name()
mysql_get_client_info().
Is there any other way to get these information without using API?
I don't want to use API instead Shall I get these information from Infomrmation_schema?
Can I fetch these information directly accessing enviornment variable if possible?
---------- Post updated 02-25-10 at 12:53 AM ---------- Previous update was 02-24-10 at 11:49 PM ----------
I find out the value of protocol, version, character set, host name using
select @@hostname
select @@version
select @@protocol_version
select @@character_server_set.
But couldn't find out the how to get values of
mysql_get_client_info()
mysql_info()
mysql_stat()
mysql_thread_safe()
without using it in the same manner used for protocol,character set etc.
5 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. Shell Programming and Scripting
Hi,
I need some help to get decimal value of some particluar character set
for e.g.
in windows-1251 characterset
ж --> 230
Please help and suggest way to achive same. (7 Replies)
Discussion started by: peeyushgehlot
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. Shell Programming and Scripting
Hi Friends,
I am not able to conver character set from UTF-8 to IBM-284 throwing an error "cannot open convertor" . Could you please help me how to get out of this error.
Below command is working fine
iconv -f ISO8859-15 -t UTF-8 fromfile.txt > tofile.txt
But the below command is... (2 Replies)
Discussion started by: sivakumarl
2 Replies
LEARN ABOUT DEBIAN
dbix::searchbuilder::handle::mysql
DBIx::SearchBuilder::Handle::mysql(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::mysql(3pm)
NAME
DBIx::SearchBuilder::Handle::mysql - A mysql specific Handle object
SYNOPSIS
DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of MySQL.
METHODS
Insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported.
SimpleUpdateFromSelect
Customization of "SimpleUpdateFromSelect" in DBIx::SearchBuilder::Handle. Mysql doesn't support update with subqueries when those fetch
data from the table that is updated.
DatabaseVersion
Returns the mysql version, trimming off any -foo identifier
CaseSensitive
Returns undef, since mysql's searches are not case sensitive by default
SimpleDateTimeFunctions
Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
ConvertTimezoneFunction
Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.
Use the following query to get list of timezones:
SELECT Name FROM mysql.time_zone_name;
Read docs about keeping timezone data up to date:
http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
DBIx::SearchBuilder, DBIx::SearchBuilder::Handle
perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::mysql(3pm)