RE: Upgrading MySQL erased all data

2004-11-02 Thread Steven Roussey
Thanks. I passed this on and he found what was lost. I guess since the data directory was owned by mysql, he could not find the databases when doing a MacOS file search. I impressed upon him to use a separate datadir as we do with our servers, thus bypassing this whole thing. Thanks again!

Re: Upgrading MySQL erased all data

2004-10-29 Thread Santino
Are you sure? /usr/local/mysql is a symbolic link to another direcory ( /usr/local/mysql(version). I think the installer overwrite the symbolic link so if you open a terminal and type: ls -l /usr/local Santino At 16:20 -0700 28-10-2004, Steven Roussey wrote: Installing MySQL 4.1.7 (upgrading

Re: Upgrading MySQL erased all data

2004-10-28 Thread Rhino
So, do you have a question or are you just bragging? ;-) Rhino - Original Message - From: Steven Roussey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 28, 2004 7:20 PM Subject: Upgrading MySQL erased all data Installing MySQL 4.1.7 (upgrading from 4.1.3) on MacOS X

Re: Upgrading MySQL. Caveats or Cautions anyone?

2004-09-24 Thread Egor Egorov
Tim Johnson [EMAIL PROTECTED] wrote: The simpliest way: Download and install MySQL Official Binary RPMs from www.mysql.com. They will install on your server and run fine. You'd also want to install the shared-compat RPM in case you have something compiled with older libmysqlclient. The link

RE: Upgrading MySQL. Caveats or Cautions anyone?

2004-09-24 Thread Michael McTernan
Hi, I found that the Intel C++ version needed some libraries which weren't on my RH9.0 system (this was when upgrading to 4.1.4g): libcprts.so.5 libcxa.so.5 libunwind.so.5 This seems to have been reported many times e.g. http://bugs.mysql.com/bug.php?id=4408 The resolve was to get the

Re: Upgrading MySQL. Caveats or Cautions anyone?

2004-09-17 Thread Eric Bergen
You can ignore both of those if you use the binaries. -Eric On Fri, 17 Sep 2004 18:43:02 -0800, Tim Johnson [EMAIL PROTECTED] wrote: Hello: Am currently using Ver 11.18 Distrib 3.23.58 on Linux 2.4.20-20.9. (RH 9.0). I'd like to upgrade to the current version. I would like to know

Re: Upgrading Mysql and Perl DBD

2004-08-16 Thread Michael Stassen
This is covered in the manual http://dev.mysql.com/doc/mysql/en/Password_hashing.html: A 4.1 client can connect to a pre-4.1 server, because the client understands both the old and new password hashing mechanisms. So, if you build the Perl modules against the 4.1.x library, you should be able

Re: Upgrading mySQL 3.23 to 4.0

2004-08-03 Thread GH - CF
Can you give me a bit more detailed instructions on what i am uninstalling and what I should back up? Thanks Wolfgang Riedel wrote: [EMAIL PROTECTED] schrieb: I am trying to upgrade to the new version of mySQL on Fedora Core 2 Linux. I have mysql Ver 11.18 Distrib 3.23.58, for

Re: Upgrading mySQL 3.23 to 4.0

2004-08-02 Thread Japheth Cleaver
At 01:58 PM 8/2/2004, [EMAIL PROTECTED] wrote: Greetings: I am trying to upgrade to the new version of mySQL on Fedora Core 2 Linux. I have mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386) I downloaded the following files: MySQL-client-4.0.20-0.i386.rpm

Re: Upgrading mySQL 3.23 to 4.0

2004-08-02 Thread environmentalny
]# Does this mean success? Also, what does this line mean? 040802 17:21:17 Warning: Asked for 196608 thread stack, but got 126976 Thanks for the help - Original Message - From: Japheth Cleaver [EMAIL PROTECTED] Date: Monday, August 2, 2004 5:12 pm Subject: Re

Re: Upgrading mySQL 3.23 to 4.0

