Thanks Heikki, I understand the bug, and I know you fixed it, for which I am
very pleased, as always problems when identified are fixed quickly :-)
I guess the question I was trying to ask of MySQL is when will 4.1.9 be
built... It's very frustrating knowing that a problem has been fixed
(particul
Hi
Any help is greatly appreciated.
When I upload some data into my mysql database, the file ibdata1 is growing.
Usually I export contents of files into database. That's our requirement.
When I remove the same data from tables, there is no change in ibdata size.
I.e. it is not getting redu
I believe this is what you are looking for:
ALTER TABLE Images MODIFY Imcreatedat datetime NOT NULL default '-00-00
00:00:00' AFTER Imccdtemp;
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Gaspar Bakos [mailto:[EMAIL PROTECTED]
Sent: Wed
Hi,
Is there a solution for "moving" a column in a table from a position to
another?
I tried various "alter table" configurations.
The only solution i found was (trying to "move" IMcreatedat):
# Add temporary column:
Alter table Images add column
temp datetime NOT NULL default '-00-00 0
Eric,
I'm glad that last answer worked, but I'm wondering what exactly you did
to resolve the problem? I see the bug report and work around. But what
specifically did you do, what did you type to fix it? By the way, what
operating system are you using for your servers?
--
MySQL General Mail
That looks like a direct hit. Thanks!
--
Eric Robinson
-Original Message-
From: Mikael Fridh [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 29, 2004 1:06 PM
To: Robinson, Eric
Cc: mysql@lists.mysql.com
Subject: Re: SHOW TABLE STATUS: Update_Time Is Wrong?
Robinson, Eric wrote:
>>>
If you follow the instructions properly, you can get the ISAPI version
of PHP to run and it it runs pretty well once installed.
Curtis
Don Stefani wrote:
GH wrote:
I am using IIS :(
On Windows... Which do i install first? PHP or MySQL?
Apache. :)
If your just working on a local dev bo
Use the ODBC connector and write it in VB.
Curtis
Chris Mason wrote:
I have a mysql database runing on an internal linux server and I need to
connect to it with an appliication running on a windows workstation. The
application must start another application with command line informaiton
from the da
Hi,
The following query returns the amount of hours a user has been booked for
on a particular day.
SELECT (SUM(((DATE_FORMAT(B.Booking_End_Date, "%k") * 60 ) +
DATE_FORMAT(B.Booking_End_Date, "%i")) -
((DATE_FORMAT(B.Booking_Start_Date, "%k") * 60 ) +
DATE_FORMAT(B.Booking_Start_Date, "%i")))
This is a bug.
I have all the slave configuration in /etc/my.cnf commented out.
However the machine was ONCE a slave and so data/master.info exists.
I commented out all the /etc/my.cnf settings WRT master-* yet when I
restart the box it STILL insists on starting the slave via master.info
If th
We have a failed master right now...
If I attempt to shutdown any of my slaves right now they ALL timeout
when trying to shutdown. To make matters MUCH worse I can no longer
connect to the STILL running mysql daemon.
So the only way to restart is with a killall -9 which results in a
corrupt da
Zitat von Jay Blanchard <[EMAIL PROTECTED]>:
> [snip]
> Although my question goes in that direction, it is more about why this
> statement
> does not act atomically from my applications point of view.
>
> > update table2, table1
> > SET table2.value=table2.value-IF(table1.condition=7,1,0),
> > tab
ORDER BY host DESC LIMIT 1
On Wed, 29 Dec 2004 14:18:02 -0800 (PST), Richard Reina
<[EMAIL PROTECTED]> wrote:
> I know to most of you this will seem like a mundane
> question, but I was hoping someone can tell me how to
> select the last record in a table that meets certain
> criteria. Like to se
It's working now!
Thank you Shawn and Alex.
Have a Happy New Year!
Pedro Almeida.
-Mensagem original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviada: quarta-feira, 29 de Dezembro de 2004 21:23
Para: mail.pmpa
Cc: mysql@lists.mysql.com
Assunto: RE: SQL UNION ALL
"mail.pmpa" <[EM
[snip]
I know to most of you this will seem like a mundane
question, but I was hoping someone can tell me how to
select the last record in a table that meets certain
criteria. Like to see who hosted the last party in
CHicago.
SELECT host FROM PARTY
WHERE city="chicago";
PARTY
ID |host | city
I know to most of you this will seem like a mundane
question, but I was hoping someone can tell me how to
select the last record in a table that meets certain
criteria. Like to see who hosted the last party in
CHicago.
SELECT host FROM PARTY
WHERE city="chicago";
PARTY
ID |host | city | st |
"mail.pmpa" <[EMAIL PROTECTED]> wrote on 12/29/2004 03:52:10 PM:
> Thanks for replying.
>
> I tried that query but I get the following error:
>
> Query failed : You have an error in your SQL syntax...
> ... right syntax to use near 'EXISTS ( SELECT * FROM new_products t03
WHERE
> t03
>
> I thi
Bruce,
it is the bug "innodb_file_per_table corrupts secondary indexes".
I fixed it with several changesets on Sunday:
http://lists.mysql.com/internals
Thus, it is fixed in the current 4.1 bk tree.
This is indeed the worst InnoDB corruption bug since the BLOB update bug of
summer 2001. Fortunately
You are correct. The AV scan should not happen unless the database is
shutdown or some kind of file locking contention could occur.
It should be possible in your OS to deny your AV access to the folders
that contain your database files. This may mean changing the user account
your AV runs unde
On Wed, 29 Dec 2004 12:09:51 -0500
[EMAIL PROTECTED] wrote:
> Of course, the WAMP alternative is always there, Apache is FREE and
> comes with PHP.
FWIW, the download of apache from the Apache website
(http://httpd.apache.org/) does NOT include PhP, you still have to
download and install ph
Hi Shawn,
Sorry for the confusions! The booking in question is where B.Booking_ID = x
as in the original query:
SELECT U.User_ID, U.User_Firstname, U.User_Lastname
FROM Allocations A, Users U
LEFT JOIN Bookings B
ON B.User_ID = U.User_ID
AND B.Booking_ID = 4512
WHERE U.User_ID = A.User_ID
AND A.Pro
Robinson, Eric wrote:
When I execute SHOW TABLE STATUS on my master replication server, it
shows an Update_Time for some tables that is more than 2 hours earlier
than the Update_Time for the same tables on the slave server. However
the bin log names, positions, and number or records are correct.
Wh
"shaun thornburgh" <[EMAIL PROTECTED]> wrote on 12/29/2004
03:00:08 PM:
> Hi Shawn,
>
> Thanks for your reply, but your query seems to return everyone allocated
to
> that project plus everyone who has ever been booked on that project.
What I
> need is everyone who is currently allocated to t
Thanks for replying.
I tried that query but I get the following error:
Query failed : You have an error in your SQL syntax...
... right syntax to use near 'EXISTS ( SELECT * FROM new_products t03 WHERE
t03
I think I will have to forget the join, split and do a compare directly in
php.
Also, I w
The rules for copying users or grant tables are the same as any other
MyISAM table and can be found in the manual. Only when the copy is
done you have to restart mysqld or issue a flush privileges; query.
On Wed, 29 Dec 2004 15:01:19 -0500, GH <[EMAIL PROTECTED]> wrote:
> I would like to know if
[snip]
I am using version 3.23.54, unfortunately I am unable to supply test
data
but basically I need to update the Task_ID column for the Bookings table
so
that it is the same as the Task_ID for Tasks and the Task_Name is
'Booking'
and the Bookings Project_ID is the same as the Tasks Project_ID
On Wed, 29 Dec 2004 19:57:04 -
"mail.pmpa" <[EMAIL PROTECTED]> wrote:
> What I am trying to do is:
> Select products and join brand, but only products that are not new
products.
> What I have is:
>
> ( SELECT products.id, products.model
> FROM products, brands
> WHERE products.brand = brands
Sorry Jay,
I am using version 3.23.54, unfortunately I am unable to supply test data
but basically I need to update the Task_ID column for the Bookings table so
that it is the same as the Task_ID for Tasks and the Task_Name is 'Booking'
and the Bookings Project_ID is the same as the Tasks Projec
How does everyone handle antivirus's and file locking issues?
I've been fighting with our sysadmin for weeks, I insist that norton
should not touch our database files, innodb, myd, myi
now it does, and I see corrupt data, and norton will skip files because
it cant get a lock, I dont want to thin
I would like to know if it is possible and how to copy my users
(passwords & priviledges etc...) from my Mandrake 10.0 / MySql 4.0
machine to my Win XP Pro/MySql 4.1 machine?
I would like to keep being able to develop the project that I am
working on while I will be away from my main computer?
-
Hi Shawn,
Thanks for your reply, but your query seems to return everyone allocated to
that project plus everyone who has ever been booked on that project. What I
need is everyone who is currently allocated to that project and the staff
member who has been booked for the booking in question wheth
Hi all.
I have 3 tables as following:
PRODUCTS
id | brand | model
1 | 1 | duron
2 | 1 | athlon64
3 | 2 | pIV
BRANDS
id | brand
1 | amd
2 | intel
NEW_PRODUCTS
id | product_id
1 | 2
What I am trying to do is:
Select products and join brand, but only products that are not new pr
[snip]
I am having trouble with an UPDATE query. I have three tables as defined
below. My database holds data for bookings. Each booking relates to a
project. Each project has many tasks, one of which is a booking. I have
now
added the column Task_ID to the bookings table. How can I update all t
Hi,
I am having trouble with an UPDATE query. I have three tables as defined
below. My database holds data for bookings. Each booking relates to a
project. Each project has many tasks, one of which is a booking. I have now
added the column Task_ID to the bookings table. How can I update all the
Hello everybody,
I used to have mysql-4.1.5 (gamma version) on Linux RH7.2.
I compiled it from source with gcc 2.96-98:
shell> ./configure --with-charset=latin2
next I compiled and installed DBI-1.43 and DBD-mysql-2.9004,
I have perl 5.8.5
in my perl cgi script I have:
print "Content-type: text/h
I believe that 4.1.0 and 4.1.1 were doing things a bit differently than
4.1.2+ , so your problem is likely caused by that.
4.1.0 wasn't a production release, I'd suggest upgrading the client.
Of course, there might be something I'm missing...
Chris
Somashekara DM wrote:
Hi all,
I'm using MySQL 4.
The time zones are correct. Besides, the difference is not an even hour,
and it varies. Sometimes the master server shows an update_time that is
only a few minutes different, other times it is 510 seconds or 633
seconds or 6056 seconds different. Eventually it catches up, but it
sometimes takes an
I just set up mysql and found it running as root. I want to change it to run
as mysql. I know I need an entry under [mysqld] in my.cnf. I also know the db
directories and files need peermission changes but I'm confused on that. I
use SuSE 9.1 and the datadir is:
/var/lib/mysql> ls -l
total 13
d
>Description:
config, build, and install went fine
died on sql-bench/run-all-tests
>How-To-Repeat:
./run-all-tests --server=mysql --cmp=mysql,pg,solid --user=root
--password=myrootpwd --log
--socket=/engtools/local_advtech_develop/mysql-4.1.7/var/mysql.sock
Got error: 'Client doe
Hi!
Am Mit, 2004-12-29 um 18.09 schrieb [EMAIL PROTECTED]:
> [[...]]
> Of course, the WAMP alternative is always there, Apache is FREE and comes
> with PHP. I have both IIS and Apache set up on my Win2K laptop (I usually
> only run them one at a time to conserve resources), So instead of IIS/AS
Hi,
I am trying to making a copy of a table called "Sections" into a new
table (just to be created) called "CamCfgSec". This "CamCfgSec" has
different column names (but represent the same data, and in the same
column order).
I tried to achieve this with the
create table ... select
syntax,
I thought you were building a local application, not a web-based app??
I believe you can still use PHP through WSH (instead of IIS) but you will
need to do some research, though. I know that Perl is supported by both
WSH and IIS (I have seen it working before) so I think that PHP and Python
and
GH wrote:
I am using IIS :(
On Windows... Which do i install first? PHP or MySQL?
Apache. :)
If your just working on a local dev box, it may not be that big of a deal.
PHP using IIS is a bit easier to install than Apache since PHP5 does not
have an installer that auto-configs Apache,
> This bug was fixed and closed several weeks ago. I guess because it only
> affected win32 it isn't considered a real bug because it was never listed
in
> the documentation that it was fixed.
>
> Yes you are right Win32 5.0.2 is completely unuseable. If it was a *nix
> build we would have had a
This bug was fixed and closed several weeks ago. I guess because it only
affected win32 it isn't considered a real bug because it was never listed in
the documentation that it was fixed.
Yes you are right Win32 5.0.2 is completely unuseable. If it was a *nix
build we would have had a 5.0.2x a lon
I am using IIS :(
On Wed, 29 Dec 2004 10:03:11 -0600, Josh Trutwin
<[EMAIL PROTECTED]> wrote:
> On Wed, 29 Dec 2004 10:42:45 -0500
> GH <[EMAIL PROTECTED]> wrote:
>
> > On Windows... Which do i install first? PHP or MySQL?
>
> Apache. :)
>
> It doesn't really matter but I'd suggest MySQL fir
On Wed, 29 Dec 2004 10:42:45 -0500
GH <[EMAIL PROTECTED]> wrote:
> On Windows... Which do i install first? PHP or MySQL?
Apache. :)
It doesn't really matter but I'd suggest MySQL first as I think there
is one file you need to copy from the MySQL installation to the
C:\Windows (or whatever syste
Hi all,
I'm using MySQL 4.1.7 Production binary version and try to connect it
from mysql 4.1.0 client.
I get "ERROR 1043: Bad handshake" error on the console.
I don't have problem in connecting using same version of mysql client
(MySQL 4.1.7)
Is there a way to fix it, please help me on it.
Than
[snip]
On Windows... Which do i install first? PHP or MySQL?
[/snip]
It should not matter as you will have to tell PHP to load the proper
libraries. Install both (in any order) then configure PHP, then start
MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
On Windows... Which do i install first? PHP or MySQL?
Thanks
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it just me or is the current Alpha build of MySQL 5.0
HIGHLY instable?
5.0.2 on Windows is completely unusable for me too; crashes constantly
the Linux version seems to be fine, at least in my tests
Michael Kofler
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Hi all,
We are using MySQL 4.0.21 with MyODBC connectivity. We are getting a
crash when attempting to perform batch fetch
using SQLFetchScroll() funciton. Since the function is a generic one for
which we have defined a global variable
(a two dimentional void* array to hold the field values fo
When scripting for Windows you have two immediate choices: VBScript and
JScript. Both are natively supported by the WSH (Windows Scripting Host)
executable which comes in two flavors: command line (cscript.exe) and
windowed (wscript.exe). If you want to use Perl or some other scripting
language
[snip]
Is it just me or is the current Alpha build of MySQL 5.0 HIGHLY
instable?
A simple "show columns from " crashes the server...
It's running on WinXP, if that matters.
[/snip]
H, an unstable Alpha build? Nope...Windoze is the unstable partner
here. ;)
I have 5 running on a BSD server
Well, obviously I would try creating compound indexes. So one index
would be created, author and the other would be author, created. But it
seems like you tried that.
You say you adjusted the max_seeks_for_key, but have you adjusted the
sort_buffer? Sorting does seem to be your bottleneck and t
Hello,
Is it just me or is the current Alpha build of MySQL 5.0 HIGHLY
instable?
A simple "show columns from " crashes the server...
It's running on WinXP, if that matters.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene
[snip]
Although my question goes in that direction, it is more about why this
statement
does not act atomically from my applications point of view.
> update table2, table1
> SET table2.value=table2.value-IF(table1.condition=7,1,0),
> table1.condition=8
> WHERE table1.ID = table2.ID_table1
[/snip]
[snip]
I would be deliriously happy if someone could explain WHY these
statement _should_ have different results. If I am wrong and these
UPDATE statements are supposed to provide different results, I would
like to learn how I became so confused over something this fundamental.
Until I get credible
I have a mysql database runing on an internal linux server and I need to
connect to it with an appliication running on a windows workstation. The
application must start another application with command line informaiton
from the database so I can’t use a web based application, as web browsers
cannot
See what happens if you try it with the --quick option. This will
prevent mysqldump from writing to memory before writing to the dump file.
Hi,
yes, it seems to work so far.
Thanks for your quick reply.
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives: ht
Hello.
At first you should look through all changes from 4.1.1 to 4.1.8 listed
in manual. There are extra steps which required during upgrade in some cases.
>I haven't found anything in the documentation that will help me upgrade
>mysql from 4.1.1 to 4.1.8. We have several databases runn
Hello.
In most cases the latest release (now 4.1.8) is the best choice. If you
need stored procedures and other new features - use 5.0.2. However,
please be aware that this is not a 'standard MySQL release' in the
sense as there are still some open critical bugs in our bugs database
that
Hello.
>I was timming my scripts, and the biggest time the scripts took are =
> in the DBI->connect process
I think that the root of the problem may be
in slow name resolving. You can disable DNS hostname lookups. See:
http://dev.mysql.com/doc/mysql/en/DNS.html
Jos? Miguel Fe
Hello,
> RE:
> > And columns in primary keys must be NOT NULL. Columns in unique
> > keys can be NULL (if they are NOT NULL, then the unique key is
> > functionally the same as a primary key).
>
> OK, thanks guys for the explanation.
>
> Then the result of mysqldump table definition part:
>
> UNI
> >> I have two tables, seemigly very similar setup; the primary key is the
> >> combination of two columns. With mysqldump, however, the table
> >> definition of the two tables looks different.
> >>
> >> Mysqldump on table 1 says
> >> ...
> >> UNIQUE KEY HONstid (HONstid,HONname)
>
From: "pravin" <[EMAIL PROTECTED]>
> SRNO EMP_ID DATETIME QUES1 QUES2 QUES3 QUES4 QUES5 QUES6 QUES7 QUES8
> I now want to show a report from this table.This report will be group by
> So the main problem is for calculating average of QUES3 for EMP_ID=10.
> This average is calculating without conside
Hello Friends,
I am having a general query problem. I am having a table with data as below.
SRNO EMP_ID DATETIME QUES1 QUES2 QUES3 QUES4 QUES5 QUES6 QUES7 QUES8
1 10 1 2 4 4 NA 2 2
NA 5
2 12 1 NA 4
Estaré ausente de la oficina desde el 27/12/2004 y no volveré hasta el
03/01/2005.
Responderé a su mensajes a mi retorno.
Exito para el Nuevo Año.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
68 matches
Mail list logo