roblem. Feel
TW> free to email me if more information is needed.
TW>How-To-Repeat:
TW> Dumping the mysql database is enough to re-create this problem. (Checked in both
TW> 3.23.33 and 3.23.32.)
TW>Fix:
TW> Changing
TW> KEY User(User)
TW> To
TW> KEY User (User)
TW> In
m not just re-iterating a previously fixed problem. Feel
free to email me if more information is needed.
>How-To-Repeat:
Dumping the mysql database is enough to re-create this problem. (Checked in both
3.23.33 and 3.23.32.)
>Fix:
Changing
KEY User(User)
To
KEY User (User)
In the dump fixes
Please solve the problems :
# uname -a
SunOS Adviser.chiangmai.ac.th 5.7 Generic_106541-02 sun4m sparc
SUNW,SPARCstation-10
# gcc -v
Reading specs from
/usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.1/specs
gcc version 2.95.1 19990816 (release)
# pwd
/export/home0/mysql-3.23.33
Please solve the problem :
# uname -a
SunOS mail.chiangmai.ac.th 5.7 Generic_106541-02 sun4m sparc
SUNW,SPARCstation-10
# make -v
GNU Make version 3.78.1, by Richard Stallman and Roland McGrath.
Built for sparc-sun-solaris2.7
# pwd
/export/home0/mysql-3.23.33
# make
# make install
Making
MySQL 3.23.33-1 files posted on ftp.mysql.com:
ftp://ftp.mysql.com/MySQL-3.23/MySQL-shared-3.23.33-1.i386.rpm
ftp://ftp.mysql.com/MySQL-3.23/MySQL-3.23.33-1.i386.rpm
ftp://ftp.mysql.com/MySQL-3.23/MySQL-client-3.23.33-1.i386.rpm
I really appreciate the fine effort you have put into maintaining
the
Edward Smirnov writes:
> Hello Sinisa,
>
> Saturday, March 31, 2001, 3:45:27 PM, you wrote:
>
> SM> There is no such function in mysql.h.
>
> Small piece from mysql.h is below:
> **
> char * STDCALL mysql_error(MYSQL *mysql);
> char * STDCALL mysql_info
Hello Sinisa,
Saturday, March 31, 2001, 3:45:27 PM, you wrote:
SM> There is no such function in mysql.h.
Small piece from mysql.h is below:
**
char * STDCALL mysql_error(MYSQL *mysql);
char * STDCALL mysql_info(MYSQL *mysql);
unsigned long STDCALL mysql_thread_id
mySQLDAC writes:
> Hello John,
>
> We are developing the next version of MySQLDAC (MySQL Direct access
> components for Delphi/C++ Builder).
>
> We've found
> const char * STDCALL mysql_character_set_name(MYSQL *mysql) in mysqlh.h
>
> But we've not found this function in libmysql.dll (
Hello John,
We are developing the next version of MySQLDAC (MySQL Direct access
components for Delphi/C++ Builder).
We've found
const char * STDCALL mysql_character_set_name(MYSQL *mysql) in mysqlh.h
But we've not found this function in libmysql.dll (ver.3.23.33)
Is ther alternative ways to ge
Thanks for suggestions, just downgrading now.
Alexander
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <
uot;average", because we have more than 30 databases with different
> structure and lot of different kind of sql queries.
> Mysql used for web projects (Queries per second avg: 35.859).
>
> Both mysql-3.23.35 and mysql-3.23.33 comp
an 30 databases with different
structure and lot of different kind of sql queries.
Mysql used for web projects (Queries per second avg: 35.859).
Both mysql-3.23.35 and mysql-3.23.33 compiled from sources using gcc-2.95.2
Did you shutdown the mysql server before running skip grants?
- Original Message -
From: "anna" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 10:55
Subject: bug? no work on new version MySQL-3.23.33
> Dear Sir,
>
>pr
r is fresh installed with redhat linux6.2 and MySQL-3.23.33.
also I followed the instruction: 20.10 How to Reset a Forgotten Password from
http://www.mysql.com/doc/R/e/Resetting_permissions.html
but about half years ago, at the same platform and run MySQL-3.22.32
these command work very wel
More interesting rezults, after runnig some check/repair/analyze commands
in sequence on the same table:
mysql> repair table http_refer extended;
+-++--+--+
| Table | Op | Msg_type | Msg_text |
+-++--+--
Hi,
I'm a bit desperate and have some questions to ask.
I'm working with my own compiled server 3.23.33 on SuSe 7.0
I have table:
mysql> desc test.http_refer;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra
t;[EMAIL PROTECTED]>
> Sent: Sunday, March 11, 2001 4:46 PM
> Subject: Re: configure fails on linux-2.2.14 (Redhat 7.0), mysql-3.23.33
>
> > This has been discussed to death,
> >
> > DO NOT RUN GCC 2.96 TO COMPILE MySQL IT IS FAR TO BUGGY
> >
> > Please chec
Are you always this hospitable to others?
Charles
- Original Message -
From: "Colin Faber" <[EMAIL PROTECTED]>
To: "Lyman Neuschaefer" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, March 11, 2001 4:46 PM
Subject: Re: configure fails on li
This has been discussed to death,
DO NOT RUN GCC 2.96 TO COMPILE MySQL IT IS FAR TO BUGGY
Please check the mailing list archives _BEFORE_ posting
Lyman Neuschaefer wrote:
>
> Greetings,
>
> The configure process fails on attempting to compile and link the executable
>
> conftest. Below i
Greetings,
The configure process fails on attempting to compile and link the executable
conftest. Below is some of the output generated by configdebug.
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2
Jeremy Huddleston wrote:
> Has anyone had similar problems or know a way around other than just not
> using BerkeleyDB?
That's not a valid problem. And it's not MySQL's fault either that no one
reads the README and/or INSTALL files that come with the product.
You need to download the p
I am compileing MySQL 3.23.33 with the following options:
--prefix=/usr/local
--with-berkeley-db=/disks/eradicator/i686/BerkeleyDB
--with-berkeley-db-includes=/disks/eradicator/i686/BerkeleyDB/include/
--with-berkeley-db-libs=/disks/eradicator/i686/BerkeleyDB/lib/
I have BerkeleyDB 3.2.9, and
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Can't compile MySQL 3.23.33 on Solaris 7 (x86)
Description:
Configure fails, says there may not be any static libraries. I can find
libm.a in /lib
however. I have installed G++ 2.95.2
How-To-Repeat:
./configure --prefix=/usr/local/
>I think I figured the problem out, but I still do not understand
>what happened, the following is showing how I got the query to
>work. I basically had to re-import suppliersiclink table to get this
>to work right in MySQL 3.23.33, but why? The data was fine in
>MySQL 3.22.
&
*** Error code 1
make: Fatal error: Command failed for target `mysql.o'
Current working directory /u3/software/unix/install/mysql-3.23.33/client
*** Error code 1
make: Fatal error: Command failed for target `all-recursive'
Current working directory /u3/software/unix/install/mysql-3.23.3
I think I figured the problem out, but I still do not understand what happened, the
following is showing how I got the query to
work. I basically had to re-import suppliersiclink table to get this to work right in
MySQL 3.23.33, but why? The data was fine in
MySQL 3.22.
mysql> select * f
WHERE ((subcatsicbond.sub_catid=37) AND (supplier.max_latitude<=32.99) AND
(supplier.min_latitude>=31.55) AND (supplier.min_longitude>=89.25) AND
(supplier.max_longitude<=90.97))
ORDER BY supplier.company_name ASC
LIMIT 0,10;
Which works fine, but takes forever, I've upgrade a test machine to
M
I have a master and slave server, both running mysql-3.23.29-gamma.
When I set up a second slave running mysql-3.23.33, it logged these
errors:
010304 10:18:50 mysqld started
/opt/local/mysql/libexec/mysqld: ready for connections
010304 10:18:51 Slave: connected to master '[EMAIL PROT
Hi!
> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
Sasha> I do have a patch for it now. From what I understood in the code, this is
Sasha> actually a more correct way to do things, but I would like to get Monty's
Sasha> approval to be sure. After the patch, MySQL still passes our
Hi Sasha,
The patch you sent me seems to have created other problems,
or simply has allowed to find new ones :)
I'm working on isolating exactly which query makes the bdb
tables crash. Full bug report on the way.
So far, it looks like left joins on bdb tables does something weird.
I was using
Hi
I'm follwing all instructions to install mysql-3.23.33 on Solaris
8 to X86, and the compilers and programs installed are
gcc version 2.95.2 19991024 (release)
perl v5.6.0 built for i86pc-solaris
tcl tcl8.3
make 3.79
flex version
On Thursday 01 March 2001 13:32, Quentin Bennett wrote:
>
>
>After the patch, MySQL still passes our test suite, which is a good sign.
>
>
>
>But how come it passed the test suite with the bug in place ?? ;-)
It does not any more, with the bug not fixed, that is. We update the test
suite every
After the patch, MySQL still passes our test suite, which is a good sign.
But how come it passed the test suite with the bug in place ?? ;-)
Quentin
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
reci
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I de
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I de
On Thu, Mar 01, 2001 at 12:04:27AM -0500, [EMAIL PROTECTED] wrote:
>
> I've replicated this problem on 3 different machines, and
> on 3.23.33 and 3.23.32. I had been using BDB tables for a
> couple weeks now in testing, without a hitch until the above
> query starting being used. I also tried to
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I de
[EMAIL PROTECTED] writes:
> Hi folks, I'm having a hard time using bdb tables. Here are the
> details...
>
> I've create a few BDB tables, which are causing me great amounts
> of grief. The tables worked fine for a while, then suddenly
> started crashing mysqld. I decided to drop the offend
Hi folks, I'm having a hard time using bdb tables. Here are the
details...
I've create a few BDB tables, which are causing me great amounts
of grief. The tables worked fine for a while, then suddenly
started crashing mysqld. I decided to drop the offending
database, and re-create it. No problem s
Hello,
here attached you'll find a mysqlbug report des cribing a compilation
problem of the mysql client.
Thanks for any help
--
Gérard GACHELIN e-mail : [EMAIL PROTECTED]
Université de la Réunion Tél: 0262 93 82 72
15, Avenue René Cassin - BP 7151
Greets All:
I've got the above (subject) build created and, need to free up some space on
the machine. Anyone want it, and, is there a good way to shrink it down or make
a binary package?
Let me know.
Regards,
Van
--
=
Li
I am using 3.23.33.
I had posted a question asking for ways to improve my insert performance,
and I got a reply asking to use DELAYED.
I used it, but it seems like DELAYED takes twice the time a normal INSERT wud take.
Anything I am missing?
My table has 25 records and I am using DELETE FR
Hi!
I am trying to insert 1 000 000 records into a very simple
table:
create table test (
a1 tinyint unsigned not null,
a2 tinyint unsigned not null,
a3 tinyint unsigned not null,
a4 tinyint unsigned not null,
primary key (a1,a2,a3,a4)
);
So, to make it faste
Upon trying to compile MySQL 3.23.33 for BSDi, I get the following error
message. The line used to configure was:
./configure --with-low-memory --prefix=[mysql path] (and before someone
emails) where [mysql path] is filled in with the path I used...
gcc -DMAP_TO_USE_RAID -I./../include -I
Okay, here's the deal.
First I unpack the .tar.gz into /a-path-name/mysql-dir-name
After that I should (atleast according to the readme) type ./configure
--prefix=/usr/local/mysql
That script tells me that this is a binary version and that I dont need to configure
it, it's ready to rock as it
Hi!
> "Christian" == Christian Hammers <[EMAIL PROTECTED]> writes:
Christian> Michael, it would be very nice if you would mark security related bugs
Christian> so that admins who are not subscribed on Bugtraq see them, too.
Christian> This is at least the second time where I got informatio
I had the same problem just yesterday.
-> MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.33-1
benchmark uses Perls DBI modules, so U have to install them before installing
MySQL-bench.
Unless U R going to perform benchmarking U need not install MySQL-bench modules.
-> mysql = 3.23.22 is ne
"They're bccckkk!!!"
Try installing, using the skip dependency check flag.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 11:13
Subject: installing mysql 3.23.33 rpm on RH7
> Hi,
>
&g
Hi,
I'm trying to install the lastest version of mysql 3.23.33 rpm
(downloaded from mysql.com) on RH7 using the command "rpm -Uvh MySQL*"
but encountered "failed dependencies error" as shown below:
error: failed dependencies:
MySQL-DBI-perl-bin is needed by MyS
Michael, it would be very nice if you would mark security related bugs
so that admins who are not subscribed on Bugtraq see them, too.
This is at least the second time where I got information about security
bugs in MySQL *only* via 3rd party and not from the web page nor from the
changelog.
Disa
Hi!
This release mainly fixes some bugs in replication. If you are not
using replication you probably don't have any reasons to upgrade.
Changes in release 3.23.33
--
* Added `--character-sets-dir' to `myisampack'.
* Removed warnings when running `REPAIR TABLE
51 matches
Mail list logo