2004-08-02 Thread environmentalny
, August 2, 2004 5:26 pm Subject: Re: Upgrading mySQL 3.23 to 4.0 I wound up having to do the following: [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-shared-compat-4.0.20- 0.i386.rpm warning: MySQL-shared-compat-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing

Re: Upgrading mySQL 3.23 to 4.0

2004-08-02 Thread environmentalny
in my Linux Services... the mysqld entry is missing i have mysql and that is supposedly running. - Original Message - From: Carlos Proal [EMAIL PROTECTED] Date: Monday, August 2, 2004 6:19 pm Subject: Re: Upgrading mySQL 3.23 to 4.0 The upgrade shutdown the database, i think you must

Re: Upgrading mySQL 3.23 to 4.0

2004-08-02 Thread Carlos Proal
PROTECTED], [EMAIL PROTECTED] Subject: Re: Upgrading mySQL 3.23 to 4.0 Date: Mon, 02 Aug 2004 18:26:05 -0400 in my Linux Services... the mysqld entry is missing i have mysql and that is supposedly running. - Original Message - From: Carlos Proal [EMAIL PROTECTED] Date: Monday, August 2, 2004 6:19

Re: Upgrading mySQL 3.23 to 4.0

2004-08-02 Thread Batara Kesuma
On Mon, 02 Aug 2004 17:31:03 -0400 [EMAIL PROTECTED] wrote: I am now getting [EMAIL PROTECTED] Desktop]# mysql -u root -pmypasshere ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) any thoughts... once again thanks for the assistance It

Re: upgrading a server to latest MySQL

2004-05-13 Thread Mihail Manolov
Piece of cake :) http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html I've recently upgraded our servers from 3.23.57 to 4.0.18. No problems at all. Luck! - Original Message - From: Joe Harkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 13, 2004 2:23 PM Subject:

Re: Upgrading from 3.23 to 4.0 Problem

