MYSQL :: Upgrading MySql

Upgrading To MySQL 4.0
Currently, I'm running 3.23.51 on Red Hat 7.1, and I'm contemplating
upgrading to MySQL 4.0, but I'm not sure what to expect. I don't know if
MySQL 4.0 is fully backwards-compatible with 3.23.x versions, or if
something is going to break if I upgrade.

What are the main advantages of upgrading to 4.0? Speed? Features? I can go
through the whole changelog if need be, but I'd prefer to hear what actual
users are reporting as far as benefits and disadvantages.

Upgrading Mysql To 4.0.24
I have just followed MYSQL reference manual 2.3.15 to upgrade mysql from 4.0.20 to 4.0.24. Everything appeared to upgrade correctly, but the version is still showing 4.0.20. I have searched everywhere for documentation that would point out my error, but have been unable to find the solution.

Upgrading MySQL
I recently upgraded my Mac (running OS 10.4.8) to Apache 2.0.52, MySQL
5.0.24 and PHP 4.3.9.

While I seem to be accessing the latest MySQL from the Terminal, Apache
seems to continue to use the previous install of MySQL.

Is there some config file I need to edit so the new install of MySQL is
used by my Web server?

While I'm at it, my PHP seems to no longer be able to send email, though
I added "sendmail_path = /usr/sbin/postfix" to the php.ini file.

Mysql Upgrading From 3.23 To 4.1
I have linux RH AS 3 server with these installations:

#rpm -qa | grep mysql
libdbi-dbd-mysql-0.6.5-5
mysql-3.23.58-1
mysql-devel-3.23.58-1

How can I upgrade to mysql 4.1 ? Should I try uninstalling the above first
with all their dependencies or should I do a FORCE upgrade over it ?

Upgrading From MySQL V3 To V4
I have MySQL datbase running on a Mac Powerbook with MySQL v4.1.14 installed (upgraded from v3).
I cannot get the syntax correct when trying to SELECT a record that meet a predefined criteria.

$query = "select * from members where member_ID = $ID and cat = type_ID";

I get the following error message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and cat = type_ID' at line 1

