Has anyone upgraded MySQL 4.0 to 5.0 on a Mac running Mac OS X
Panther, 10.3.9 Sever with Lasso 8.5.4? I'm debating whether to just
upgrade to MySQL to 5.0 or jump to Apples Leopard Server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Since we upgraded from MySQL 4.0 to 5.0 (under OpenBSD 4.1 amd64) the
following command:
select count(*) as total from products_description pd, products p left
join manufacturers m on p.manufacturers_id = m.manufacturers_id,
products_to_categories p2c left join specials s on p.products_id =
Try not mixing left join and comma-joins, and use an INNER JOIN keyword
between m.manufacturers_id, products_to_categories
Baron
Federico Giannici wrote:
Since we upgraded from MySQL 4.0 to 5.0 (under OpenBSD 4.1 amd64) the
following command:
select count(*) as total from
Hi Frederico,
the precedence between the comma-operator and JOIN changed
with 5.0.12.
See http://dev.mysql.com/doc/refman/5.0/en/join.html
Excerpt from that article:
Previously, the comma operator (,) and JOIN both had the same
precedence, so the join expression t1, t2 JOIN t3 was interpreted as
Hi, i was sleep during 2 years and yet no update mysql 3.2X... :)
First i download :
MySQL-server-4.0.23-0.i386.rpm
MySQL-client-4.0.23-0.i386.rpm
MySQL-devel-4.0.23-0.i386.rpm
MySQL-shared-4.0.23-0.i386.rpm
MySQL-shared-compat-4.0.23-0.i386.rpm
But when rpm -Uvh *.rpm
warning:
Hi!
I'm a hosting provider with several thousands of Mysql Databases under 4.0
version. I'm specially worried about TIMESTAMP format changes you did in
4.1. I'll have to update database server soon to have my systems updated.
I think that if i update my server version thousands of tables
I had to migrate from 4.0.11 to 4.1.12. I saved the data directory from the
older version. I also exported all the information using phpMyAdmin's export
tool. I have one huge .sql file.
When I upgraded to 4.1.12, I followed instructions to copy the contents of
the old data directory to the new
When mysql had trouble starting up what error messages did it give in
the .err file in the datadir?
-Eric
James Tu wrote:
I had to migrate from 4.0.11 to 4.1.12. I saved the data directory from the
older version. I also exported all the information using phpMyAdmin's export
tool. I have one
Hello Sergei
On Thu, Apr 07, 2005 at 03:14:10PM +0200, Sergei Golubchik wrote:
I've just run into deep troubles while upgrading from 4.0.24 to 4.1.10a
using precomiled Debian packages on Debian Woody although I read the
comments regarding upgrading on dev.mysql.com.
After starting the
Hi!
On Apr 11, Christian Hammers wrote:
Hello Sergei
On Thu, Apr 07, 2005 at 03:14:10PM +0200, Sergei Golubchik wrote:
I've just run into deep troubles while upgrading from 4.0.24 to 4.1.10a
using precomiled Debian packages on Debian Woody although I read the
comments regarding
Hello Sergei
On Thu, Apr 07, 2005 at 03:14:10PM +0200, Sergei Golubchik wrote:
I've just run into deep troubles while upgrading from 4.0.24 to 4.1.10a
using precomiled Debian packages on Debian Woody although I read the
comments regarding upgrading on dev.mysql.com.
After starting the
Hello
I've just run into deep troubles while upgrading from 4.0.24 to 4.1.10a
using precomiled Debian packages on Debian Woody although I read the
comments regarding upgrading on dev.mysql.com.
After starting the new server and running mysqlcheck -r -v -A, I
experienced the following problems on
Hello.
As said at:
http://dev.mysql.com/doc/mysql/en/charset-conversion.html
You should avoid trying to convert directly from latin1 to the real
character set. If you have a backup, import a table from it. Check
that your character_set_xxx variables have a corresponding values.
See:
Hi..
I encountered some problems with character sets.
On the 4.0 version I stored UTF-8 strings. When upgraded to 4.1, I saw
the default character set was 'latin1', so I converted to UTF-8 using this:
ALTER TABLE my_table CONVERT TO CHARACTER SET 'utf8', DEFAULT CHARACTER
SET 'utf8';
When
I have the same problem with cp1251 and, seems, it's a bug. I have posted
correspoding message two days ago. Without any reply 8(((
I migrate 3.23.55 - 4.1.1 and I don't know about existing such problem in
4.0.
Look in your table.frm - your field is in correct charset. More of,
inserts and
It's known bug, will be fixed in 4.1.2
- Original Message -
From: Juri Shimon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Noor Dawod [EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 12:37 PM
Subject: Re: Invalid ENUM values after upgrading from 4.0 to 4.1
I have the same problem
Hi,
I'm facing a problem with the new 4.1 branch.
I've built MySQL from sources with default-language=hebrew and
extra-languages=utf.
I've also used default-collation=hebrew_general_ci.
After installing, this is what I get for few of the variables:
mysql show variables like '%char%';
Hello All!
I really need a hand here. I'm volunteering at this NGO (non-profit org)
in New Delhi. I and another developer built a .NET/MySQL app for managing
the communications department. The app worked sweet on our machines, but
when we moved it to the server and ran a UNION query (one of
: Thursday, October 16, 2003 1:12 PM
Subject: Nasty Time Upgrading to 4.0 RPM dependencies - libmysqlclient.so.10
and php
Hello All!
I really need a hand here. I'm volunteering at this NGO (non-profit org)
in New Delhi. I and another developer built a .NET/MySQL app for managing
- Original Message -
From: Thomas Andersson
Sent: Saturday, August 23, 2003 8:15 AM
Subject: Upgrading 3.23-4.0 under WinXP ?
Hi!
I'm pretty green at this and I'm a bit clueless here, After
reinstalling my
system I upgraded from 3.23 to 4.0 of MySQL, then I moved my old dbs
Hi!
I'm pretty green at this and I'm a bit clueless here, After reinstalling my
system I upgraded from 3.23 to 4.0 of MySQL, then I moved my old dbs in
there and most seems to work OK. Now PHPMyAdmin tells me my userbase is out
of date and that I need to run mysql_fix_privilege_tables...
HOW do
Hi all !!
I am trying to upgrade to MySql 4.0 from 3.23 version. I dont know how to
proceed. I was looking for some files for upgrading but i found nothing. Any
help??
Thanks
Broad Telecom S.A. (BTESA) - Spain
Manuel Díaz-Regañón
phone: 913274363
e-mail: [EMAIL PROTECTED]
--
MySQL General
On Tue, 2003-06-17 at 16:05, Manuel Diaz-Regañón wrote:
Hi all !!
I am trying to upgrade to MySql 4.0 from 3.23 version. I dont know how to
proceed. I was looking for some files for upgrading but i found nothing. Any
help??
on which os ? if it's FreeBSD, I've just done it this morning :)
you very much.
Broad Telecom S.A. (BTESA) - Spain
Manuel Díaz-Regañón
phone: 913274363
e-mail: [EMAIL PROTECTED]
-Mensaje original-
De: Anselme [mailto:[EMAIL PROTECTED]
Enviado el: martes, 17 de junio de 2003 16:15
Para: [EMAIL PROTECTED]; Mysql_MailingList
Asunto: Re: Upgrading to 4.0
First could I apologize for joining a mailing list primarily to ask
for help. However I am not a professional Unix or MySQL manager and
am supporting an installation to allow Masters students in
Bioinformatics to do summer projects. Last year I managed to install
v. 3.23 of MySQL on a Sun box
Have You deleted or updated te my.cnf file?
It seems to me that MySql is looking in the wrong dir or it dosn't
have permision in data dir ( user mysql.mysql rw permission).
Santino
At 16:46 +0100 7-06-2003, David Leader wrote:
First could I apologize for joining a mailing list primarily to ask
I am running Mandrake Linux 8.2, with the RPMs upgraded to 9.0. It had MySQL
3.23 running on it.
I downloaded the current version of 4.0 from mysql.com tonight and isntalled
it. I changed the old files from /usr/share/mysql to /usr/share/mysql3.23
and /var/lib/mysql to /var/lib/mysql3.23
Hal Vaughan wrote:
I am running Mandrake Linux 8.2, with the RPMs upgraded to 9.0. It had MySQL
3.23 running on it.
I downloaded the current version of 4.0 from mysql.com tonight and isntalled
it. I changed the old files from /usr/share/mysql to /usr/share/mysql3.23
and /var/lib/mysql to
28 matches
Mail list logo