2004-02-19 Thread Simon Green
I think that fastest way to get round this (mite be wrong) is to use the binary. Then all you need to do is change the sym link! This is a bit of a work round but should work? Simon - Original Message - From: Ross O [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 19,

RE: Upgrading help please

2003-11-06 Thread Andrew Rothwell
Yup that worked - I rebooted my machine - and I was allowed in - Thank you very much Andrew -Original Message- From: Brian Snyder [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 3:30 PM Cc: MySQL Subject: Re: Upgrading help please Andrew, I had the same problem and had

Re: Upgrading help please

2003-11-05 Thread Brian Snyder
Andrew, I had the same problem and had to stop and restart the servers. Give that a shot. brian On Wed, 2003-11-05 at 17:19, Andrew wrote: Good day List, I have just upgraded from 3.23 -4.0.16 I downloaded all the RPM's and then ran rpm -U *.rpm It did all that it was supposed to do,

Re: upgrading

2003-10-30 Thread gerald_clark
man rpm Robert Morgan wrote: Hi, a while ago I upgraded from version 3.23.54 to 4.0.16 I downloaded the rpm's to usr/src/rpm I can't remember the syntax to install all the rpm's it was something like ' U rpm ' any help appreciated I have to write this up so best I get it right. Thanks Bob

Re: upgrading

2003-10-30 Thread William IT
to upgrade: rpm -U rpm_package_name but you must read mysql upgrading topic in mysql manual reference to avoid any problem. - Original Message - From: Robert Morgan [EMAIL PROTECTED] To: mysqllist [EMAIL PROTECTED] Sent: Friday, October 31, 2003 5:45 AM Subject: upgrading Hi, a while

Re: Upgrading 3.23-4.0 under WinXP ?

2003-08-25 Thread Matt W
- 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 in

Re: Upgrading to MySQL 4

2003-07-22 Thread Wendell Dingus
Quoting Jackson Miller [EMAIL PROTECTED]: I need to migrate a 3.23.52 MySQL server to a version with InnoDB (and row level locking). The catch is, I need to do it in a hurry (by the end of the week). It is a production system with over 300 users. Some tables have over 2,000,000 rows.

Re: Upgrading MySQL on RedHat 9

2003-07-03 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 2 Jul 2003, Paul DuBois wrote: At 11:33 -0400 7/2/03, Andrew Pierce wrote: I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to go from the version that came with the distro (version 3.23.54) to the latest

Re: Upgrading MySQL on RedHat 9

2003-07-02 Thread Paul DuBois
At 11:33 -0400 7/2/03, Andrew Pierce wrote: I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to go from the version that came with the distro (version 3.23.54) to the latest (verion 4.0). Just thought I'd post to get a heads-up on any known issues or prerequisites. I just hate

Re: upgrading

2003-06-18 Thread Jerry
High priority message ? Then you should read the manual. http://www.mysql.com/doc/en/Upgrade.html - Original Message - From: MOSSANO [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 9:43 AM Subject: upgrading I want to upgrade from 3.23 to 4.0 version. Could

Re: Upgrading to 4.0

2003-06-17 Thread Anselme
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 :)

RE: Upgrading to 4.0

2003-06-17 Thread Manuel Diaz-Regañón
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

Re: upgrading, tuning and performance

2003-06-16 Thread Nils Valentin
Hi Andy, You have many questions, most I cant answer,but upgradng from 3.23-xx to 4.xx will definitely give you a performance boost. I am running on siple boxes ( no replication etc.). So I am unable to say how much speed , but I strong believe that it will be enough to be realised

Re: upgrading, tuning and performance

2003-06-16 Thread walt
Andy Stubbs wrote: Hi, long time listener, first time caller (I think), I've got a database which I'm looking to increase performance, either by buying bigger kit or by somehow optimising current configuration. I'm running MySQL-Max-3.23.56-1 from the mysql.com RPMs on a Dell Poweredge

Re: upgrading, tuning and performance

2003-06-16 Thread Andy Stubbs
Disks are currently 36GB 10kRPM SCSI ultra3 with hardware RAID (PERC 3/DI onboard with 128MB cache) iostat for the DB disk partition is: avg-cpu: %user %nice%sys %idle 8.620.034.62 86.73 Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s

Re: Upgrading to 4.0 on Solaris

2003-06-07 Thread Santino
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

Re: upgrading to v 4.1

2003-05-31 Thread LS
4.8-STABLE and linuxthreads-2.2.3_10 and gcc3.2 It's easy for me to reproduce this bug on my system, but I don't know if I could come up with a simple test case for someone to play with. Do you compile with the BUILT_OPTIMIZED flag? --- Jeremy Zawodny [EMAIL PROTECTED] wrote: On Wed, May

Re: upgrading to v 4.1

2003-05-29 Thread Scott Haneda
on 05/28/2003 1:51 PM, Ted Rogers at [EMAIL PROTECTED] wrote: Is it recommended that I upgrade MySQL 3.23.53 to 4.1.x? Are then any special notes I might remember when doing so? (Mac OS X Server 10.2.6) Ted Yeah, I posted this and no reply, but you need to do this Subject :

RE: upgrading to v 4.1

2003-05-29 Thread Daevid Vincent
- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 1:59 PM To: MySql Subject: Re: upgrading to v 4.1 on 05/28/2003 1:51 PM, Ted Rogers at [EMAIL PROTECTED] wrote: Is it recommended that I upgrade MySQL 3.23.53 to 4.1.x? Are then any special notes I might

RE: upgrading to v 4.1

2003-05-29 Thread Kieran Kelleher
Ted, 4.1 is not in production release yet. So, for home development to test or develop for new features specific to 4.1, then OK. If your database server is for production use serving critical data, then use 4.0.13 which is the current production release. Follow the instructions carefully

Re: upgrading to v 4.1

2003-05-29 Thread LS
I don't know about Mac OS X, but I can tell you that with 4.1 on FreeBSD w/LinuxThreads, my application's query threads get hung up almost instantly, requiring a kill -9. When I back down to 4.0.13 (and 3.23), I don't see that particular problem anymore. So keep an eye out for how it behaves for

Re: upgrading to v 4.1

2003-05-29 Thread Jocelyn Fournier
PROTECTED] Sent: Thursday, May 29, 2003 12:42 AM Subject: Re: upgrading to v 4.1 I don't know about Mac OS X, but I can tell you that with 4.1 on FreeBSD w/LinuxThreads, my application's query threads get hung up almost instantly, requiring a kill -9. When I back down to 4.0.13 (and 3.23), I