This SQL query works in phpMyAdmin (when I specify the 'member_ID' and 'cat' numners:
select * from members where member_ID =1 and cat = 5

It seems that the $ID and type_ID variables have no values when trying to execute the $query.

Upgrading MySQL From 4.0 To 5.0
I am running almost every 4.0 query/syntax possible, and I can not afford one query to be faulty because it's changed in 5.0.

Upgrading To MySQL 5.x
I wish to upgrade my version of MySQL (currently stuck to version 3.23) and I am wondering if to upgrade to the most stable 4.x or 5.x version. I am concerned about any possible retro-compatibility issue with SQL queries written for the 3.x version. In particular I am inquiring about:

1. Is there any incompatibility issue between the very latest stable 5.x version and SQL queries written for 3.x MySQL versions?

2. Is there any compatibility issue with PHP 4.x or PHP 5.x ?

Upgrading Mysql From 4.0 To 4.1
i'm trying to upgrade mysql from 4.0 to 4.1. mysql_fix_privilege_tables reporting 'Access denied' and man says to use root pass as argument. so how to use it? '$ mysql_fix_privilege_tables -ppass' doesn't work

Upgrading MySQL
I'm having a hard time figuring out how to upgrade to MySQL 4.1 on my FreeBSD server. I've been trying to use the ports, like I do whenever I upgrade all my other software. The install runs without any problems, but the MySQL binary (in usr/local/bin) is never replaced with the new version.
Does anyone have any advice on how to go about upgrading to 4.1 on a FreeBSD server. Am I missing something? Can you point me towards any good articles on how to go about doing this?

Upgrading To MySQL 4 Or 5
A person I am working wth is running My SQL 3.23.58. He needs to upgrade, so that we can use the UNION statement, among other things, but I was wonderting if it were better to upgrade to 4 or 5. By better, I mean working well with PHP 4.3.11, and Apache 2.0.51 on Linux.
I am asking because I know there are some issues with Windows, Apache 2, and PHP 5, and I want tomake this upgrade as smooth as possible.
It seems that most web hosts are using MySQL 4 currently, so I'm guessing that is the one I should go with? It appears, according to MySQL.com, that the stable version of MySQL 4 is 4.1.20. Please let me know if there are any issues that exist with this version of MySQL and the versions of PHP and Apache I mentioned above.
Also, can you upgrade smoothly without losing your database or data? I'm going to back it up just in case, but I'm just curious to know if you can upgrade without losing data, or if the database will absolutely need to be saved and re-uploaded.

Upgrading To Mysql 4.1
I have just upgraded to mysql 4.1...which is great...what isn't great is that it's not working. I keep getting an error message when I try to start it that it cannot find 'localhost'. My last version was 3.23 and I had no problems at all getting it to work.I've gone through the help file and changed the my.ini file and moved it to c:windows and checked everything but stil no joy...anyone had this problem and sorted it?
I'm running:

winxp
mysql 4.1
php 5.0
apache 2

Upgrading From MySQL 3.23 To 4.1 - Need To Upgrade To 4.0 First, But Can't...
I just realised that MySQL on my local server is MySQL 3.23....whoops.

I'm looking to go to 4.1 for the time being. However the manual says that in order to get there I should upgrade to 4.0 first, and then on to 4.1.

But the 4.0 download has been discontinued! So where do I go from here. A completely fresh install (not sure what effect inserting my 3.23 database SQL backup in the 4.1 database will have...nothing?)

or do I just upgrade to 4.1 straight?

Upgrading MySQL On Windows/IIS- Help?
I am running MysQL Version 3.23.49 on a Windows IIS machine. I need to upgrade it to at least 4.0.16 (to install vBulletin 3.6).

Is there a good tutorial on how to do this? I look at the documentation on the MySQL site but I'm hoping there is more out there to help me.

As well, the docs say instead of upgrading to V5 I should upgrade to V4 instead. I'd like to have the most up to date MySQL if I can so I won't have to do the another upgrade for a while.

Issue Since Upgrading MySQL From 4.x.x To 5.0.24
I am not sure where to begin with this, but basically my host server upgrade our MySQL version from 4.x.x to 5.x.x and since some of my scripts have changed the way in which data is drawn from the database.

It seems to be a division issue when dealing with averages it extracts the data from the database different than it has on all previous versions of MySQL and I hope someone here can help me in the direction in which to solve this.

Here are a few examples of the issue I am having....

Fedora C3 And Upgrading Mysql 3.23 To 4.1
How do I upgrade the standard version of mysql on FC3, 3.23, to 4.1 ? I already looked up some info on the internet, but it isn't quite clear to me.

I can backup my data, it isn't that much, just personal stuff. Do i just rpm the client and server, first 4.0 and then 4.1 or do I have to give special options with the rpm command ? Will this affect my webserver ? Do I have to adjust settings for apache or
PHP ?

Error Upgrading MySQL
I began preparations for upgrading MySQL. I downloaded the binary RPMs for
Red Hat Enterprise 4 (we're running CentOS, a clone) for MySQL 5.0.13 from the
MySQL AB web site. Running a test, I got this:

[root@seabass ~] rpm -hUv MySQL* --test
warning: MySQL-client-standard-5.0.13-0.rhel4.i386.rpm: V3 DSA signature: NOKEY,
key ID 5072e1f5
error: Failed dependencies:
libmysqlclient.so.14 is needed by (installed) mod_auth_mysql-2.6.1-2.2.i386
libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.6.i386
libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-2.EL4.1.i386
libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386

Has anyone else encountered this dependency problem? What would happen if I
--force'd RPM to do the upgrade?

Upgrading MySQL With RPMs
I'd like to upgrade to v 4.1 as painlessly as possible (mainly I want to avoid problems with the php-mysql RPM which requires the dynamic libraries that include 3.23.x libraries). Is there an easy way to upgrade my RPM install without breaking a lot of things?

Upgrading MySQL On Linux Server
I need to upgrade MySQL on my server. I've tried to find some tutorial, but Google found nothing interesting.

I wonder what is the easiest and most safe way to upgrade MySQL? I'd like to keep configuration (./configure params, configuration files etc) as is and to not hurt anything.

Issue When Upgrading MySQL From Version 4.1 To 5.0
I got the following message when I upgrade MySQL from 4.1 to 5.0, and unable to continue,?

[root@wl-jzarley ~]# rpm -i MySQL-server-community-5.0.45-0.rhel4.i386.rpm
warning: MySQL-server-community-5.0.45-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
MySQL conflicts with mysql-4.1.12-2.RHEL4.1.i386

Steps For Upgrading MySQL 4.1 To MySQL 5.x?
I desperately searched the web for a list of steps to be followed to upgrade existing MySQL 4.1 installation to MySQL 5.x. This is the first time I am performing a MySQL upgradation and I don't know how to upgrade without losing any of the current user/system data.

Can anyone pl. provide or direct me to a link that provides a step-by-step procedure to upgrade an existing MySQL 4.1 installation to MySQL 5.x?

Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client In
I have recently upgraded to MySQL 5. Got this error message in my IE Browser. Have read some of the comments on other forums and my choices are: Upgrade all client programs to use a 4.1.1 or newer client library, or

SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd')

Can someone please advise?

Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
Basically I am setting up php,mysql and apache to run an application. While trying to connect I get the following error:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:sudhirapachehtdocssvgmap est4.php on line 14
Cannot connect to the database.
Client does not support authentication protocol requested by server; consider upgrading MySQL client
I have tried the following message posted earlier by many of you guys i.e
"SET PASSWORD FOR peter@localhost = OLD_PASSWORD('something')
flush privileges

I am trying this from a long time and do not find a way to fix this problem
I request you guys to help me in soughting this out and I appreciate your patience in reading my post.

Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
I am having an awkward problem with my MySQL installation. I have a number of scripts that access the database from a few different web hosting sites. I have no problem accessing the database from the scripts that I host locally. The scripts that are on an outside server accessing the database gives me a mysql_connect() error.

Locally I use MySQL 5.0 and PHP 5.0. I am assuming that the 3rd party web host uses an older version of PHP and thinking that may be the problem. Is this the possible problem and if so is there a way to fix it without ruining the scripts that are currently working?

Upgrading MySQL 3.23 To MySQL 4.1
I use RHEL 2.1. It's old and so are the packages that goes with it. It does have MySQL 3.23 and I would like to upgrade it to a later version, 4.1 would be nice. But then MySQL website says one should use his/her distro's RPM. This is now a stalemate for me because there seems to be no MySQL 4.1 RPM for that distro. I did try using RHEL 3 RPM and I was stopped by GlibC 2.3 dependency. I only have Glibc 2.2. My belief is RHEL 2.1 could work MySQL 4.1. Just it's a puzzle for me how to do it.

Upgrading To 5 From 3.23
I am considering upgrading to MySQL 5 from version 3.23. My applications have no clients yet but expect them in a few weeks so now is a good time to upgrade.

I use some left joins, outer joins, inner joins but, of course, no sub-selects. I also use as column types; tinytext, text, date, char and varchar.

If I just do a data dump from 3.23 and load it to version 5, should it work?

What do I need to investigate, if anything, before upgrading?

Upgrading From 3.23.41 To 4.1
I'm currently running MySQL 3.23.41 and have been
happily doing so for a good while, but now I need to be able to run
subqueries and for this I need to upgrade to 4.1.

Can anyone help me out with a resource or how to on upgrading this the
right way so I don't screw anything up on my server?

Upgrading From 3x To 4x
We have a Fedora server located off site. The server is loaded with MySQL 3x and I need to upgrade to 4x. I'm not much of a linux admin (not at all actually). This server has a Plesk control panel so working with that is trivial but I don't know how to update MySQL.

Upgrading 4.0.20
I haven't upgraded my MySQL in absolutely years, and I need some of the newer features. What's the easiest way of upgrading without losing any data? Is it to just make a huge SQL dump of all the databases and restoring them like that afterwards, or is there a way I can simply compile a new version, dump it on top of the old one and keep the data files?

Upgrading To 5.0.2
I am running SLES 8.0 and I am running mysql 3.23.52. I want to upgrade to 5.0.2. Has anyone done this without going through the intervening levels? I know the recommendation is to go to the next level first.

Upgrading From 3.23.41 To 4.1
I'm currently running MySQL 3.23.41 and have been happily doing so for a good while, but now I need to be able to run subqueries and for this I need to upgrade to 4.1.

Can anyone help me out with a resource or how to on upgrading this the right way so I don't screw anything up on my server?

Upgrading
I currently have MySQL 4.0.18 on my web sever. I dont really care about the data that is there. do i still have to upgrade to 4.1 before upgrading to the current version?

Upgrading From 3.23 To 4.0.16
Few days ago I upgraded my MySQL 3.23.xx (can't remember those two
last, really) to 4.0.16. And then three problems came up (well, more
than two came up, but I solved all the others).

1. problem
I'm pretty sure I don't have any ISAM tables, but I'm not 100% sure.
How do I list types of all tables in ALL databases? SHOW TABLE STATUS
works only for curent database...

2. problem
$ mysqldump -A -uroot -ppassword > /dev/null
mysqldump: Can't get CREATE TABLE for table `forum_01posts` (Can't
open file: 'forum_01posts.MYI'. (errno: 145))

What's that???

3. problem
PHP returns this while trying to connect to MySQL server from machine
WHICH IS NOT LOCALHOST (when trying to connect from localhost,
everything's fine)

($link = mysql_connect($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASS) is line
3 in data_connect.php):

Warning: Lost connection to MySQL server during query in
/home/users2/nick/public_html/umzpa/data_connect.php on line 3

Warning: MySQL Connection Failed: Lost connection to MySQL server
during query in /home/users2/nick/public_html/umzpa/data_connect.php
on line 3

I tried to fix this by experimenting with GRANT command, but haven't
succeded. Before upgrading everything was fine. I haven't been
changing mysql.host table. What do I do?

Upgrading From 4.1.12 To 5.0.1
can i just install the new version of mysql, stop the
old, point the data directory for the new one to the data directory and
just start up mysql 5? or do i need to take some extra steps int eh
process. also is there any data corruption possible in the process i
described.

Upgrading
I'm upgrading a server I have to a 4.0 mysql version. I want to know if I can just move the raw 3.23 databases from one server to the 4.0x server and everything will work fine

Upgrading From 3.23.41 To 4.1
I'm currently running MySQL 3.23.41 and have been
happily doing so for a good while, but now I need to be able to run
subqueries and for this I need to upgrade to 4.1.
Can anyone help me out with a resource or how to on upgrading this the
right way so I don't screw anything up on my server?

Upgrading
I have an application which installs MySQL 3.23. It's hard-coded. I realize there are newer versions, so I am thinking, what's easiest:

1) install the application with its default 3.23 and then run a script to convert 3.23 to 4.1 or later,
or
2) modify the application to install a newer version of MySQL from the start.

