Further to the email below,I performed the upgrade last night and we are
now running mysql 4.0.16.
the last on the syncronization hasnt reduced any, so if anyone knows how
else I can keep these two databases in sync, I would be very interested
in knowing how!
now that we are running the 4.0
Matt,
One last question and then I promise to drop the topic ... what would be
the best way to force a complete load of an index into the key buffer ?
Thanks very much for your time.
John
Matt W [EMAIL PROTECTED]
2004-01-15 02:06
To: [EMAIL PROTECTED]
[EMAIL PROTECTED]
Then the next problem is with WinMySqlAdmin. How in the heck do I change
it
to login in as root and show all the databases etc. Right now it is
showing
only the test DB and user as Administrator. Everything appears in grey
and
can't be changed?
Add the following lines to your my.ini
Well pals,
Today I am not writing this message to bother you with
my problems but to pass my warmest thanx to you guys
all. Duncan, Peter , Mike, Cory ... I appreciate your
time and energy in solving the problems I faced on the
above subject.
Special thanx to Duncan for his precise and priceless
This is a fuzzy issue.
There are questions regarding redistribution. Any distribution requires
that you either comply with the terms of the GPL or that you get a
licence.
Additionally, MySQL AB have recently changed the licence terms of their
libraries - now absolutely everything that the fine
Andrew DeFaria [EMAIL PROTECTED] wrote:
Victoria Reznichenko wrote:
Andrew DeFaria [EMAIL PROTECTED] wrote:
As you can see I when I delete from user (the parent table) the
useropts (child table) entry remains. Shouldn't it be deleted?
Heikki Tuuri asked me to look at my innodb variables
Director General: NEFACOMP [EMAIL PROTECTED] wrote:
I am using 4.1.0 and 4.1.1 on Windows
On WinXP, it even crashes the server when I add extra date fields.
On Win2k AS, it doesn't crash the MySQL server but it returns unexpected
results.
Thanks for report! It's a known bug:
ASP and VB
I have created a search web page searching a MySQL table with the
following code:
CREATE TABLE tbl_allarticles (
fld_ID mediumint(8) unsigned NOT NULL auto_increment,
fld_category tinyint(2) unsigned NOT NULL default '0',
fld_updateddate timestamp(8) NOT NULL,
fld_createddate
Ron McKeever [EMAIL PROTECTED] wrote:
I'm trying to use mysqimport instead of LOAD DATA INFILE from a shell
script. I notice an option for mysqlimport is not working or im doing it
wrong.
This works with LOAD DATA INFILE :
mysql -e LOAD DATA INFILE 'x' INTO TABLE x IGNORE 2 LINES
but
Matthew P Ryder [EMAIL PROTECTED] wrote:
Quick question since I can't see to find version information online.
What version was enum first supported under?
It's supported from 3.21.0:
http://www.mysql.com/doc/en/News-3.21.0.html
--
For technical support contracts, goto
Hi,
As my database has grown I have found that the dump isn't completely restoring to my
development machine (XP Pro).
The file is now up to about 30 MB but it only imports about half the tables. The
command I'm using to restore the db is:
d:\mysql\bin\mysql.exe -h localhost -u username
Hi group,
I had created a table without a primary key (for some reasons). This give
some strange errors.
When I edit a field trough ODBC he said: no transactions supported. If I
edit trough direct access components (DAC for MySQL = native access)
nothing is editted at all.
With the mysql
Hi Hans,
I had created a table without a primary key (for some reasons). This give
some strange errors.
When I edit a field trough ODBC he said: no transactions supported. If I
edit trough direct access components (DAC for MySQL = native access)
nothing is editted at all.
With the mysql
Hi,
Since some days I don't get any mail from this list anymore.
After some investigation, I found that it's blacklisted and our mailserver
refuses any mail from it.
DNSBL/WARNING: bl.spamcop.net/213.136.52.31: IP is listed
Can this be fixed ?
Stefaan
--
MySQL General Mailing List
For
it cannot b related with primary key. i do not hav any idea how u update it,
but it's supported to update any dat in any table with or without PK
- Original Message -
From: Hans van Dalen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 6:20 PM
Subject: table
* Matthew Stuart
[...]
SELECT *
FROM tbl_allarticles
WHERE fld_headline OR fld_summary OR fld_body LIKE '%userinput%' AND
fld_show = 1
This statement does not do what you probably intended it to... the above is
similar to this:
WHERE
fld_headline+0 != 0 OR
fld_summary+0 != 0 OR
Hello Martijn,
And the ODBC driver?? He cannot construct an UPDATE either?
Updating the table is done in code only.. its temporary data wich is
collected in this tables before serieus update..\
hans
At 14:40 15-1-2004, you wrote:
Hi Hans,
I had created a table without a primary key (for
On 15 Jan 2004 at 12:33, Matthew Stuart wrote:
ASP and VB
I have created a search web page searching a MySQL table with the
following code:
CREATE TABLE tbl_allarticles (
fld_ID mediumint(8) unsigned NOT NULL auto_increment,
fld_category tinyint(2) unsigned NOT NULL default '0',
Stefaan Van Dooren wrote:
Since some days I don't get any mail from this list anymore.
After some investigation, I found that it's blacklisted and our mailserver
refuses any mail from it.
DNSBL/WARNING: bl.spamcop.net/213.136.52.31: IP is listed
Can this be fixed ?
Yes. Ask your mail admin.
Hi Hans,
And the ODBC driver?? He cannot construct an UPDATE either?
I'm not saying this is the problem, but it might give you a
direction where to look.
Updating the table is done in code only.. its temporary data wich is
collected in this tables before serieus update..\
Instead of trying
I use it as a temporary file. Putting data in it sequential and after that
reading it out sequential. I don't want a auto increment field or
whatsoever because I want the date in sequential order of the data... the
data itself cannot (always) be used as a primary key
At 14:46 15-1-2004, you
Hi Martijn,
Yes your right, thanks a lot for ANY help! Monitoring component is a good
Idea
Hans
At 15:09 15-1-2004, you wrote:
Hi Hans,
And the ODBC driver?? He cannot construct an UPDATE either?
I'm not saying this is the problem, but it might give you a
direction where to look.
After posting a message you get some more messages of mailservers around
the world which are not accepting your message (send to the list). So there
a lot of people who aren't receiving this mail because there server is
checking spamcop. I don't know you can contact spamcop to ask to delete the
Hans,
I use it as a temporary file. Putting data in it sequential and after that
reading it out sequential. I don't want a auto increment field or
whatsoever because I want the date in sequential order of the data... the
data itself cannot (always) be used as a primary key
If you don't have
Jonathan Tullett wrote:
Further to the email below,I performed the upgrade last night and we are
now running mysql 4.0.16.
the last on the syncronization hasnt reduced any, so if anyone knows how
else I can keep these two databases in sync, I would be very interested
in knowing how!
Hello list,
I have a MySQL 3.23.49 under Debian Linux with this table:
--
CREATE TABLE `fajl` (
`fajl_id` INTEGER(11) NOT NULL AUTO_INCREMENT,
`fajl` LONGBLOB,
`letoltesek_szama` INTEGER(11) NOT NULL DEFAULT '0',
`filename` VARCHAR(80) DEFAULT NULL,
`fajl_tipus` VARCHAR(20)
Kiszely kos wrote:
Hello list,
I have a MySQL 3.23.49 under Debian Linux with this table:
--
CREATE TABLE `fajl` (
`fajl_id` INTEGER(11) NOT NULL AUTO_INCREMENT,
`fajl` LONGBLOB,
`letoltesek_szama` INTEGER(11) NOT NULL DEFAULT '0',
`filename` VARCHAR(80) DEFAULT NULL,
We are a developer of Point of Sale software and are launching a Linux based
product shortly. We wanted to know if there were any plans for MySQL to
support eSQL any time soon. Thanks.
Regards,
Blair M. Melton
Vice President, Grocery and Merchandise Division
Sweda Corporation
(416) 246-5487
Hi!
On Jan 15, Stefaan Van Dooren wrote:
Since some days I don't get any mail from this list anymore.
After some investigation, I found that it's blacklisted and our mailserver
refuses any mail from it.
DNSBL/WARNING: bl.spamcop.net/213.136.52.31: IP is listed
Thanks for alerting us!
I have had some help on my mysql install woes, and here's the latest.
rpm -qa | grep MySQL - this just hung and never returned anything (see
below)
# service mysqld start
or
# service mysql start - these just returned a new command prompt, so
couldn't tell whether or not they worked. I checked
I was going to output a new list of installed packages to ensure that mysql
was in there, but rpm -qa | ./installed_packages doesn't seem to work at the
moment...I can't restart the server right now, so perhaps I could kill and
restart some process? However, this is from yesterday's output:
The
This is in reference to 4.0.16, FWIW...
I can't find any direct references to the actual grant permission for controlling a
slave thread in the online docs. The closest I saw was the 5th paragraph on
http://www.mysql.com/doc/en/Replication_HOWTO.html. It would seem logical that it's
covered by
I'm testing store procedures, and I want to know the number of records returned from a query.
There is a function or variable to get it through odbc?
I'll be trying with mysql_num_results() but makes me en error(seems to be made for c api)
selectfield1 from table where field2=1;
select
I have a table that's used for logging. We do a ton of
SELECTs and INSERTs on this table, but no UPDATEs. In order
to keep the SELECT speed high, we archive most items older
than 30 days by moving them out from this table to another.
This, of course, creates a ton of holes which we optimize
away
Hi Gurus,
I'm currently building an application which is expected
to take very high loads. What the app does is essence is
to 'log' and incoming entry into MySQL, do something then updates
the 'log' entry.
To test MySQL in handling high load, I used siege
on another server to send
So your application tracks incoming HTTP-GETS.
When you say that it's not able to capture all 1000 entries, what do you
mean? Does an exception get thrown? Do some of the HTTP-GETs just not show
in the database?
You need to provide alot more information:
Do all the HTTP-GETs happen on the same
Hi Gurus,
I'm currently building an application which is expected
to take very high loads. What the app does is essence is
to 'log' and incoming entry into MySQL, do something then updates
the 'log' entry.
To test MySQL in handling high load, I used siege
on another server to send 1000
Hi David,
Thanks for you prompt reply. I'll try to answer
your questions to the best I can currently. Please
see my replies below.
David Griffiths wrote:
So your application tracks incoming HTTP-GETS.
When you say that it's not able to capture all 1000 entries, what do you
mean? Does an
Hi!
We are a hardware store(similiar to usa's home depot) here in venezuela.
We have 14 stores that moves a very heavy load of traffic.
Many of our retails runs in a home brew POS that uses mysql. Then sales
are uploaded to a bigger in-store server and then move to the central
office. The
How about from the php api, or something similar:
mysql_num_rows()
Cory
On Thu, 2004-01-15 at 10:43, Alejandro D. Burne wrote:
I'm testing store procedures, and I want to know the number of
records returned from a query.
There is a function or variable to get it through odbc?
I'll be
From the sounds of it, it's not clear if the database is the issue. Of the
1000 records, did the first 100 get in, then no other ones. Or were the
missed-messages intermittent - some were missing in the middle?
You need to figure out if the MySQL connections are throwing an exception.
One thing
At 11:00 -0600 1/15/04, Eamon Daly wrote:
I have a table that's used for logging. We do a ton of
SELECTs and INSERTs on this table, but no UPDATEs. In order
to keep the SELECT speed high, we archive most items older
than 30 days by moving them out from this table to another.
This, of course,
-Message d'origine-
De : Tobias Asplund [mailto:[EMAIL PROTECTED]
Envoyé : Wednesday, January 14, 2004 1:53 PM
À : Ugo Bellavance
Cc : [EMAIL PROTECTED]
Objet : Re: setting a variable
On Wed, 14 Jan 2004, Ugo Bellavance wrote:
mysql 4.0.17 on redhat 9 or debian 3.0
I'm using MySQL for an information retrieval application where word
occurrences are indexed. It seems that performance is not as good as
I would expect (it seems nearly linear with the number of rows).
Any advice would be welcome. I'll lay out a lot of detail.
Some details follow. The basic
Hi,
I would like to turn off caches completely to do some performance testing. I
have version 3.2 of the mysql server installed.
Could you tell me how can I achieve this.
Thanks,
Priyanka
_
There are now three new levels of MSN
At 11:31 -0500 1/15/04, Mike Johnson wrote:
This is in reference to 4.0.16, FWIW...
I can't find any direct references to the actual grant permission
for controlling a slave thread in the online docs. The closest I saw
was the 5th paragraph on
Hi All,
Please pardon the test as I have received no messages from the list in a few
days
Allen
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Somehow the mysql mailserver got listed in spamcop?
Probably the usual SpamCop GIGO problem. If people send false reports,
systems that don't deserve it get listed. I don't use Spamcop anymore for
that reason.
--
It sounds like you are trying to do full text searching, but you
implemented it manually. Was MySQL's full text indexing not
sufficient for your needs or am I totally missing what you are trying
to do?
On Jan 15, 2004, at 1:53 PM, Gregory Newby wrote:
I'm using MySQL for an information
From: Paul DuBois [mailto:[EMAIL PROTECTED]
At 11:31 -0500 1/15/04, Mike Johnson wrote:
This is in reference to 4.0.16, FWIW...
I can't find any direct references to the actual grant permission
for controlling a slave thread in the online docs. The closest I saw
was the 5th paragraph on
On Thu, Jan 15, 2004 at 02:52:30PM -0500, Brent Baisley wrote:
It sounds like you are trying to do full text searching, but you
implemented it manually. Was MySQL's full text indexing not
sufficient for your needs or am I totally missing what you are trying
to do?
You're absolutely right:
Hi Guys,
I am running winxp with mysql 5.0.
I am attempting to run this statement
mysql load data infile c:\\mysql\\pop.txt into table population
(lastname,firstname,age,sickness);
after waiting about a minute I get
ERROR 2013 (HY000): Lost connection to MySQL server during query
and then a
Ok how does one run scripts from the mysql prompt? I tried .\
mysql_install_db and that didn't work. Also the next question I have do you
have to have a messageboard.user table setup in a DB to allow different
hosts to connect to it?
Chris L. White
Network Administrator
Coe-Truman
After some trouble with rpm, I managed to create a file of installed
packages. Redhat 9 says I have installed:
MySQL-client-4.0.1-2
perl-DBD-MySQL-2.1021-3
mysql-3.23.58-1.9
mysql-server-3.23.58-1.9
And I am not having any luck with these...starting them, installing them,
compiling them. I have
Chris L. White wrote:
Ok how does one run scripts from the mysql prompt? I tried .\
mysql_install_db and that didn't work.
If you are at the mysql prompt, the database has already been installed.
Also the next question I have do you
have to have a messageboard.user table setup in a DB to
Description:
my .configure, make make install works with out any error
But when I try to run scripts/mysql_install_db , it hangs after
Installing all prepared tables
How-To-Repeat:
Run mysql_install_db
Fix:
how to correct or work around the problem,
Description:
In install mysql ver 2.23.49 from the SCO site, and untarred
it under the /usr/local/src/mysql-3.23.49 dir.
Then I ran configure as : ./configure --prefix=/usr/local/mysql
Result: No error
Then I ran make as: make
It looks like having a multiple-column index would help more than having
a number of individual indices, at least for the example query. An
index on (termid, docid, whichpara, offset) might work better than just
having one on termid.
joe
On Thu, 2004-01-15 at 10:53, Gregory Newby wrote:
I'm
And then Eve said...
After some trouble with rpm, I managed to create a file of installed
packages. Redhat 9 says I have installed:
MySQL-client-4.0.1-2
perl-DBD-MySQL-2.1021-3
mysql-3.23.58-1.9
mysql-server-3.23.58-1.9
That's right. That's what you get with RH9. I'm repeating myself here from
Gregory
mysql,select,query
I agree with Joe, use multiple-column index. Much more efficient.
All queries should be sub 5-10 seconds or less.
David
-Original Message-
From: Gregory Newby [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 11:53 AM
To: [EMAIL PROTECTED]
Hi,
It contains only 240 records... I have an another table without longblob
field with much much more records, and the query result is less than one second with
joins!
240 records with 11-15 sec... i think something wrong.
If i start a query, MySQL read 30-40 MB to memory! Why? I think, this
Hi,
Maccess helps to analyse data in databases; it is a Web interface to
MySQL server. License is GPL.
Main features:
--
* user friendly query creation for MySQL server
* selective, grouped, and crosstab queries
* various outputs (XML, HTML, TXT, graphs)
* data ungrouping in grouped
Hi,
I'm a newbie to mysql.
I'm running an os10.3 server with mysql v. 4.0.16
When I try to start mysql with 'mysqld_safe ' I get a message that:
Starting mysqld daemon with databases from /var/mysql
040116 10:07:57 mysqld ended
then
nothing... the terminal is blank.
when I then do 'ps auwx | grep
First we cut to the chase with a resolved stack trace from
the most recent crash:
0x80c23d5 handle_segfault__Fi + 425
0x40022f54 _end + 935506260
0x822cdef btr_search_build_page_hash_index + 4771
0x82281c3 btr_search_info_update_slow + 919
0x8213f9e btr_cur_search_to_nth_level + 3154
0x81e9dce
Hi, Tait. It sounds like your server is never actually
starting properly. There could be any number of reasons for
this - it's best to work through the installation instructions
that came with the package.
To see what failed, chances are good there is an entry
in the error log (it will probably
Hi. I'm new to MySQL (and LOVING it) and have a simple question about
importing tab delimited files into MySQL.
I have a table in mysql called form_instances with the following three
fields:
id
student_id
form_id
I want to import records from a tab-delimited file with only two fields:
never mind... just discovered the --columns= option for mysqlimport. :-)
On Jan 15, 2004, at 3:43 PM, Ari Denison wrote:
Hi. I'm new to MySQL (and LOVING it) and have a simple question about
importing tab delimited files into MySQL.
I have a table in mysql called form_instances with the
I have not received any emails from this list since last Sunday - if this
post comes through and anybody has an idea what is wrong please reply to me
off list
Thanks
Freddie
I have created a sql statement that enables me to select all entries in
to MySQL that are dated today, I am trying to do the same for all items
that are now one day old and also two days old etc
I am doing this:
SELECT *
FROM table
WHERE category = 3 AND show = 1 AND date = NOW()-1
I have it
On Thu, Jan 15, 2004 at 02:39:36PM +0100, Stefaan Van Dooren wrote:
Since some days I don't get any mail from this list anymore.
After some investigation, I found that it's blacklisted and our mailserver
refuses any mail from it.
DNSBL/WARNING: bl.spamcop.net/213.136.52.31: IP is listed
well I found my hostname.err file.
It states this:
mysqld started
InnoDB: Operating system error number 13 in a file operation.
The error means that mysqld does not have the access rights to the
directory.
mysqld ended.
so okay - how do I give mysqld the rights to the directory??
I've got mysql
I'm getting an error when trting to update a table:
ERROR 1034: Incorrect key file for table: 'Jan04'. Try to repair it
So I ran CHECK TABLE,
What does this result mean:
mysql CHECK TABLE Jan04 QUICK;
+---+---+--++
On Fri, Jan 16, 2004 at 12:04:38PM +1100, tait sanders wrote:
well I found my hostname.err file.
It states this:
mysqld started
InnoDB: Operating system error number 13 in a file operation.
The error means that mysqld does not have the access rights to the
directory.
mysqld ended.
so
Hello,
The MySQL list server sent me nothing for about 24 hours, until just
recently.
It followed my first attempt to use the support.mysql.com website and change
my details there [that might have been just a coincidence].
I started getting messages again soon after I sent a new subscription
hi all..
i'm using mysql with php4 to develop an online ordering system.
the problem:
when it comes to save, retrieve/view and update data into mysql database, it
takes a long time for the page to load.
the problem occurs after we insert / key in data ( a lot types of data ), after
we click
Hello Jim,
Would you please look at my comments under the thread Not receiving list
emails, in case that puts further light on this matter.
Thanks,
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 16/01/2004, at 12:32 PM, Gregory Newby wrote:
From your description, it's not clear whether you already did this.
If you installed other than with a binary distribution from
mysql.com (or a mirror), it is possible that things are in somewhat
different locations than in the INSTALL-BINARY file.
hello everybody,
i was wondering, if there's a single command to drop all or selected tables from the
database, something like, where i can give the table names (1-2-3) not to be deleted.
Thanx in advance
Nitin
Just wondor how InnoDB handle Multi Level Transaction, For example,
BEGIN
DELETE FORM table1 WHERE id = 123
BEGIN New Transaction Level 2
DELETE FROM table1 WHERE id = 234
COMMIT --- Level2
ROLLBACK ---Level1
Thanks.
79 matches
Mail list logo