MYSQL :: Upgrading MySQL On Windows/IIS- Help?

Upgrading Mysql To 4.1.7
I currently run mysql 3.23.58 on a Linux daffy.perf.redhat.com 2.4.18-11

I wanted to update to mysql 4.1.7 and was wondering how easy it? Is it worth it? What are the benifits. What will it do to my current queries that I have written. Most are simple SELECT statements with some INSERT Statements.

Lastly if I should upgrade, what is the best way to do it.

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
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.

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?

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.

MySQL On Windows
I downloaded and installed MySQL for Windows this morning, V4.1. =
Unzipped, installed and started the server as a service, no problems. =
Installed the ODBC driver. A-OK

But, the DOC tells me I have to run "mysql_install_db.sh". So, the =
question is, how am I supposed to run shell scripts on Windows?

Mysql 4.0.20a For Windows
i installed just a few days ago the new my sql 4.0.20a server on a Windows Machine

and heart about that the feature "auto_increment = default value" will work now

now i created a new table added some fields and one field shoud be auto_increment and shoud have a default value (which means, mysql shoud then auto_increment up from the given value), but this doesn't work

i can only choose between default value or auto_increment but not both any ideas ?

MySQL 4 And Windows XP
I am having problems running mysql 4 on windows xp. Mysql 3 works fine.
However version 4 won't run. Even if I start the server with the admin panel
it shuts down again after a couple of seconds. This has only been a problem
since I wiped my hard drive and did a clean install of everything.

MySQL 5.0 On Windows 98 SE
I just downloaded MySQL 5.0 and installed it on a machine that I just did a fresh install of Windows 98 Second Edition on.

The install seemed to go smoothly, and when it was done I try to start mysqld from the command line and get this:

C:Program FilesMySQLMySQL Server 5.0in>mysqld --console
051125 21:04:07 [ERROR] Can't find messagefile 'C:Program FilesMySQLMySQL Ser
ver 5.0shareenglisherrmsg.sys'
051125 21:04:07 [ERROR] Aborting

Also, when I look in the above referenced directory, the file errmsg.sys is there: Code:

Mysql On IIS Windows
I very new to mysql. I would like to get some advise on which release i should install in my windows 2000 server using IIS.

MYSQL In Windows XP Pro Sp2
i get a ERROR 0 when loading the program into my computer. and the servise could not be started, if i go into cmd and type "Net start MYSQL" it says sucsessfull

but when i go into Contrl panel > Administrtor tools > Servise's and click MYSQL it says "error 1067 could be be started"

Can I Use MySQL With A Mac And Windows
I need to share a MySQL database with a guy that uses a Mac, but I don't know anything about the Mac environment. I use WinXP. He has a server that has MySQL loaded on it. I want to create the database, then both of us want to be able to access it or make changes to it via the web.

What type of products do I need? I figure a good MySQL reference book is a necessity. Is there some type of front end application that he can run. I think I can run Access as a front end once it is set up properly. Am I making sense?

MySQL 4 And Windows XP
I am having problems running mysql 4 on windows xp. Mysql 3 works fine.
However version 4 won't run.

Even if I start the server with the admin panel
it shuts down again after a couple of seconds. This has only been a problem
since I wiped my hard drive and did a clean install of everything.

MySQL On Windows
when i try to install mysql on my pc it works just fine until i'm near the end of the installation, the installer writes:

the security settings could not be applied
error number 2003
can't connect to mysql server on 'localhost' (10061)

i have disable my firewall... so whats the problem then..? please make an easy explanation... i'm not that good at english so i hope that you understand me...