Upgrading
i have verion 4.0.25 and i want to upgrade to 4.1.15...
How do i do this i have read the manual with no luck. i seaches google for 30 minutes with no luck at all. is there a strait forward manual on how to do this? BTW im running fedora as my os

Upgrading 4.0.25 To 4.1.16 Or 5.0
I've just been given admin rights to a production server running 4.0.25 and need to upgrade this to 4.1.16 or 5.0. The tools I am looking for are in 4.1.16, but would not mind going ot 5.0.The most important issue, being that I just got access to the system, is that I do not screw anything up when I upgrade.My Question; What is the lowest risk upgrade: 4.1.16 or 5.0?What are the exact steps I should take to accomplish the upgrade and not lose any data.

Should I Fear Upgrading From 4.0.27 To 4.1?
Are there any reasons that I should not upgrade from 4.0.27 to 4.1? (on a Linux server)

For instance, any known issues regarding existing PHP code getting broken, or character encoding issues, SQL backwards compatibility, and so forth.

I will do a backup first as something can always go wrong, but I have many dozens of sites on the server in question, and if there are any problems caused by the upgrade I might not even find out about them.

Are there any known issues that I should be aware of, or any reasons to decide against upgrading?

Please Help Newbie Upgrading From 4.1.11 To 5.0.x
I'm almost in tears here, am having a lot of trouble with the MySQL upgrade from 4.1.11 to 5.0.x. I have read Chapter 2 of the manual. I've read it more times than I care to admit. I've done Google searches. I've searched this forum as well as the usenet group. I'm stuck and I need to get this upgrade done. I must be the most stupid human on the face of the planet but I don't think the manual is very clear when it comes to explaining how to do the upgrade. Please take pity on me and help if you can, I'll be EXTREMELY grateful!

