10 More Discussions You Might Find Interesting
1. Solaris
We have a user called mysql on our Solaris11 server. We don't user MySQL. It was not there last year. Is there a way to find out how it got created and when it was created? (3 Replies)
Discussion started by: jtamminen
3 Replies
2. Solaris
hi i need to upgrade my solaris mysql version.. can u guide me the upgrade steps..
my current version is
4.0.31-log
i need to upgrade to 5.0
..
thanks..
---------- Post updated at 12:04 PM ---------- Previous update was at 11:28 AM ----------
my solaris version is 10..
----------... (2 Replies)
Discussion started by: senkerth
2 Replies
3. Solaris
Came in tonight, and some people started getting this error message
note: users were getting this error in IE6 and in firefox, pages seemed to process fine in Chrome. :confused:
anyway...
So I decided to restart the MySQL service, now it will not restart. First tried:
root@bender:/>... (2 Replies)
Discussion started by: ippy98
2 Replies
4. Solaris
I am trying to connect to MySQL installed on windows from Solaris machine.
While doing this getting error as:
"Client does not support authentication protocol requested by server; consider upgrading MySQL client; errno = 1251"
I have installed mysql-5.1.34-solaris10-sparc.tar.gz on... (1 Reply)
Discussion started by: amit_27
1 Replies
5. Shell Programming and Scripting
Hi every body!
Any one ever tried to inject the output of JASS into mysql
or know of a method or script to do this
Thk
Dan (0 Replies)
Discussion started by: Ex-Capsa
0 Replies
6. Solaris
have installed and am using the GNU based tools from the Sunfreeware site to compile PHP. I already have Apache, MySQL, and Oracle compiled and working properly. Below is my configure string for my PHP build:
./configure --prefix=/usr/local/php5 \... (2 Replies)
Discussion started by: sunsysadm2003
2 Replies
7. UNIX and Linux Applications
I have 4 solaris 8 servers running mysql 5.0.22. I am considering upgrading to solaris 9 and wanted to know if mysql needs to be recompiled for mysql to run under solaris 9.
Thank you (4 Replies)
Discussion started by: csgonan
4 Replies
8. UNIX for Dummies Questions & Answers
Folks;
i have mysql installed on Solaris box (sparc).
The problem is under /opt/mysql/data directory, there's a log file that grows very fast & becomes a huge size.
Is there a way to stop the logging under the data directory so i don't have the issue of running out of space?
Your help will... (6 Replies)
Discussion started by: moe2266
6 Replies
9. Solaris
I'm trying to build 64 bit mysql-5.0.37 on Solaris 10.
CFLAGS="-O3" CXX='gcc -m64 -mcpu=v9' CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure -disable-shared --prefix=/usr/local/mysql --datadir=/home1/mysql_data --with-mysqld-user=mysql
... (0 Replies)
Discussion started by: csross
0 Replies
10. UNIX for Advanced & Expert Users
I got the source tarbal from mysql.com of the latest version about 3.23.
When I compile it, I get some errors of assembler etc.
I start ./configure with these settings
CC=gcc CFLAGS="-O6" \
CXX=gcc CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti" \
./configure... (1 Reply)
Discussion started by: mrsaint
1 Replies
MYSQL_TZINFO_TO_S(1) MySQL Database System MYSQL_TZINFO_TO_S(1)
NAME
mysql_tzinfo_to_sql - load the time zone tables
SYNOPSIS
mysql_tzinfo_to_sql arguments
DESCRIPTION
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. It is used on systems that have a zoneinfo database (the
set of files describing time zones). Examples of such systems are Linux, FreeBSD, Solaris, and Mac OS X. One likely location for these
files is the /usr/share/zoneinfo directory (/usr/share/lib/zoneinfo on Solaris). If your system does not have a zoneinfo database, you can
use the downloadable package described in Section 10.6, "MySQL Server Time Zone Support".
mysql_tzinfo_to_sql can be invoked several ways:
shell> mysql_tzinfo_to_sql tz_dir
shell> mysql_tzinfo_to_sql tz_file tz_name
shell> mysql_tzinfo_to_sql --leap tz_file
For the first invocation syntax, pass the zoneinfo directory path name to mysql_tzinfo_to_sql and send the output into the mysql program.
For example:
shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
mysql_tzinfo_to_sql reads your system's time zone files and generates SQL statements from them. mysql processes those statements to load
the time zone tables.
The second syntax causes mysql_tzinfo_to_sql to load a single time zone file tz_file that corresponds to a time zone name tz_name:
shell> mysql_tzinfo_to_sql tz_file tz_name | mysql -u root mysql
If your time zone needs to account for leap seconds, invoke mysql_tzinfo_to_sql using the third syntax, which initializes the leap second
information. tz_file is the name of your time zone file:
shell> mysql_tzinfo_to_sql --leap tz_file | mysql -u root mysql
After running mysql_tzinfo_to_sql, it is best to restart the server so that it does not continue to use any previously cached time zone
data.
COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 MYSQL_TZINFO_TO_S(1)