Re: upgrading to v 4.1

2003-05-29 Thread LS
, I'm experiencing the same problem here with Linux. Regards, Jocelyn - Original Message - From: LS [EMAIL PROTECTED] To: Ted Rogers [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 29, 2003 12:42 AM Subject: Re: upgrading to v 4.1 I don't know about Mac OS X, but I

Re: upgrading to v 4.1

2003-05-29 Thread Jeremy Zawodny
On Wed, May 28, 2003 at 03:42:24PM -0700, LS wrote: I don't know about Mac OS X, but I can tell you that with 4.1 on FreeBSD w/LinuxThreads, my application's query threads get hung up almost instantly, requiring a kill -9. When I back down to 4.0.13 (and 3.23), I don't see that particular

Re: Upgrading from 3.23.5x to 4.0.12 version 4 show no tables in any database

2003-04-01 Thread gerald_clark
Add your database directory to your my.cnf file. They were possibly compiled with diferent default database locations. [EMAIL PROTECTED] wrote: Description: I have upgraded from 3.23.5x versions to 4.0.12 on Linux Redhat operating system. On 3 machines I only upgraded the RPMs

RE: Upgrading from 3.23.5x to 4.0.12 version 4 show no tables in any database

2003-04-01 Thread Marko Hrastovec
on other four computers which have all RedHat Linux installed. Regards Marko -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 4:26 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Upgrading from 3.23.5x to 4.0.12 version 4 show

Re: upgrading

2003-03-31 Thread gerald_clark
Joseph Bannon wrote: I'm upgrading from 3.23.53 to 4.0.12 and noticed that 4.0.12 wants to pull data files from /var/lib/mysql. I set the prefix to be /home/mysql4, so why is it wanting to get the data from this new location? When I installed 3.23.53, I set the prefix as /home/mysql3 and it

RE: upgrading mysql

2003-03-21 Thread Tab Alleman
[EMAIL PROTECTED] wrote: Can someone help point me in the right direction? Thanks I just finished a practice upgrade (on a back-up server) myself and will be upgrading the real server during off-peak hours soon. We are running win2k servers so I can't speak directly to any linux issues, but

RE: upgrading mysql