My environment: Linux RHE 3, the MySQL 4.1.11 is a non-RPM installation. The software is not installed under the default directory, it's in /opt/mysql/tst/4.1.11. I have many databases and many user accounts all password-protected.

Here is what I tried:

1. dumped all databases, including mysql.
2. make a backup of the whole 4.1.11 (MySQL softare) directory. Shutdown mysql 4.1.11.
3. can't tell exactly from the manual where the new software is supposed to go (is it supposed to overwrite the existing installation?). So I extracted the mysql-...tar.gz file into the /opt/mysql/tst directory. It created its own directory structure called "mysql-5.0.51a-linux-i686-glibc23".
4. I renamed the "mysql-5.0.51a-linux-i686-glibc23" directory to "5.0".
5. tried to start w/ bin/mysql_safe & and the server started and then stopped immediately.
6. Couldn't figure out what else to do and am running on the assumption that the "upgrade" is really just an "install" so I followed the installation instructions that say to run the mysql_install_db script.
7. Now I can start mysql_safe, hooray. I logged in with root, no password required.
8. I ran the mysql.sql file (the script produced when I dumped mysql out of 4.1.11) assuming this would put all the user accounts & passwords back into the new 5.0 version.
9. Logged into mysql using root and still not required to enter a password. However, am pleased to find the user accounts are in the database.

