-Original Message-
From: Will Merrell [mailto:[EMAIL PROTECTED]
Sent: 20 February 2005 14:00
To: Mysql Mailing list
Subject: How to Version Control a database
I have a project that involves several developers working on
their own machines. Each has a local copy of the
It was my own mistake , I'm sorry.
Inside the program I leave a bug wich skip the call to RemoveMyConnection;
Now when I call it the connection closed is removed properly also from the
database connection list.
Just to answer to Philippe:
The thread didn't reopen itself, I explained myself badly,
John,
please print a detailed description of the latest foreign key error with
SHOW INNODB STATUS
and post it here.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
Hello.
I suggest you to use 4.1.10 (in 4.1.8 was fixed a bug #6784,
I haven't seen it in a changelist of 4.0.x branch). If
myisamchk -r *.MYI, myisamchk -o *.MYI doesn't solve the
problem, as the last chance, use USE_FRM mode of REPAIR
command. But you may lose some information about the
Hello.
May be comments at:
http://bugs.mysql.com/bug.php?id=1649
would be helpful for you. Does the altering successful if you
executed a FLUSH TABLES before? See:
http://dev.mysql.com/doc/mysql/en/merge-table-problems.html
Mark Uhrmacher [EMAIL PROTECTED] wrote:
Hi Andy,
Hello.
See:
http://dev.mysql.com/downloads/mysql/4.1.html
sam wun [EMAIL PROTECTED] wrote:
Hi,
I realised that install mysql 4 thru rpm is the best way for a smooth
installation.
Can anyone please point me to a site where I can download mysql 4 rpm
for Redhat9?
Hello.
No, you can't. But you can make some workarounds. For example
you may use triggers in 5.0.2 version (but it is still not
production ready) or use a separate field for storing the
value of the week.
Hany Nagaty [EMAIL PROTECTED] wrote:
Hi all,
I'm a bit new to MySQL, it's
Hello.
There is no direct way to load warnings into log files. But you
may use a small value for max_error_count and launch mysql in a
batch mode saving results in the file.
Marcus Bointon [EMAIL PROTECTED] wrote:
I'm migrating a MySQL 3.23 db to 4.1.10 (on Linux x86) and I'm
Hello.
I think, you don't have a server part of MySQL distribution.
You should install something like mysql-server-xxx.rpm
when i run whereis mysql
Use 'l' query option for the rpm command to see all files from the package:
rpm -ql mysql-3.23.58-1
ayion [EMAIL PROTECTED]
Hello.
queries will likely be spaced out by hours or days (idle disconnect?)
How long does it take to establish a new connection? If the time
is large enough, may be you should make a temporary connection and
close it after timeout. If you deside to use a persistent connection,
don't
Hello.
Full-text search successfully works on my 4.1.9-max instance:
mysql select version();
+---+
| version() |
+---+
| 4.1.9-max-log |
+---+
CREATE TABLE `ft` (
`a` text,
FULLTEXT KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
Hell.
I think you should read comments at:
http://bugs.mysql.com/bug.php?id=1388
They are related to the ODBC connector, but may be it will
help you to solve problems with Connector/J.
LAFONTAINE Julien - LYO [EMAIL PROTECTED] wrote:
Hi everyone,
I've recentely upgarded
Hello.
Sergei Golubchik said that we can't change the value of the blocksize
of a key (it is chosen in mi_create.c) and there is no workaround
with this LOAD INDEX problem.
HMax [EMAIL PROTECTED] wrote:
Hello there.
OK I'll paste the results of commands you asked right after my
Hi,
Server A - Multiple InnoDB databases
Server B - Replication of Server A
Server C - Other InnoDB databases
I need to be able to move Server C's databases onto Server A and
continue to replicate (with new databases) to Server B.
Can I:
1. Take down Server C, use ibbackup to back up the innodb
Hello.
I have downloaded both 5.0.0 and latest 5.0.1 binary snapshot but I
You may use 5.0.2 - a lot of bugs were fixed during a half year development
period between the releases.
Bereczki Gabor [EMAIL PROTECTED] wrote:
I have downloaded both 5.0.0 and latest 5.0.1 binary snapshot
Hello.
You may use 'CREATE TABLE ... SELECT' statement:
create table t3 type=heap select * from t2;
But be careful, as it doesn't create indexes automatically, unless you specify
them manually in your statement. See:
http://dev.mysql.com/doc/mysql/en/create-table.html
You may
On 2/21/2005 4:21 AM Heikki Tuuri wrote:
John,
please print a detailed description of the latest foreign key error with
SHOW INNODB STATUS
and post it here.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for
Hi,
I am having trouble with the following query:
SELECT U.User_ID,
U.User_Firstname,
U.User_Lastname
FROM Users U, Allocations A
WHERE (U.User_ID = A.User_ID OR U.User_ID = 101)
AND A.Project_ID = '12'
AND ( U.User_Type = 'Staff'
OR U.User_Type = 'Manager'
OR U.User_Type = 'Administrator' )
ORDER
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have tried to compile mysql, and got some linking errors. Any chance a
binary for Solaris 8 can be made available?
Thanx.
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP
- Original Message -
From: shaun thornburgh [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, February 21, 2005 7:28 AM
Subject: Help with a query please
Hi,
I am having trouble with the following query:
SELECT U.User_ID,
U.User_Firstname,
U.User_Lastname
FROM Users U,
From: Rhino [EMAIL PROTECTED]
To: shaun thornburgh
[EMAIL PROTECTED],mysql@lists.mysql.com
Subject: Re: Help with a query please
Date: Mon, 21 Feb 2005 08:22:29 -0500
- Original Message -
From: shaun thornburgh [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, February 21, 2005
what about your query returning all the users UNION your query returning
user 101?
SELECT U.User_ID,
U.User_Firstname,
U.User_Lastname
FROM Users U, Allocations A
WHERE (U.User_ID = A.User_ID)
AND A.Project_ID = '12'
AND ( U.User_Type = 'Staff'
OR U.User_Type = 'Manager'
OR U.User_Type =
shaun thornburgh schrieb:
Thanks for your reply, I would like the query to retun one
instance of user 101 rather than 15!
SELECT DISTINCT ...
Regards,
A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I have a small problem that is probably easy to fix but it is to advanced for
me as a newbe. In my sql-query (below) have I the ID specified twice, I
wonder if there is a easy way to solve it so I only need to write my ID once in
the query?
SELECT (SELECT COUNT(*) FROM subs WHERE id=1)
It's not precisely correct.
When time difference is less than 7, the time is calcualted wrong
end_time 2005-01-10 17:53:33
end_time 2005-01-04 16:44:57
Result: days 6
Result: bussiness_days 6
On Sat, 19 Feb 2005 09:50:06 -0500, Mike Rains [EMAIL PROTECTED] wrote:
On Sat, 19 Feb 2005
Hi,
why not try:
SELECT COUNT(s.Id)+COUNT(se.Id)
FROM subs s
INNER JOIN subs_erased se ON s.Id=se.Id
WHERE s.Id=1;
/Johan
Joppe A wrote:
Hello,
I have a small problem that is probably easy to fix but it is to advanced for me as a
newbe. In my sql-query (below) have I the ID specified twice, I
Hi,
why not try:
SELECT COUNT(s.Id)+COUNT(se.Id)
FROM subs s
INNER JOIN subs_erased se ON s.Id=se.Id
WHERE s.Id=1;
/Johan
This won't return the same result if there's no entries
in subs_erased for the ID = 1.
With regards,
Martijn Tonies
Database Workbench - developer tool for
So this means we cannot combine both FULLTEXT and classical indexes if
we want to use a LOAD INDEX INTO CACHE, and that we won't ever be able
to ?
How about being able to specify the indexes we want to load into the
cache. It's supposed to work this way (but it is told in the doc it
doesn't yet).
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
LAFONTAINE Julien - LYO wrote:
Hi everyone,
I've recentely upgarded my servers from MySQL 3.23.49 to MySQL 4.1.9.
Now I have a problem when using the SUM operator on DECIMAL field.
The value returned by the SUM operator when used with
Hi,
I need a bit of help with a mySQL query. I have a list of users in a text
file called 'users':
u655354
u687994
u696974
u728141
..
..
and I need to check the last date each user logged on to the proxy in the
last 3 months.
In my database, there is a table for the users:
mysql desc
SELECT
start_date,
end_date,
DATEDIFF(end_date, start_date) -
(WEEK(end_date) - WEEK(start_date)) * 2
AS business_days
FROM DateDiffs
ORDER BY start_date;
+-+-+---+
| start_date | end_date|
Hi Martijn,
yes of course you're right but
SELECT COUNT(s.Id)+
(SELECT COUNT(se.Id) FROM subs_erased se WHERE s.Id=se.Id)
FROM subs s
WHERE s.Id=1
might work, at least in 4.1.x. I did test it with 4.1.9.
/Johan
Martijn Tonies wrote:
Hi,
why not try:
SELECT COUNT(s.Id)+COUNT(se.Id)
FROM subs
Hi I'm just starting out with PHP and MySQL
My database has a postcode column and I want to be able to run a search
(using a part of full postcode) to return results in order of proximity
within a given range.
If anyone could point to a decent tutorial / resource, or give me any
advice or
J S wrote:
| Hi,
|
| I need a bit of help with a mySQL query. I have a list of users in a
| text file called 'users':
|
| u655354
| u687994
| u696974
| u728141
| ..
| ..
|
| and I need to check the last date each user logged on to the proxy in
| the last 3 months.
|
| In my database, there is a
Hi!
On Feb 21, HMax wrote:
So this means we cannot combine both FULLTEXT and classical indexes if
we want to use a LOAD INDEX INTO CACHE, and that we won't ever be able
to ?
No. FULLTEXT indexes now have small block size (1024) so they should
load ok. Only long varchar indexes will be a
The following statement helped Roger Backlund me with a few days ago, It works
great but now I need to make it more advance and I don#t get any where to find
the right solution..
SELECT COUNT(created) from SUBSCRIBER
where date_format(
date_sub(now(), interval 1 day),
'%Y%m%d%H%i%s') = created;
Thank you for your answer Sergei,
It's all clear now, and I'm glad to know where the problem comes from.
Now if I understand correctly, my only solution is to manage to create
indexes in my tables that ALL have the same block size (1024). This
would mean reducing the size of the indexes on my
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
J S wrote:
|
|
| J S wrote:
| | Hi,
| |
| | I need a bit of help with a mySQL query. I have a list of users in a
| | text file called 'users':
| |
| | u655354
| | u687994
| | u696974
| | u728141
| | ..
| | ..
| |
| | and I need to check the last date
James Black wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have tried to compile mysql, and got some linking errors. Any chance a
binary for Solaris 8 can be made available?
I cannot answer your question, but I am currently building 5.0.2 on
Solaris 8 sparc and the build works. It does
dear sir
good wishes.
in my previous mail i explained mine mysql regarding problem.
here is my mysqlbug file.
i hope i will help you to solve my mysql regarding problem.
help me to run mysql.
thanks.
ayion
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
It appears that the requirement #2 on the MySQL
license page
(http://www.mysql.com/company/legal/licensing/commercial-license.html)
is not consistent with the GPL, which does not impose
restrictions on non-linked programs. However use of
the MySQL client JDBC or ODBC driver would appear to
This works if you don't care about holidays.
If you do the only solution that I have seen that works is to create a
business day table. Ours is shown below. You have to hand construct the
calendar by removing weekends and holidays for the specific entity. This
calendar forces a non business day
AM Thomas wrote:
Hi there,
I'll answer your questions below, but I should tell you that it looks
like even three or four joins seem to make this too slow.
Theoretically, the user could select up to 15 or so GoalNumber values,
12 for Grade, and about 20 possibilities for Subject - clearly it
I had a previously stable 4.1.8-standard MYSQL install on OS X 10.3.x
Server using the binaries supplied by MySQL.
Recently I have had multiple corruption issues with a database on
multiple tables. I keep getting [ERROR] Got error 127 when reading
table when trying to write to an effected
Hello.
doesn't work. Is there really no workaround ? We have for about 1.5Go
MySQL will store used blocks in memory and minimize a disk I/O,
if your key_buffer_size variable has a sutable value and you
have enough RAM. You may use CACHE INDEX to assign a separate
cache for your table
Hi James!
Am Mo, den 21.02.2005 schrieb James Black um 14:20:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have tried to compile mysql, and got some linking errors. Any chance a
binary for Solaris 8 can be made available?
Solaris 8 is a supported platform, and we (try to) generate
Dear List members,
Having relatively recently moved to GNU/Debian Linux from Windows, I'd
like to move my MS Access databases to MySQL. I'm using the latest
unstable MySQL version and am all setup with user, passwords, and
privileges, so can create and modify databases in MySQL. Searching for
Hi!
On Feb 21, HMax wrote:
Thank you for your answer Sergei,
It's all clear now, and I'm glad to know where the problem comes from.
Now if I understand correctly, my only solution is to manage to create
indexes in my tables that ALL have the same block size (1024). This
would mean
When will the 5.0.3 binaries be available?
Thanks,
Fredrick
- Original Message -
From: Joerg Bruehe [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: James Black [EMAIL PROTECTED]
Sent: Monday, February 21, 2005 11:45 AM
Subject: re: can 5.0.2 be built for Solaris 8
Hi James!
Am Mo,
Hi list,
I've just been wondering if the length parameter of a VARCHAR column has
any effect on storage efficiency or space requirements. Afaik, VARCHAR
columns only store the amount of data actually written into them and
require no significantly more memory. So to be especially flexible with
a
Such bounty of comments! Thank you, Michael Stassen.
I see how my logic was faulty, and that a more correct solution would
indeed be faster. Thanks for pointing that out and not making me feel
like too much of an idiot :) I'll try the revised solution. I am
clueful about join making
Hello, I've been using MySQL for a while on my computer to host a
couple of things and since today I've got this error:
2003 - Can't connect to MySQL server on 'localhost' (10061)
I have no clue why MySQL isn't even connecting any more, if you have
any information why, please email me. Thanks.
At 03:31 PM 2/21/2005, Jerome Campbell wrote:
Hello, I've been using MySQL for a while on my computer to host a
couple of things and since today I've got this error:
2003 - Can't connect to MySQL server on 'localhost' (10061)
I have no clue why MySQL isn't even connecting any more, if you have
any
Hi all,
I'm trying to modify and recompile some UDFs for MySQL 4.1. I'm using the
header files from the version 4.1.10 Linux source archive and am getting the
following error:
/home/sskarupo/mysql-4.1.10/include/my_global.h:70: my_config.h: No such file
or directory
my_config.h isn't
In article [EMAIL PROTECTED],
J S [EMAIL PROTECTED] writes:
and I need to check the last date each user logged on to the proxy in
the last 3 months.
In my database, there is a table for the users:
mysql desc user_table;
+---+--+--+-+-++
|
I want to have the query cited at the very bottom return a result sorted
by FullText Relevance. I'm thinking I would modify each SELECT
separately. For example maybe the first SELECT clause something like:
SELECT page.* FROM `page` LEFT JOIN `keywords` USING (`page_id`), MATCH
mySQL Mailing List test
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it possible to use mysqlhotcopy on Windows 2000 Server? If so, how?
-
Kirk Bowman Phone: 972-390-8600
MightyData, LLC http://www.mightydata.com
Date: Mon, 21 Feb 2005 16:14:05 +
To: mysql@lists.mysql.com mysql@lists.mysql.com mysql@lists.mysql.com
From: Peter O'Brien [EMAIL PROTECTED]
Subject: Postcode Proximity Search?
Message-Id: [EMAIL PROTECTED]
Hi I'm just starting out with PHP and MySQL
My database has a postcode column and I
Version: Using 4.1.10 on WinXP pro, currently interacting with it using
the Query Browser for testing.
I have a table set up that contains a column of DECIMAL(15,12) --
financial data, where the precision is highly important. I am building
up a series of SQL statements, and I noticed that
Huh, you know. Now that I'm not at work and therefore don't have my
numbers to check against, you're right.
Man, I must need more coffee.
Never mind me. :)
May be back tomorrow, though, when I have the numbers in front of me. I
know they didn't add up earlier...
Martin
Hassan Schroeder
Can I select from one db and insert into another?
also...Can I join to a remote db?
tia,
.V
--
Forums, Boards, Blogs and News in RiA http://www.boardVU.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Good evening folks, I'm seeing some odd behavior in MySQL 4.0.21
running on Mac OS X 10.3.7
I'm trying to compare two identical tables and find the rows
that are new/modified. I can't use a timestamp column because
the new table is constantly regenerated. So I'm using a large
WHERE clause and
In the last episode (Feb 21), Martin said:
Version: Using 4.1.10 on WinXP pro, currently interacting with it
using the Query Browser for testing.
I have a table set up that contains a column of DECIMAL(15,12) --
financial data, where the precision is highly important. I am
building up a
Yeah, I checked the math after another responder. Either I was smoking
crack at work today (a state likely induced by too much/too little
caffeine) or I mis-noted my numbers.
I'm going to check again when I get back there tomorrow.
But thanks :)
Martin
Dan Nelson wrote:
In the last episode
Chuck Flowers wrote:
mySQL Mailing List test
Luckily there are only very few people who do this, otherwise I'd spend
my whole day deleting people's test messages.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2
Hi,
I am working with 5.0.3 snapshot on x86_64. I am now experiencing with
features of MySQL, so please ignore that in my example I use self join .
I know that this particular example could be done much easier but
eventually I am going to join multiple tables with similar structure
(one
Hi,
I'm writing an application that uses InnoDB tables to provide
transactional integrity. The front-end is a web-based interface.
I'd like to know - is there a way one can issue a query to test whether a
particular set of rows (or row) has already been locked by another session
- rather than
I wrote to the list explaining about the Great Circle formula for
doing the desired calculations. I also stated that places.zip was the
file to be used for these calculations--I misspoke. The correct file
is http://www.census.gov/tiger/tms/gazetteer/zcta5.zip;. Sorry for
the error!
--Brandon
Hi listers,
could you please explain:
mysql select timediff(10:00:00, 12:13:14)
- ;
+--+
| timediff(10:00:00, 12:13:14) |
+--+
| -02:13:14|
+--+
1 row in set (0.00 sec)
mysql
70 matches
Mail list logo