On 2/28/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
On Wed, 2007-02-28 at 15:05 +0530, abhishek jain wrote:
> Hi Friends,
> I have been developing one application over Windows and now i want to
> move/port that into linux, i want to know will the casing of the table
name
> matter on linux ie if i
Is MySQL on each one set to the same time zone?
SELECT@@global.time_zone;
-Ryan
Néstor wrote:
That was interesting. I have 2 rhel 3 servers and they both have been
update to handle the DST. They both yield different results when I
ran the
command:
SERVER=RALPH
+
This is somewhat related to my last question RE conflicting procedure
argument names, but in regards to multi-row inserts...
suppose the following procedure:
DROP PROCEDURE IF EXISTS sp_ImportedUpdate |
CREATE PROCEDURE sp_ImportedUpdate ()
DETERMINISTIC CONTAINS SQL MODIFIES SQL DATA
BEGI
Could someone explain the logic of how case sensivity works on stored
procedure formal argument names?
Example:
CREATE PROCEDURE sp_Test ( IN col1 INT,
IN col2 INT )
BEGIN
INSERT INTO Table
SET COL1 = col1,
COL2 = col2;
END
We've found that this is problem
That was interesting. I have 2 rhel 3 servers and they both have been
update to handle the DST. They both yield different results when I ran the
command:
SERVER=RALPH
+---+---+
| UNIX_TIMESTAMP('2007-03-11 02:00:00') | UNIX_
On Wed, February 28, 2007 14:10, Ryan Stille said:
> I am on 4.1.20-1.
>
> Maybe your OS isn't patched?
>
> Try this: "SELECT @@global.time_zone;"
Won't help if you are on debian which is still on 4.0.
> If you get back "SYSTEM", then MySQL is looking to the OS for timezone
> data. And its only l
I am on 4.1.20-1.
Maybe your OS isn't patched?
Try this: "SELECT @@global.time_zone;"
If you get back "SYSTEM", then MySQL is looking to the OS for timezone
data. And its only loaded when MySQL starts, so if you haven't
restarted MySQL since you patched your OS, you need to do that.
-Ryan
What version of MySQL are you using? I'm running 4.1.21, and that check
doesn't work even after I've updated (I think) the time zone tables.
I should probably eyeball the output of mysql_tzinfo_to_sql.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 060
As I understood to attain MySQL Developer you must pass 2 exams...
DEV1 and DEV2...
What I did not understood, yet... if there is any limit in the
timespan between DEV1 and DEV2.
Let's say I'll take DEV1 in late March... how many months can pass so
that when i'll take DEV2 the results for DEV1 a
[EMAIL PROTECTED] [~]# zdump -v /etc/localtime |grep 2007
/etc/localtime Sun Mar 11 06:59:59 2007 UTC = Sun Mar 11 01:59:59 2007 EST
isdst=0 gmtoff=-18000
/etc/localtime Sun Mar 11 07:00:00 2007 UTC = Sun Mar 11 03:00:00 2007 EDT
isdst=1 gmtoff=-14400
/etc/localtime Sun Nov 4 05:59:59 2007 UTC
You ran your zdump -v against this file ?
> -Original Message-
> From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 28, 2007 1:41 PM
> To: Jean-Sebastien Pilon; mysql@lists.mysql.com
> Subject: RE: Does MySQL require patch for Daylight Savings
> Time 2007 change
Hi all
Which of these two tables wiil yield the best performance in a table
with about 6 million entries (for rapid selects on either field):
table_using_char
field1 char(50),
field2 char(50),
filed 3 char(50),
separate unique indexes on all 3 fields
table_using_varchar
field1 varchar(50),
f
As for me, /etc/localtime -> /usr/share/zoneinfo/EST5DST
Which should be correct for my system as I am located in that time zone. I
don't understand why MySQL doesn't give the same UNIX_TIMESTAMP for
"2007-03-11 02:00:00" and "2007-03-11 03:00:00". Just to make sure, I tried
it with one minute ear
Dear Friends:
since 2 weeks ago the mysql is stoping sudenly, and into the error log
is as lines below, "Database page corruption on disk or a failed" ,
"file read of page 34",
how I can know what table is in page 34 ?
I've used mysqlcheck, without any result, all is OK for it,
mysql 4.01 is
This is a follow-up to the earlier stored proc question.
I have a stored proc, with user level permissions for execute. If I
drop the stored proc and then create it again, the user level execute
permissions go away. What is the proper way to edit/alter a store proc
without losing these permissio
You have both compare 0100 vs 0200 and 0200 vs 0300 in my reply... It wasn't
clear because of emails being wrapped at 80 chars.
And it still doesn't work after loading the tables with mysql_tzinfo_to_sql
And /etc/localtime is a symlink to the proper tz file ?
Jean-Sébastien Pilon
Systems Admini
> Better add "SQL SECURITY DEFINER" to it.
I noticed that it works with and without this. I have added it to the
procedure.
Another quick question though. Since I have added the end user that
will execute the procedure it works fine, until I drop the procedure and
recreate it then I have to rea
On 2007-02-28 Gary W. Smith wrote:
...
> If I'm understanding the docs correct (which I'm probably not), I should
> create the procedure with [EMAIL PROTECTED]
>
> CREATE [EMAIL PROTECTED] PROCEDURE
Better add "SQL SECURITY DEFINER" to it.
..
> The next question is what permissions do I need t
> The next question is what permissions do I need to give
> [EMAIL PROTECTED] to just access that one permission?
The sound of that thump thump thump is my head hitting the wall.
There is like a single small line in the GRANT section of the how to
that mentioned "TABLE|PROCEDURE|FUNCTIO" but none
Hang on a second! Doesn't EST transition to DST at 03:00? Shouldn't that
query (the one for testing MySQL's time zones) be
SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'),UNIX_TIMESTAMP('2007-03-11
03:00:00');
? Nonetheless, it doesn't work for me. I get a one-hour difference, just as
though the DS
Hy!
How can I modify mysql's 3 service name via my.ini?
If I try to install a new mysql, verion 3, on a computer that already has a
mysql 4 or mysql 5(registered to start as a service with the name Mysql (not
mysql4 or mysql5) WinMySQLAdmin 1.3 get confused and doesn't start mysql 3
because "Th
> Do you know about the "SQL SECURITY { DEFINER | INVOKER }" options to
> CREATE PROCEDURE? With them it should be possible to
> * deny selects to users on the tables
> * allow selects to users to this procedure
> * having the procedure itself working with the rights of root/definer
I did not, but
I don't believe so, since the version of MySQL you are using relies on
the system's time. I am using 4.1 and I am setup to use system's time
and my timezone tables in the mysql schema are empty. I would take a
look at those on your installation. You can also run the 2nd command
below to see if the
What I want is to get next result:
Col.B | Col.A | Desription not in result query
A | -8 | -10-(-2)
B | -2 | -3-(-1)
You need an ordering key; otherwise order is indeterminate. Still,
comparisons based on row sequence are often easier to code in the
application. A SQL hack is possible, but it
Okay but after I patch OS do I still need to load time zone tables with
following command:
shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
Is this still necessary?
___
Dzenan Causevic
Web Applications Developer
NaviSite, Inc.
315-453-2912 x5346
Version < 4.1.3 -> relies on the O/S for DST
Quote from http://dev.mysql.com/doc/refman/4.1/en/time-zone-support.html
"For versions of MySQL older than 4.1.3 that do not have time zone
support, the server always tracks the operating system time (much like a
time zone setting of SYSTEM in 4.1.3 a
As far as I know, MySQL does not need a TZ patch (unless you
use specific/custom Time Zone information), but your OS does.
The best way to check is to run:
mysql> SHOW VARIABLES LIKE 'TIME_ZONE';
If it says SYSTEM, then you need only patch your OS. (Patching the OS is [OT]
Grant Griffith wrote:
I am trying to add an autoincrement field to a table that already exists
and I keep receiving errors when trying to do it. Can someone point me
in the right direction on how I can do this? I have access via Webadmin
and phpMyAdmin, so I can try it however I need to.
ALTE
I am running Apache HTTP 1.3 with PHP 4.2.2 and MySQL 3.23.
Do I need to apply any kind of patches to my MySQL related to Daylight
Savings Time 2007 change?
___
Dzenan Causevic
Web Applications Developer
NaviSite, Inc.
315-453-2912 x5346 (Office)
315-27
> > Hi,
> >
> > I have allocated 500MB to key_buffer_size, but only 324MB is in use
> > (64%).
> >
> > Am I right to assume that this can mean one of the
> following: (1) all
> > indexes have already been cached and together they are just 324 MB,
> Do "find /var/lib/mysql -name "*.MYI" -ls" (if
Hi list,
As part of a server virtualization project, we are going to migrate
MySQL from SPARC/Solaris 8 to AMD/x86 Solaris 10.
I seem to remember that it is possible to:
- stop the SPARC server
- move the mount point of the MySQL data directory to the Solaris/x86
server
- start the AMD x86 serve
Does anyone have any resources, guides, insight into the best practice
for storing date/time information when developing a custom web app?
I am mainly concerned with how the TZ should be stored? Should it go
in as UTC and the code accounts for the user TZ? How does one handle
tracking the users
Payne <[EMAIL PROTECTED]> writes:
> Hi,
>
> I am currently using SuSE and like to be able use myisamcheck when start
> up mysql. Is there a command that I can added to my init.d script that
> would do that.
MySQL Debian package[0] does this. The init.d script is just a bash
script, so you may add
On 2007-02-28 Gary W. Smith wrote:
> Basically, here is the stored proc. It works, but only for root. Is it
> possible to allow user to execute this without having SELECT access to
> the table users? If so, how?
Do you know about the "SQL SECURITY { DEFINER | INVOKER }" options to
CREATE PRO
On Wed, Feb 28, 2007 at 09:39:40AM +0100, Matthias Henze wrote:
> hi,
> 1. is ist possible to switch mysql 5.0 completely to UTF-8 ?
Yes.
>
> 2. an option would be to convert my data from latin1 to UTF-8
>how can i do this ?
Export your 4.x databse with mysqldump and convert it with iconv.
On Wed, Feb 28, 2007 at 03:05:54PM +0530, abhishek jain wrote:
> Hi Friends,
> I have been developing one application over Windows and now i want to
> move/port that into linux, i want to know will the casing of the table name
> matter on linux ie if i have table name as tab1 and i execute query li
Hi,
> I have been developing one application over Windows and now i want to
> move/port that into linux, i want to know will the casing of the table
name
> matter on linux ie if i have table name as tab1 and i execute query like
> select * from TAb1 ,will it make an effect.
> I have found that thi
I have a set of tables that contain sensitive user information. I need
to use this data for validation BUT I don't want the end user to have
access to read this data. In MSSQL I used to be able to create a stored
proc to do the work (even though the user didn't have access to the
table). I was w
On Wed, 2007-02-28 at 15:05 +0530, abhishek jain wrote:
> Hi Friends,
> I have been developing one application over Windows and now i want to
> move/port that into linux, i want to know will the casing of the table name
> matter on linux ie if i have table name as tab1 and i execute query like
> se
Hi Friends,
I have been developing one application over Windows and now i want to
move/port that into linux, i want to know will the casing of the table name
matter on linux ie if i have table name as tab1 and i execute query like
select * from TAb1 ,will it make an effect.
I have found that this
-Original Message-
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tue, 27 Feb 2007 7:34 PM
Subject: Re: Installation Gone Haywire
>have you run mysql_install_db on your production server?
Let me add more to my response. After running your command, I have these three
problems (f
hi,
by now i've used mysql 4.0 now i have to switch to 5.0. my problem is that the
old databases are in latin1 and all my php code does not care about character
sets as it just used to work ...
i was able to load the datat to mysql 5.0 with latin1 encoding. aleast mysql
shows latin1 as charact
-Original Message-
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tue, 27 Feb 2007 7:34 PM
Subject: Re: Installation Gone Haywire
>have you run mysql_install_db on your production server?
I ran that, but I still got the same problem:
# Starting mysqld daemon with databases from /
43 matches
Mail list logo