What am I doing wrong? How do I install the new version of MySQL so that the user account information is preserved?

Upgrading From Old_password()
Here's the situation. I used to run and old MySQL server (version 3) and I've upgraded to version 4 (shocking isn't it?). Well, I'm told it's version 4. The big issue is I have a whole bunch of user accounts with passwords generated by old_password. Is there some seamless way to upgrade the users passwords without having to get them to physically enter new ones?

I was thinking of using the new password() or md5() functions. I don't know what the user passwords are, obviously I just have the hashes. Is there a way for me to reverse engineer the old passwords and reencrypt them with new ones or some way of just telling the MySQL server - these are the passwords, upgrade them!?!

I've thought about simply using md5() or password() on the hash of the old password and using them like that but it's not really what I want.

Upgrading 3.23->4.0 Under WinXP ?
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 I run this on my WinXP system? What else do I need to do?

Is it DOs, should it run from within SQl?

Upgrading To A New Update
I often download a new dot version (e.g. 5.1.10 to 5.1.11), There seems to be no instruction on how to do the upgrade. Does one just DClick it and let it do its thing in Windows?

I am going to update both MySQLQuery browser and Admin.

Pitfalls For Upgrading
My ISP has offered to upgrade my servers from 3.23 to 4.1.
I'm excited by the potential gains in performance, and the ability to
write subqueries, but am wary of any forward incompatibilities. I have
a mass of PHP code with MySQL throughout. I don't relish peeking into
every file and making a determination of 'it should work' by eyeballs
alone.
What do I need to watch out for? Or where can I find a nice summary of
differences between the versions?

Upgrading From 4.1 To 5.0 Killed My Query
This is search by zipcode query. It used to work on MySQL 4 and now gets the error " Unknown column 'location_zip' in 'on clause' ". We have a huge list of zipcodes with their latitude/longitude and uses the great circle equation to get all the zipcodes within the range selected. Then, this second query searches for all locations that have a zipcode that matches. Typically we get back about 30 zipcodes, but I slimmed it down for this example.

SELECT *,
latitude, longitude,
ROUND(SQRT((POW((69.1*(longitude-'-117.156479')*cos(32.71571/57.3)),ƈ')+POW((69.1*(latitude-ཛྷ.71571')),ƈ'))), 1) as distance
FROM locations as t1, members as t2
LEFT JOIN zipcodes as t3
ON ( LPAD(t3.zip, 5, Ɔ') = SUBSTR(location_zip, 1, 5) )
WHERE t1.location_member = t2.member_id
AND location_zip IN (?',?',?')
AND member_status = Ƈ'
AND member_type = Ƈ'
AND member_expiration > CURDATE()
ORDER BY member_accredited DESC, member_type, distance, member_name

Upgrading From 4.1 To 5.0 Breaks Things?
I am in an environment that has a bunch of unrelated mysql databases that exist on one server. I would like to upgrade to mysql 5.0 to take advantage of the newer features, but I don't want to break functionality. I checked out http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html , but I was wondering if anyone out there has done some real-world upgrading and discovered that it breaks compatability with commonly known products that use mysql, such as phpbb or wordpress or something like that.

Upgrading MySql

I have MySql installed on Win2k Pro. Recently I downloaded the latest version of MySql, wanted to upgrade the previous alpha version. So any one here can help me guide to upgrade MySql, step by step, so that I do not loose any of my current MySql settings and databases.

I have MySql installed on Win2k Pro. Recently I downloaded the latest version of MySql, wanted to upgrade the previous alpha version.

So any one here can help me guide to upgrade MySql, step by step, so that I do not loose any of my current MySql settings and databases.