:
TW Changing
TW KEY User(User)
TW To
TW KEY User (User)
TW In the dump fixes this.
TWSubmitter-Id: None
TWOriginator:Tony Wells
TWOrganization:
TW None
TWMySQL support: none
TWSynopsis: mysqldump of mysql database has syntax error in SQL
TWRelease: mysql-3.23.33 (Source distribution
Synopsis: mysqldump of mysql database has syntax error in SQL
Severity: non-critical
Priority:
Category: mysql
Class:
Release: mysql-3.23.33 (Source distribution)
Server: /usr/local/bin/mysqladmin Ver 8.15 Distrib 3.23.33, for -freebsd4.2 on i386
Copyright (C
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
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
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
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
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 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
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(MYSQL
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
re 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 compiled from sources using gcc-2
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
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,
problem:
run command mysqld --
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
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 |
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
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
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
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 is
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 linux-2.2.14 (Redhat
: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 check the mailing list archives _BEFORE_ posting
Lyman Neuschaefer wrote:
Greetings,
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/mysql
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 PROTECTED
((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
MySQL 3.23.33 and did a mysqldump
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.33
*** Error code 1
make:
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 * from
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 2.5.4
Hi!
"Sasha" == Sasha Pachev [EMAIL PROTECTED] writes:
cut
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 test
[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 offending
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 decided
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 decided
On Thursday 01 March 2001 13:32, Quentin Bennett wrote:
cut
After the patch, MySQL still passes our test suite, which is a good sign.
/cut
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
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
Hello,
here attached you'll find a mysqlbug report des cribing a compilation
problem of the mysql client.
Thanks for any help
--
Grard GACHELIN e-mail : [EMAIL PROTECTED]
Universit de la Runion Tl: 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
--
=
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
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 information about
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.
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 MySQL-be
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
42 matches
Mail list logo