2003-03-21 Thread Jennifer Goodie
upgrades. Our builds were really unstable and buggy under a high load, but the binaries have been great. Hope that helps -Original Message- From: Tab Alleman [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 2:14 PM To: [EMAIL PROTECTED] Subject: RE: upgrading mysql [EMAIL PROTECTED

RE: upgrading mysql

2003-03-21 Thread [EMAIL PROTECTED]
really unstable and buggy under a high load, but the binaries have been great. Hope that helps -Original Message- From: Tab Alleman [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 2:14 PM To: [EMAIL PROTECTED] Subject: RE: upgrading mysql [EMAIL PROTECTED] wrote

RE: upgrading mysql

2003-03-21 Thread Jeff Shapiro
] Sent: Friday, March 21, 2003 2:14 PM To: [EMAIL PROTECTED] Subject: RE: upgrading mysql [EMAIL PROTECTED] wrote: Can someone help point me in the right direction? Thanks I just finished a practice upgrade (on a back-up server) myself and will be upgrading the real server during off-peak

Re: Upgrading from 3.22

2003-03-16 Thread CrusaderSol
We are wanting to upgrade to MYSQL 3.23 on a Linux system. Is there an upgrade from 3.22 to 3.23 or do I simply install 3.23 in the same directory where 3.22 was? Any help would be appreciated. - Before posting, please

Re: Upgrading from 3.22

2003-03-16 Thread Paul DuBois
At 22:33 -0500 3/16/03, [EMAIL PROTECTED] wrote: We are wanting to upgrade to MYSQL 3.23 on a Linux system. Is there an upgrade from 3.22 to 3.23 or do I simply install 3.23 in the same directory where 3.22 was? Any help would be appreciated. You can do that, though of course you should make a

Re: Upgrading Red Hat rpms

2003-01-21 Thread Nuño Iglesias
EL día Mon, 20 Jan 2003 16:22:55 -0500 Walter [EMAIL PROTECTED] escribió: --I have a Red Hat 7.3 box running MySQL 3.23.49 (installed with the Red Hat --rpms). I am about to upgrade to 4.0.9 and would prefer using the RPMs from --MySQL. My plan was to just un-install the Red Hat rpms and

Re: Upgrading to version 4.

2003-01-13 Thread Stefan Hinz, iConnect \(Berlin\)
Maximo, My company's website is running version 3.23.53a, and the main client that uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in PHP? Although this manual entry is talking about the C API functions, I assume PHP uses these to communicated with MySQL. Perhaps I might be

Re: Upgrading to version 4.

2003-01-13 Thread Paul DuBois
At 23:45 +0100 1/13/03, Stefan Hinz, iConnect (Berlin) wrote: Maximo, My company's website is running version 3.23.53a, and the main client that uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in PHP? Although this manual entry is talking about the C API functions, I

Re: Upgrading to version 4.

2003-01-13 Thread Zak Greant
On Mon, Jan 13, 2003 at 03:45:59PM -0300, Maximo Migliari wrote: In the MySQL manual, under http://www.mysql.com/doc/en/Upgrading-from-3.23.html it says: --- The old C API functions mysql_drop_db, mysql_create_db, and mysql_connect are not supported anymore, unless you compile

Re: Upgrading from MySQL 3.23.52 to 3.23.54

2003-01-06 Thread Christian Kohlschuetter
Am Montag, 6. Januar 2003 04:45 schrieb Peter Teo: Good day, I have read on http://www.mysql.com about the press releases asking all 3.23 users to upgrade to the latest stable version. How can I do this without uninstalling my current version? I tried to look for some documentation

RE: Upgrading from MySQL 3.23.52 to 3.23.54

2003-01-05 Thread Anton Zavrin
I don't' know if it was right to do, but I just downloaded version 3.23.54a and compiled/installed it Best Regards, Anton -Original Message- From: Peter Teo [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 05, 2003 8:08 PM To: [EMAIL PROTECTED] Subject: Upgrading from MySQL 3.23.52 to

Re: Upgrading from MySQL 3.23.52 to 3.23.54

2003-01-05 Thread Mark
- Original Message - From: Peter Teo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 06, 2003 5:08 AM Subject: Upgrading from MySQL 3.23.52 to 3.23.54 Good day, I have read on http://www.mysql.com about the press releases asking all 3.23 users to upgrade to the latest

Re: Upgrading MySQL/Solaris 2.7

2002-12-17 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 17 Dec 2002, John P wrote: I want to upgrade my MySQL version (3.23.51) because of the recently revealed exploit; the only binary dist on mysql.com for solaris 2.7 is 3.23.53; will there be a problem compiling from source on this platform

RE: Upgrading MySQL from 3.23.41 to 3.23.53a

2002-11-13 Thread Black, Kelly W [PCS]
You might need to use rpm -e to uninstall previous version first. Check the documentation. ~Kelly W. Black -Original Message- From: Rick Root [mailto:rroot;wakeinternet.com] Sent: Wednesday, November 13, 2002 10:47 AM To: mysql Subject: Upgrading MySQL from 3.23.41 to 3.23.53a I

Re: Upgrading MySQL from 3.23.41 to 3.23.53a

2002-11-13 Thread Lars Andersson
At 13:47 2002-11-13 -0500, Rick Root wrote: [root@frodo MySQL]# rpm --install MySQL-3.23.53a-1.i386.rpm error: failed dependencies: MySQL conflicts with mysql-3.23.41-1 MySQL-server conflicts with mysql-server-3.23.41-1 [root@frodo MySQL]# rpm -U MySQL-3.23.53a-1.i386.rpm error:

RE: Upgrading

2002-09-09 Thread Nicholas Stuart
Hello Richard, I just went through something similar with upgrading from 3.23.49 to 4.03. The reason you can't connect to MySQL is 020908 15:53:33 mysqld ended This should obviously not be here. Check the error logs to see if they say anything important and/or helpful there. Most likely found

Re: Upgrading

2002-09-09 Thread Gerald Clark
at this one :-) Richard -Original Message- From: Nicholas Stuart [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 5:48 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Upgrading Hello Richard, I just went through something similar with upgrading from 3.23.49

RE: Upgrading

2002-09-08 Thread Richard W. Berriman
Update: Now, after rebooting the server, the site can't connect...that's more like it ;) -Original Message- From: Richard W. Berriman [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 08, 2002 4:43 PM To: [EMAIL PROTECTED] Subject: Upgrading Hi! I have a number of tables in

Re: upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103

2002-09-03 Thread Miguel Angel Solórzano
At 08:41 03/09/02 +0100, Chuck Amadi wrote: Hi, Well Well Well , I proceeded in upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103 Shutdown the current installed server or install 4.0.X on another directory. Component Servers File Group: File: Thus i unzipped

Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51

2002-08-13 Thread Dan Nelson
In the last episode (Aug 13), Don said: Due to some recent headaches I have decided to come out of the dark ages and upgrade from MySQL 3.21.33 to MySQL 3.23.51. I was wondering if anyone had any upgrade tips and/or precautions to recommend before I start. Definitely read the mysql manual

Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51

2002-08-13 Thread Dan Nelson
In the last episode (Aug 13), Don said: Thanks for the links to the manual. I still have a couple more specific questions... Should I use a source or binary install? Whichever you used to install 3.21 would be preferable. That way they install in the same place. Can I simply stop

Re: upgrading php for mysql support

2002-06-04 Thread Benjamin Pflugmann
Hi. This is a PHP and not a MySQL issue and therefore off-topic here. Please fine some appropriate PHP forum to ask. Bye, Benjamin. PS: The PHP READMEs contain the procedures to follow. On Tue 2002-06-04 at 02:56:25 -0700, [EMAIL PROTECTED] wrote: Could anyone help me

Re: Upgrading mysql from 3.22 to 3.23

2002-03-18 Thread Arjen Lentz
Hi, On Tue, 2002-03-19 at 11:41, Campbell McLeay wrote: I wish to upgrade mysql server from 3.22 to 3.23 running on Linux and had a few basic questions which I am hoping someone can help me with. My plan is simply to download and unpack the binary distribution, stop mysqld, move the symlink

Re: upgrading mysql-3.23.48 and rpm package.

2002-02-13 Thread Dr. Michael Wittmann
hi, on redhat 6.2, you have a package manager (rpm) version which cannot interpret rpm's created with package manager version 4. afaik, rpm 3.0.6 is able to read both formats, so you should upgrade your package manager software to version 3.0.6 to be able to install the new mysql package. don't

Re: upgrading mysql-3.23.48 and rpm package.

2002-02-13 Thread Egor Egorov
Ireneusz, Tuesday, February 12, 2002, 11:46:40 AM, you wrote: IP HI. IP No i get twice the .rpm of mysql-3.23.48. It is'nt corrupted. IP I could'nt install it. IP I have rpm 3.0.4. on my RH 6.2 (Zoot) box. IP Is there on the NET, rpm package of mysql-3.23.48, which can i install with IP rpm

Re: upgrading mysql-3.23.48 and rpm package.

2002-02-12 Thread Ireneusz Piasecki
HI. No i get twice the .rpm of mysql-3.23.48. It is'nt corrupted. I could'nt install it. I have rpm 3.0.4. on my RH 6.2 (Zoot) box. Is there on the NET, rpm package of mysql-3.23.48, which can i install with rpm 3.0.4 ? - Original Message - From: Egor Egorov [EMAIL PROTECTED] To:

Re: Upgrading from MySQL to MySQL max on a production server

2001-12-11 Thread JW
At 08:27 AM 12/11/2001 +0200, you wrote: Hi! I do not understand how replacing just the executable mysqld can make your 'mysql start' (or is it 'mysql.server start'?) script or safe_mysqld script to search the executable from a different directory than it did before. I do not understand it

Re: Upgrading from MySQL to MySQL max on a production server

2001-12-10 Thread Heikki Tuuri
Hi! I do not understand how replacing just the executable mysqld can make your 'mysql start' (or is it 'mysql.server start'?) script or safe_mysqld script to search the executable from a different directory than it did before. Are you sure you did not change anything else in the system? Anyway,

Re: Upgrading to MyISAM table type

2001-10-30 Thread Rich Duzenbury
I don't believe that the table is corrupt, I'm more inclined to believe your zero theory. create table crashme (a int(10) not null auto_increment primary key) type=isam; insert into crashme set a=0; # actually inserts a = 1; update crashme set a=0 where a = 1; insert into crashme set a=0; #

Re: Upgrading

2001-08-15 Thread Grigory Bakunov
Date |Wed, 15 Aug 2001 03:26:55 -0700 From |Ralf R. Kotowski [EMAIL PROTECTED] Hello! RRK Hi, RRK I'm currently runnig RH 6.2 and I'm considering upgrading to RH7.1 RRK I'm planning on whiping the HD's completely and start from scratch RRK and then install the latest RPM's from MySQL's site.

Re: Upgrading

2001-08-15 Thread Jon Cheng
flaws/risks/incorrectness involved as opposed to dumping? Thanks, -Jon - Original Message - From: Grigory Bakunov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 15, 2001 5:47 AM Subject: Re: Upgrading Date |Wed, 15 Aug 2001 03:26:55 -0700 From |Ralf

RE: Upgrading

2001-08-15 Thread Simon Green
: 15 August 2001 11:43 To: [EMAIL PROTECTED] Subject: Re: Upgrading I am also in a similar upgrade situation, but I was thinking that all we need to do to TRANSFER a db is just zip up the db files *.MYD, *.MYI, and *.frm? This method worked for me transporting my db's from one mysql server

Re: Upgrading

2001-08-15 Thread Irmund Thum
Am Mittwoch, 15. August 2001 12:26 schrieb Ralf R. Kotowski: Hi, I'm currently runnig RH 6.2 and I'm considering upgrading to RH7.1 I'm planning on whiping the HD's completely and start from scratch and then install the latest RPM's from MySQL's site. The question is what would be the best

RE: Upgrading to 3.23.37 from 3.22.32

2001-08-09 Thread Adam Douglas
: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 7:38 AM To: Adam Douglas Cc: [EMAIL PROTECTED] Subject: Re: Upgrading to 3.23.37 from 3.22.32 Except, mysql needs write permission. Adam Douglas wrote: MySQL reports read only table. As for file permissions

Re: Upgrading to 3.23.37 from 3.22.32

2001-08-08 Thread Stefan Hinz
# Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Adam Douglas [EMAIL PROTECTED] To: 'Gerald Clark' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 11:02 PM Subject: RE: Upgrading to 3.23.37 from 3.22.32 MySQL reports read only table

Re: Upgrading to 3.23.37 from 3.22.32

2001-08-08 Thread Gerald Clark
Except, mysql needs write permission. Adam Douglas wrote: MySQL reports read only table. As for file permissions, everything is fine. Everyone has read and execute privileges. They are probably not owned by mysql anymore. Adam Douglas wrote: I just upgraded MySQL from 3.22.32 to

Re: Upgrading mysql on Win2K

2001-08-08 Thread Grigory Bakunov
Date |Tue, 7 Aug 2001 13:07:46 -0700 From |A. Clausen [EMAIL PROTECTED] Hello! AC What is the process of upgrading v3.23.36 to 3.23.40 on Windows NT. Can I just install over top or is there some other steps that should be taken? No.You can just install new version. AC I am running two mysql

Re: Upgrading to 3.23.37 from 3.22.32

2001-08-07 Thread Gerald Clark
They are probably not owned by mysql anymore. Adam Douglas wrote: I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was pkg_delete the old MySQL and install the new one. Before I delete the old MySQL I copied all the database files to a temporary location. Once the new

RE: Upgrading to 3.23.37 from 3.22.32

2001-08-07 Thread Adam Douglas
MySQL reports read only table. As for file permissions, everything is fine. Everyone has read and execute privileges. They are probably not owned by mysql anymore. Adam Douglas wrote: I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was pkg_delete the old MySQL and

RE: Upgrading MySQL on Windows Platform

2001-06-21 Thread Chris Bolt
Yes, just stop the mysql service before you begin installation by running something like net stop mysql from a command prompt. Hi everyone, I'm kinda new with MySQL and I have a question about upgrading MySQL to a newer version on Windows 2000 OS. Is there any special command that I

Re: Upgrading MySQL on Windows Platform

2001-06-21 Thread Miguel Angel Solórzano
At 14:32 21/06/2001 -0700, Martin Tunggorono wrote: Hi! Hi everyone, I'm kinda new with MySQL and I have a question about upgrading MySQL to a newer version on Windows 2000 OS. Is there any special command that I should run or should I just re-install the latest version 3.23.39. Will it

Re: Upgrading RPM 3.23.33 to 3.23.34

2001-03-14 Thread Charles L Hagen
rpm -Uhv ... Yes bring it down or it will not upgrade properly. You may need to upgrade Apache etc too. Need to check with your OS vendor on this. Charles Hagen On Thu, 15 Mar 2001 [EMAIL PROTECTED] wrote: Sorry for the basic-ness of my questions, but... What's the best way to

Re: Upgrading MySQL causes Error - ASP

2001-03-01 Thread Gerald L. Clark
They replaced your MySQL with a new version. Did they re-compile Apache and PHP to use the new MySQL libraries, or is it trying to use the now missing ones? Celso Pires wrote: Hi there, I've got a site hosted at an ISP and everything was going well when they decided to upgrade the

Re: Upgrading MySQL causes Error - ASP

2001-03-01 Thread Celso
it should be something related to GROUP BY clause. Celso. - Original Message - From: Gerald L. Clark [EMAIL PROTECTED] To: Celso Pires [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 01, 2001 11:11 Subject: Re: Upgrading MySQL causes Error - ASP

Re: Upgrading

2001-02-12 Thread Jan-Aage Bruvoll
On Mon, 12 Feb 2001, Ben Ocean wrote: I'm trying to upgrade to the latest distro. I thought I could simply d'l the distro, go in as root (Apache, RedHat) and enter the following command: # rpm -U MySQL-3.23.32-1.src.rpm Being no rpm expert, the above suggests that you fetched the source

Re: Upgrading

2001-02-12 Thread Jon Rosenberg
you need to grab the .i386.rpm files...you have the source code RPM. - Original Message - From: "Ben Ocean" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 10:14 AM Subject: Upgrading Hi; I'm trying to upgrade to the latest distro. I thought I could simply

<    1   2