...@rdc.co.za
Cc: mysql mailing list mysql@lists.mysql.com
Subject: Re: MySQL upgrade from 5.0.51a to 5.1.53
Date: Tue, 30 Nov 2010 11:29:29 +0100
I suspect you need to have the new version running instead of the old
one, for the mysql_upgrade script to work.
On Tue, Nov 30, 2010 at 11:23 AM
HI Guys
I found some info regarding a method to upgrade mysql databases.
Currently the version is at mysql-5.0.51a (as installed via the
ubuntu-8.0.4 respository).
I downloaded the only version available from the web (5.1.53)
that will work on ubuntu [except for
I suspect you need to have the new version running instead of the old one,
for the mysql_upgrade script to work.
On Tue, Nov 30, 2010 at 11:23 AM, Machiel Richards machi...@rdc.co.zawrote:
HI Guys
I found some info regarding a method to upgrade mysql databases.
Currently the
vegiv...@tuxera.be
To: Machiel Richards machi...@rdc.co.za
Cc: mysql mailing list mysql@lists.mysql.com
Subject: Re: MySQL upgrade from 5.0.51a to 5.1.53
Date: Tue, 30 Nov 2010 11:29:29 +0100
I suspect you need to have the new version running instead of the old
one, for the mysql_upgrade script
earlier.
Regards
Machiel
-Original Message-
From: Johan De Meersman vegiv...@tuxera.be
To: Machiel Richards machi...@rdc.co.za
Cc: mysql mailing list mysql@lists.mysql.com
Subject: Re: MySQL upgrade from 5.0.51a to 5.1.53
Date: Tue, 30 Nov 2010 11:29:29 +0100
I suspect you need to have
Hi Guys,
Iam going to upgrade mysql version 4 to version 5.x on redhat ES4 . is
there any particular way to do that ? if i take a mysqldump of the database
and simply restore on to version 5 will work ? are there any differences
between syntaxes/db structure etc on those 2 versions ?
Thanks in
See:
http://dev.mysql.com/doc/refman/5.0/en/upgrade.html
-Original Message-
From: Tharanga Abeyseela [mailto:tharanga.abeyse...@gmail.com]
Sent: Wednesday, October 21, 2009 2:34 PM
To: mysql@lists.mysql.com
Subject: Mysql Upgrade from version 4 to 5
Hi Guys,
Iam going to upgrade mysql
Hi All, I've performed a upgrade from 4.1.22 to 5.0.81, the
mysql_upgrade performed well on all tables repairing, however, after
upgrade the same db from 5.0.81 to 5.1.33, a few tables got the error as
below:
Error: Unknown table engine 'InnoDB'
error: Corrupt
Any ideas?
THnaks.
--
kengheng wrote:
Hi All, I've performed a upgrade from 4.1.22 to 5.0.81, the
mysql_upgrade performed well on all tables repairing, however, after
upgrade the same db from 5.0.81 to 5.1.33, a few tables got the error
as below:
Error: Unknown table engine 'InnoDB'
error: Corrupt
Any
A DB politics between mysql oracle again
Thats quite ironic given recent events :)
--
Linux web infrastructure consulting, cr...@codenation.net
Free live poker tournament listings, http://www.g5poker.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hello
I ram yum update for mysql , mysql-server and mysql-devel in fedora core 2,
after this mysql is not starting.
===
Log Error message:
080715 22:55:58 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB
I upgraded my slave server a few weeks ago, and the slave failed, with
an error similar to the one shown below.
I rolled back my upgrade, and it started working again, so I forgot
about it.
Today, I upgraded the master (again, from 5.0.32 to 5.0.42) - and hte
slave failed again.
I thought
Ian P. Christian wrote:
I upgraded my slave server a few weeks ago, and the slave failed, with
an error similar to the one shown below.
I have figured out what happened here now - and I'm part of the way
though fixing it.
It turned out the defaults had changed somewhere, and rather then
Just to clarify - are you asking for suggestions regarding avoiding
re-seeding the slave or regarding what is likely to have gone wrong?
Generally, a newer slave can cope with an older master, but not the other
way around. If you updated the master while slave was out of date, you may
be out
Ian P. Christian [EMAIL PROTECTED] wrote:
In theory, I should be able to find out where the slave was up to in the
old logs, extract them manually and replay them on the slave, and then
reset the slave to use the new logs - however i'm not sure how reliable
that's going to be - or even how to
Ofer Inbar wrote:
Assuming your slave is not usable by client programs now anyway and
you don't mind it being unusable for a while longer, you can restart
the slaving from scratch:
This is exactly what I'm trying to avoid doing, it means 2 days downtime
whilst the data is re-inserted.
I have
On Tue, 12 Jun 2007, Ian P. Christian wrote:
Ian P. Christian wrote:
I upgraded my slave server a few weeks ago, and the slave failed, with
an error similar to the one shown below.
I have figured out what happened here now - and I'm part of the way
though fixing it.
It turned
Ian P. Christian wrote:
Ofer Inbar wrote:
Assuming your slave is not usable by client programs now anyway and
you don't mind it being unusable for a while longer, you can restart
the slaving from scratch:
This is exactly what I'm trying to avoid doing, it means 2 days downtime
whilst the data
: Friday, September 23, 2005 12:40 AM
Subject: MySQL upgrade from 3.x to 4.1 for Chinese databases
Dear all,
On my server there are thousands of database files contenting Chinese
records. The total data volumn is over 20GB. Is there an easy way to
upgrade the whole system from
, 2005 6:54 AM
Subject: Re: MySQL upgrade from 3.x to 4.1 for Chinese databases
YL wrote:
Did you tried just copy those 3.23 files into a newly installed 4.1 data
folder? What's happen?
Yes. I tried. The result is all Chinese words were turned into
unrecognized characters.
In my
Dear all,
On my server there are thousands of database files contenting Chinese
records. The total data volumn is over 20GB. Is there an easy way to
upgrade the whole system from MySQL 3.23.x to 4.1.x?
mysqldump is NOT a good way for me. It will be a hard and time costing
work. Is it
Dear all,
On my server there are thousands of database files contenting Chinese
records. The total data volumn is over 20GB. Is there an easy way to
upgrade the whole system from MySQL 3.23.x to 4.1.x?
mysqldump is NOT a good way for me. It will be a hard and time costing
work. Is it
system, I feel.
- Original Message -
From: Chenzhou Cui [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, September 23, 2005 12:40 AM
Subject: MySQL upgrade from 3.x to 4.1 for Chinese databases
Dear all,
On my server there are thousands of database files contenting Chinese
Hello.
The password hashing mechanism was updated in MySQL 4.1 to provide better
security and to reduce the risk of passwords being intercepted. Use
OLD_PASSWORD() instead of PASSWORD. See:
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
Jerry Swanson [EMAIL PROTECTED] wrote:
I upgraded mysql mysql-3.23.58-1 to mysql4.1
In mysql-3.23 ( I have this field)
password | varbinary(45) | YES | | NULL
|
I inserted data into this field as password('pass').
I have php script that checks if login valid. mysql-3.23 and
mysql-4.1 have identical
Jerry Swanson wrote:
I upgraded mysql mysql-3.23.58-1 to mysql4.1
In mysql-3.23 ( I have this field)
password | varbinary(45) | YES | | NULL
|
I inserted data into this field as password('pass').
I have php script that checks if login valid. mysql-3.23 and
Hi Jerry,
(B
(B
(BDid you read the documentation ?
(B
(BIt explains that you have to upgrade the mysql database wqith the
(Bmysql_fix_privileges script.
(B
(B
(BBest regards
(B
(BNils Valentin
(BTokyo / Japan
(B
(Bhttp://www.be-known-online.com
(B
(B
(B
(B I upgraded mysql
In the mysql documentation on upgrading on the mysql website it is
said that it's a better idea to upgrade on a step-by-step bases using
the direct-followup versions of MySQL every time and not to upgrade
jumping a couple versions (ex. from 3.22 to 4.0, skipping 3.23). I would
like to know
I have ben trying to install MySQL v4 for Linux on a machine that had a
previous v3 installed badly. I have removed all of the old v3 or so I
thought. When I try and put the new v4 on it says that it cannot do this as
there is still a v4 on the machine. What can I do to overide?
Michael Johnson
Hello,
we are currently running MySQL version 3.23.58, and plan to upgrade to 4.0.18
via the RPM's on a RH/Linux system,... can we retain all the user privileges and
databases without loosing any data and our user privileges after the upgrade...
we do have backups of all the databases.
Is
Mike Blezien [EMAIL PROTECTED] wrote:
Hello,
we are currently running MySQL version 3.23.58, and plan to upgrade to 4.0.18
via the RPM's on a RH/Linux system,... can we retain all the user privileges and
databases without loosing any data and our user privileges after the upgrade...
we
I've MySQL-3.23.54a-11 installed and running on RH 9.0 via the RedHat
rpm's. I'm trying to upgrade to MySQL-4.0.17-0 via rpm's from MySQL.com. I
found references from web searches and through the archives from this list
that suggest that it's as easy as:
shell rpm -Uvh --nodeps MySQL*
but
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 MSN 8. Get 2 months
hi all,
I was trying to upgrade mysql from 3.22.21 to 3.23.51 on my RaQ2 system.
after removing the older version when I trid to install this new version
(rpm pkgs) I got the follwoing error. anyone has any idea or can pelase
tell me what should I do at this point. thanks in advance.
rahad
hi,
I cant use some characters in my full text search (like * , , etc.)
I found out that it was due to the old version of the mysql i am using.
Now the problem is i want to switch from the older version(3.23.49) to 4.0.2
so that my full text search can be more efficient.
Can some one tell me
hi,
I cant use some characters in my full text search (like * , , etc.)
I found out that it was due to the old version of the mysql i am using.
Now the problem is i want to switch from the older version(3.23.49) to 4.0.2
so that my full text search can be more efficient.
Can some one tell me
Marek,
Friday, February 22, 2002, 7:11:06 PM, you wrote:
MW Hello all.
MW I'm using Debian 2.4.x
MW I was trying to upgrade mysql.3.22 to 23 by removing default packages and
MW after debianizeing rpm's with alien I installed them with dpkg.
MW After I did upgrade (as I assume ;-))) somewhere
Hello all.
I'm using Debian 2.4.x
I was trying to upgrade mysql.3.22 to 23 by removing default packages and
after debianizeing rpm's with alien I installed them with dpkg.
After I did upgrade (as I assume ;-))) somewhere my.cnf file disappeared
Do someone know how to properly upgrade 22 to 23
Hi,
I've just upgraded my MySQL from version 3.22.32 to 3.23.42 from source
(which was an extremely easy exercise might I add). Now I'm not sure
whether or not I should also recompile the php and Apache code...I've
read another posting which suggested this is a good idea to keep the
system
Hi,
I tried to upgrade a 3.22.32 source install of MySQL to the
latest 3.23 source from the MySQL Web site on my RedHat 6.1 box and
ended up breaking Apache and PHP (which were also compiled by source).
Being relatively new to Linux and having gotten it working
originally via
40 matches
Mail list logo
