On 1/25/07, Sid Lane <[EMAIL PROTECTED]> wrote:
all,
I have been tasked with upgrading a critical 3.23.55 database to 5.0
(.27-ish).
short version is it's never been upgraded because authors have moved on
and
nobody's sure of everything that uses it.
I enabled the general lo
all,
I have been tasked with upgrading a critical 3.23.55 database to 5.0(.27-ish).
short version is it's never been upgraded because authors have moved on and
nobody's sure of everything that uses it.
I enabled the general log a few days ago and have a good body of data with
which
I have PERL DBI/DBD installed.
What SQL do I issue to obtain list of all tables with PK for a given database?
What SQL do I issue to obtain the SQL source to (re)create all indexes for a
given database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote:
>
> I use Version DBMS MySQL 3.23.55 runing under Windows 2000.
>
> I have coded this from a textbook;
> ===
>
>
> C:\mysql\bin>type constraint.sql
> USE company;
>
> DROP TABLE IF EXIS
Hello programmers:
I use Version DBMS MySQL 3.23.55 runing under Windows 2000.
I have coded this from a textbook;
===
C:\mysql\bin>type constraint.sql
USE company;
DROP TABLE IF EXISTS EMPLOYEE;
CREATE TABLE EMPLOYEE
(
FNAME VARCHAR(15) NOT NULL,
MINIT C
CTED]
(BSubject: [50 character or so descriptive subject here (for reference)]
(B
(BError in compilation of MySQL 3.23.55
(B
(B>Description:
(B
(B
(BI was trying to install MySQL 3.23.55 on our HP-UX server.
(BThere were errors generated when I tried to compile it.
(BError points
[mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 8:38 AM
To: [EMAIL PROTECTED]
Subject: schema and Catalog under MySQL 3.23.55
Hi programmers,
I try to investigate some of the basics behind schemas and cataloges,
Which is part of SQL2 Language
this is the error message I get:
C:\mysql
\g.
Your MySQL connection id is 246 to server version: 3.23.55-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create schema company_00 authorization administrator;
ERROR 1064: You have an error in your SQL syntax near 'schema company_0
Estoy tomando el sol
.
q
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Estoy tomando el sol
.
q
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
m forwarding this to Sanja.
IMHO current behaviour is absolutly correct.
Mikhail.
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 24, 2003 11:43 PM
Subject: Re: InnoDB locking: Different behavior on 3.23.55
Message -
From: ""Mikhail Entaltsev"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 24, 2003 3:44 PM
Subject: InnoDB locking: Different behavior on 3.23.55 and 4.0.13
> --=_NextPart_000_0119_01C351F2.03137C50
> Content-Typ
Hi
I have 2 MySQL servers:
Server1 is 3.23.55-max-log
Server2 is 4.0.13-standard-log
Let's assume that we have 2 connections (Conn1 and Conn2) and table test:
CREATE TABLE `test` (
`id` int(3) NOT NULL auto_increment,
`name`
Devin <[EMAIL PROTECTED]> wrote:
>
> I noticed that my MySQL 4.0.13 Slave Replication server is having
> a wierd problem. If you look at the master.info file on the slave
> it keeps updating like it is really updating the slave but in
> the mysql.err log it shows:
>
> 030609 16:12:08 Slave I/O t
I noticed that my MySQL 4.0.13 Slave Replication server is having
a wierd problem. If you look at the master.info file on the slave
it keeps updating like it is really updating the slave but in
the mysql.err log it shows:
030609 16:12:08 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3
On Friday 04 April 2003 11:19, Li Robert wrote:
> Does MySQL support Japanese database name and Japanese table name?
> How to enable it?
Section 6.1.2 Database, Table, Index, Column, and Alias Names:
http://www.mysql.com/doc/en/Legal_names.html
"A name may consist of alphanumeric charact
Hi, all
Does MySQL support Japanese database name and Japanese table name?
How to enable it?
Thanks and regards
Robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DM wrote:
Im trying to restore a database dumb taken from a Sun Cobalt RAQ4 running Mysql 3.23.37 and restore it to a new Dell PowerEdge running Redhat 7.3 with Mysql 3.23.55.
I have tried from both the command line and using phpmyadmin
With Command line /usr/bin/mysql database -uuser -ppassword
Im trying to restore a database dumb taken from a Sun Cobalt RAQ4 running Mysql
3.23.37 and restore it to a new Dell PowerEdge running Redhat 7.3 with Mysql 3.23.55.
I have tried from both the command line and using phpmyadmin
With Command line /usr/bin/mysql database -uuser -ppassword <
/
Thats right.
problem resolved.
Thanks.
set-variable=thread_stack=256k
in the [mysqld] portion of you're my.cnf file.
HTH
-Bart
-Original Message-
From: Jose [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 16, 2003 10:22 AM
To: [EMAIL PROTECTED]
Subject: How to compile mysql-3.23.
In the last episode (Mar 16), Jose said:
> Now i'm trying to compile 3.23.55 version to probe if it works. I use
> gcc-3.2.1. I have read installation instructions for aix but i get
> this error for "make" process:
>
> gcc -pipe -mcpu=power -Wa,-many -O3 -DDBUG
, March 16, 2003 10:22 AM
To: [EMAIL PROTECTED]
Subject: How to compile mysql-3.23.55 on Aix 4.3.3.11
Hi!
First of all i had working mysql 3-23-35 on aix 4.3.3.10.
After upgrade to 4.3.3.11 it doesn't works. I get:
Warning: mysql_select_db() [function.mysql-select-db]: Can't connect t
Hi!
First of all i had working mysql 3-23-35 on aix 4.3.3.10.
After upgrade to 4.3.3.11 it doesn't works. I get:
Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to
local MySQL server through socket '/tmp/mysql.sock
Now i'm trying to compile 3.23.55 ve
://www.mysql.com
sql query
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, March 13, 2003 11:13 AM
Subject: Incorrect handling of foreign key constraints in InnoDB tables in
MySQL 3.23.55-max run on Windows ME
> Hi,
>
> If a &qu
I hope you can use the following example to repeat the problem and fix
this bug
Thank you
Jan Mazánek
[EMAIL PROTECTED]
#
========
===
# Incorrect handling of foreign key constraints in InnoDB tables in
MySQL 3.23.55-max
#
I have never tried MS DTS, but SQLyog works great for
me in transferring MS SQL Server data to MySQL.
--- phil <[EMAIL PROTECTED]> wrote:
> How-To-Repeat:
>
>
> I am tried to use MS DTS to transfer a table from
> MSSQL 2000 to MYSQL
> 3.23.55,
> however th
How-To-Repeat:
I am tried to use MS DTS to transfer a table from MSSQL 2000 to MYSQL
3.23.55,
however there has an error during the transformation on one data type. The
error happens when I have a "text" datatype on MSSQL 2000 table, and
"text/blob" on MySQL table.
T
Hallo,
we have downloaded the new 3.23.55 mysql DB from you as Source Download
Tarball (tar.gz) and want to build them in our environment for tests
under SUN OS.
We have tared the downloaded version in our Scource Directory environment.
(for example /mysql/src/mysql-3.23.55)
After that we
Hallo,
we have downloaded the new 3.23.55 mysql DB from you as Source Download
Tarball (tar.gz) and want to build them in our environment for tests
under SUN OS.
We have tared the downloaded version in our Scource Directory environment.
(for example /mysql/src/mysql-3.23.55)
After that we want
Hi, I downloaded the rpm file for this and installed using rpm -i MySQL-3.23.55-1.rpm.
It went fine and said I should run mysqladmin to set root password but all I got was
'command not found'.
I then tried to uninstall it, without much luck:
[EMAIL PROTECTED] Downloads]# rpm -e MyS
>Release: mysql-3.23.55-max (Official MySQL-max binary)
>Environment:
System: Darwin iMaxSales-Hancock.local. 6.4 Darwin Kernel Version 6.4:
Wed Jan 29 18:50:42 PST 2003; root:xnu/xnu-344.26.obj~1/RELEASE_PPC
Power Macintosh powerpc
We have tables with mixed case
At 17:43 24/02/2003 +, Simon Tyler wrote:
Hi,
Hi,
I've been trying to get the 3.23.55 version of mysqld-nt.exe working with
our product (GMS Mail) and I'm running into install\service related
issues. I've read through the various threads on this list and nothing
seems to s
Hi,
I've been trying to get the 3.23.55 version of mysqld-nt.exe working with our product
(GMS Mail) and I'm running into install\service related issues. I've read through the
various threads on this list and nothing seems to solve my problem.
The situation is that we include
On Thursday 20 February 2003 17:59, you wrote:
> > > C:\mysql>mysql -u b R
> > > ERROR 1044: Access denied for user: 'b@localhost' to database 'r'
> >
> > I guess no. In 3.23.55 by default lower_case_table_names=1 on Windows, so
>
> all
ichot" <[EMAIL PROTECTED]>
> To: "Jeff Kilbride" <[EMAIL PROTECTED]>
> Cc: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, February 20, 2003 1:06 PM
> Subject: Re: BUG? 3.23.55 not replicating LOAD DATA INFILE
3.x to get rid of this
problem?
Thanks,
--jeff
- Original Message -
From: "Guilhem Bichot" <[EMAIL PROTECTED]>
To: "Jeff Kilbride" <[EMAIL PROTECTED]>
Cc: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, February
; The file I was loading was approx. 5MB and none of the data made it to the
> slaves.
>
> Thanks,
> --jeff
>
> - Original Message -
> From: "Heikki Tuuri" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: T
]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 5:32 AM
Subject: re: BUG? 3.23.55 not replicating LOAD DATA INFILE
> Jeff, Egor,
>
> Guilhem Bichot just found a bug in replication of LOAD DATA LOCAL INFILE
in
> 4.0.
>
> Th
selective replication of some tables or databases? If yes,
check also that your LOAD DATA INFILE is not excluded by these rules.
Regards,
Heikki
Innobase Oy
sql query
.
Subject: re: BUG? 3.23.55 not replicating LOAD DATA INFILE
From: Egor Egorov
Date: Thu, 20 Feb 2003 14:07:02 +0200
On Wednesday 19 February 2003 13:19, Juri Shimon wrote:
> Is it a bug?
>
> C:\mysql>mysql -u root
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 29 to server version: 3.23.55-max-nt
>
> mysql> create database R;
> Quer
On Thursday 20 February 2003 01:04, Jeff Kilbride wrote:
> I have one master and two slaves all running 3.23.55-max on RedHat 7.3.
> I've had replication up and running smoothly for several days. Today, I
> decided to try out LOAD DATA INFILE on the master. After successfully
&g
Thansk for the information Fred.
Iago Sineiro.
> -Mensaje original-
> De: Fred van Engen [mailto:[EMAIL PROTECTED]]
> Enviado el: jueves, 20 de febrero de 2003 10:37
> Para: Iago Sineiro
> CC: MySql Mail List
> Asunto: Re: Possibly bug in InnoDB with mysql 3.23.55
>
Hi,
On Thu, Feb 20, 2003 at 10:12:56AM +0100, Iago Sineiro wrote:
> I think I detected a bug in InnoDB with MySQL 3.23.55.
>
> I have a table named ARTICLE_POID of type InnoDB and transaction_isolation
> is READ-COMMITTED. AUTOCOMMIT is 1 (default value).
>
...
> I think thi
Hi.
I think I detected a bug in InnoDB with MySQL 3.23.55.
I have a table named ARTICLE_POID of type InnoDB and transaction_isolation
is READ-COMMITTED. AUTOCOMMIT is 1 (default value).
mysql> DESCRIBE ARTICLE_POID;
+++--+-+-+---+
| Field | T
I have one master and two slaves all running 3.23.55-max on RedHat 7.3. I've
had replication up and running smoothly for several days. Today, I decided
to try out LOAD DATA INFILE on the master. After successfully loading on the
master, I checked both slaves and neither one had the new data.
Hi!
Is it a bug?
C:\mysql>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29 to server version: 3.23.55-max-nt
mysql> create database R;
Query OK, 1 row affected (0.06 sec)
mysql> grant all privileges on `R%`.* to b;
Query OK, 0 rows
Hi!
Is it a bug?
C:\mysql>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29 to server version: 3.23.55-max-nt
mysql> create database R;
Query OK, 1 row affected (0.06 sec)
mysql> grant all privileges on `R%`.* to b;
Query OK, 0 rows
Hi,
Compilation of mysql 3.23.55 fails ONLY when using "--with-mysqld-ldflags=-all-static"
results in broken mysqld.
Segmentation fault?
Resolving stack trace:
0x808f4d4 _Z15handle_segfaulti + 404
0x81bc67a __pthread_sighandler + 122
0x81ceb4d __strtol_internal + 1421
Hi!
On Feb 05, Tue Tønning wrote:
> Hey,
>
> I have discovered a strange error in the mysql versions mentioned in subj.
>
> Example.
> A table with 10 entries ...i want to draw 3 randomly
> => "select fieldName from tableName order by RAND() limit 3"
>
> this have worked for the last year or so
I get this message back:
Failed dependencies:
MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.55-1
I know I have this dependency installed, but I think I know where the
problem is just not sure how to fix it. Here is what I get when I do a
'rpm -qa | grep DBI-perl':
Mysql-DB
I am having problems installing MySQL 3.23.55 on RedHat 8.0. The
version that came with RedHat will not let me remotely login. I found a
thread at RedHat that said that this is a known problem. One of the
suggestions was to upgrade MySQL. That is what I am attempting to do.
This is what
sql, query.
Hi, group,
Greetings!
I'd like to hear your advice about "what's the best way to upgrade 3.23.47
to 3.23.55 on SunOS 5.8 with less downtime"?
Thank you,
Jannie
_
Add photos to your e-mail with
he compile error shows incorrect arguments supplied to
gethostbyname_r.
>Submitter-Id: FUF
>Originator:root
>Organization:
>MySQL support: none
>Synopsis: mysql-3.23.55 libmysql.c:1348 invalid gethostbyname_r arguments
>Severity: serious
>Priority: medium
"Tue Tønning" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 05, 2003 1:38 PM
Subject: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)
> Hey,
>
> I have discovered a strange error in the mysql versions mentioned in subj.
>
> Ex
Hey,
I have discovered a strange error in the mysql versions mentioned in subj.
Example.
A table with 10 entries ...i want to draw 3 randomly
=> "select fieldName from tableName order by RAND() limit 3"
this have worked for the last year or so.but after upgrading our redhat
7.2 with mysql ve
On Monday 03 February 2003 23:20, Dana Shields wrote:
> I've got a beginner's question: I've installed SQL Server, and begun
> building tables; when I create a new table, the table type is defaulting to
> MyISAM. I wanted to change it to InnoDB, but everytime I save it, it
> reverts back to MyISAM.
, February 03, 2003 3:21 PM
To: [EMAIL PROTECTED]
Subject: MySQL 3.23.55-nt on Windows 2000: Trying to Create InnoDB
Tables
I've got a beginner's question: I've installed SQL Server, and begun
building tables; when I create a new table, the table type is defaulting to
MyISAM. I wanted
Take a look at http://www.mysql.com/doc/en/NT_start.html. And about
innodb tables you can read http://www.innodb.com/ibman.html.
[EMAIL PROTECTED] wrote:
I've got a beginner's question: I've installed SQL Server, and begun
building tables; when I create a new table, the table type is defaulting
I've got a beginner's question: I've installed SQL Server, and begun
building tables; when I create a new table, the table type is defaulting to
MyISAM. I wanted to change it to InnoDB, but everytime I save it, it reverts
back to MyISAM.
Is this feature not available in Windows? It appears that "m
Hi.
Im trying to compile MySQL 3.23.55 (.tar.gz) on Slackware 8.1 Patched to
9.0-beta. In configure I just used --prefix, and it fails on the make
part:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1349: warning: passing arg 5 of `gethostbyname_r' from
incompatible po
Rogger,
- Original Message -
From: "Rogger Vasquez" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 24, 2003 4:43 PM
Subject: Re: MySQL/InnoDB-3.23.55 is released
&
Hi!
InnoDB is a MySQL table type which supports transactions, foreign key
constraints, and a non-free hot backup tool.
Version 3.23.55 is a bugfix release of the stable 3.23 branch, which is
recommended for production use.
Users who have had concurrency problems in INSERT INTO ... SELECT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 3.23.55, a new version of the popular Open Source Database, has been
released. It is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
Note that
Hi people,
what is the status of version 3.23.55? It's already available for download
from www.mysql.com, but the links on the official download page all points
to 3.23.54a...
regards
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-311
64 matches
Mail list logo