RE: Upgrading MySQL erased all data
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! -steve-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading MySQL erased all data
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 from 4.1.3) on MacOS X erased the contents of /usr/local/mysql/data -- the privs and data of the previous installation. FYI Luckily (and unfortunately) we have a backup of that database from last week. (The guy that did it here in the office is still in a bit of a frenzy though). -s -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading MySQL erased all data
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 erased the contents of /usr/local/mysql/data -- the privs and data of the previous installation. FYI Luckily (and unfortunately) we have a backup of that database from last week. (The guy that did it here in the office is still in a bit of a frenzy though). -s -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading MySQL. Caveats or Cautions anyone?
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 to read carefully: http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html 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 if there are any cautions to observe, or any prepartory steps to take. If I look at the following URL: http://dev.mysql.com/downloads/mysql/4.0.html I see some things that confuse me a bit: I see this label: Linux (x86, glibc-2.2, static, gcc) ## Well, I've got glibc-2.3 And I see this label: Linux (x86, glibc-2.3, dynamic, Intel C++ Compiler) ## Well, glibc-2.3 looks good, *but* I don't have ## the Intel C++ Compiler. Just gcc (GCC) 3.2.2 Comments and pointers to docs would be appreciated. Thanks much tim -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Upgrading MySQL. Caveats or Cautions anyone?
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 libs from: ftp://ftp.mysql.com/pub/mysql/download/icc-8.0-libs.tar.gz MD5 checksum: 0970bbfb9fb076dfe995b3176bf90fad Then extract them and put them somewhere sensible (I chose /usr/local/lib) and then run ldconfig to find them. Without these libs none of the mysql apps would start. I guess 4.1.5g may have packaged the libs with the tarball, I don't know. Thanks, Mike -Original Message- From: Tim Johnson [mailto:[EMAIL PROTECTED] Sent: 18 September 2004 03:43 To: [EMAIL PROTECTED] Subject: Upgrading MySQL. Caveats or Cautions anyone? 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 if there are any cautions to observe, or any prepartory steps to take. If I look at the following URL: http://dev.mysql.com/downloads/mysql/4.0.html I see some things that confuse me a bit: I see this label: Linux (x86, glibc-2.2, static, gcc) ## Well, I've got glibc-2.3 And I see this label: Linux (x86, glibc-2.3, dynamic, Intel C++ Compiler) ## Well, glibc-2.3 looks good, *but* I don't have ## the Intel C++ Compiler. Just gcc (GCC) 3.2.2 Comments and pointers to docs would be appreciated. Thanks much tim -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading MySQL. Caveats or Cautions anyone?
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 if there are any cautions to observe, or any prepartory steps to take. If I look at the following URL: http://dev.mysql.com/downloads/mysql/4.0.html I see some things that confuse me a bit: I see this label: Linux (x86, glibc-2.2, static, gcc) ## Well, I've got glibc-2.3 And I see this label: Linux (x86, glibc-2.3, dynamic, Intel C++ Compiler) ## Well, glibc-2.3 looks good, *but* I don't have ## the Intel C++ Compiler. Just gcc (GCC) 3.2.2 Comments and pointers to docs would be appreciated. Thanks much tim -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading Mysql and Perl DBD
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 to connect to either server. Michael sean c peters wrote: I now have MySQL 4.0.2 and MySQL 4.1.3 beta both installed and running on one machine. I want to be able to use the Perl DBI / DBD to connect to both servers. I understand that there have been some changes between the MySQL 4.0.X and 4.1.X series that may require differently compiled DBD's. So my question is, do i need to have 2 separate DBD versions, or will the newer one work for both MySQL servers. The old DBD does not work for the new server. This is demonstrated by the error message: DBI-connect(...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at connect_test.pl line 19 All the connect_test.pl tries to do is create a db connection to each server separately. Any insight would be greatly appreciated thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading mySQL 3.23 to 4.0
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 redhat-linux-gnu (i386) some days ago, I had the same problem. Redhat's rpm packages mysql-3* and MySQL's new packages MySQL-4.0.20* are not compatible, because the are build in different ways - different nameing scheme and different content. Thatswhy this is no good idea to try rpm -Uvh I've deinstalled the old packages by rpm -e ... (save /etc/my.cnf and /var/lib/mysql before) and installed the new one on a 'mysql-clean' base. Bye, Wolfgang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading mySQL 3.23 to 4.0
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 MySQL-server-4.0.20-0.i386.rpm and as root ran the following: [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-server-4.0.20-0.i386.rpm MySQL-client-4.0.20-0.i386.rpm warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.9003-4 libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-20030510-4.1 libmysqlclient.so.10 is needed by (installed) php-mysql-4.3.4-11 [EMAIL PROTECTED] Desktop]# I am not sure what I need to do can someone please assist. Thank You Gary Install - MySQL-shared-4.0.20-0.i386.rpm, and - MySQL-shared-compat-4.0.20-0.i386.rpm as well. And probably MySQL-devel-4.0.20-0.i386.rpm just for kicks. The 2nd one is the specific package that should solve the problem, especially with the php-mysql package. HTH, Japheth J.C. Cleaver -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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...### [100%] 1:MySQL-shared-compat### [100%] [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm warning: MySQL-shared-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing...### [100%] package MySQL-shared-4.0.20-0 is already installed [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-devel-4.0.20-0.i386.rpm warning: MySQL-devel-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing...### [100%] file /usr/bin/comp_err from install of MySQL-devel-4.0.20-0 conflicts with file from package mysql-3.23.58-9 file /usr/bin/mysql_config from install of MySQL-devel-4.0.20-0 conflicts with file from package mysql-3.23.58-9 [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-server-4.0.20-0.i386.rpm MySQL-client-4.0.20-0.i386.rpm MySQL-devel-4.0.20-0.i386.rpm warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing...### [100%] 1:MySQL-server ### [ 33%] Installing all prepared tables 040802 17:21:17 Warning: Asked for 196608 thread stack, but got 126976 040802 17:21:17 /usr/sbin/mysqld: Shutdown Complete PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com 2:MySQL-client ### [ 67%] 3:MySQL-devel### [100%] [EMAIL PROTECTED] Desktop]# 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: Upgrading mySQL 3.23 to 4.0 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 MySQL-server-4.0.20-0.i386.rpm and as root ran the following: [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-server-4.0.20-0.i386.rpm MySQL-client-4.0.20-0.i386.rpm warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libmysqlclient.so.10 is needed by (installed) perl-DBD- MySQL-2.9003-4 libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-20030510-4.1 libmysqlclient.so.10 is needed by (installed) php-mysql- 4.3.4-11 [EMAIL PROTECTED] Desktop]# I am not sure what I need to do can someone please assist. Thank You Gary Install - MySQL-shared-4.0.20-0.i386.rpm, and - MySQL-shared-compat-4.0.20-0.i386.rpm as well. And probably MySQL-devel-4.0.20-0.i386.rpm
Re: Upgrading mySQL 3.23 to 4.0
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 - Original Message - From: [EMAIL PROTECTED] Date: Monday, 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... ### [100%] 1:MySQL-shared-compat ### [100%] [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm warning: MySQL-shared-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing... ### [100%] package MySQL-shared-4.0.20-0 is already installed [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-devel-4.0.20-0.i386.rpm warning: MySQL-devel-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing... ### [100%] file /usr/bin/comp_err from install of MySQL-devel-4.0.20-0 conflicts with file from package mysql-3.23.58-9 file /usr/bin/mysql_config from install of MySQL-devel- 4.0.20-0 conflicts with file from package mysql-3.23.58-9 [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-server-4.0.20-0.i386.rpm MySQL-client-4.0.20-0.i386.rpm MySQL-devel-4.0.20-0.i386.rpm warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing... ### [100%] 1:MySQL-server ### [ 33%] Installing all prepared tables 040802 17:21:17 Warning: Asked for 196608 thread stack, but got 126976040802 17:21:17 /usr/sbin/mysqld: Shutdown Complete PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h localhost.localdomain password 'new- password'See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com 2:MySQL-client ### [ 67%] 3:MySQL-devel ### [100%] [EMAIL PROTECTED] Desktop]# 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: Upgrading mySQL 3.23 to 4.0 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 MySQL-server-4.0.20-0.i386.rpm and as root ran the following: [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-server-4.0.20- 0.i386.rpm MySQL-client-4.0.20-0.i386.rpm warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libmysqlclient.so.10 is needed
Re: Upgrading mySQL 3.23 to 4.0
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 restart it manually, maybe using some of the init scripts. Carlos From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: Japheth Cleaver [EMAIL PROTECTED] Subject: Re: Upgrading mySQL 3.23 to 4.0 Date: Mon, 02 Aug 2004 17:31:03 -0400 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 - Original Message - From: [EMAIL PROTECTED] Date: Monday, 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... ### [100%] 1:MySQL-shared-compat ### [100%] [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm warning: MySQL-shared-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing... ### [100%] package MySQL-shared-4.0.20-0 is already installed [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-devel-4.0.20-0.i386.rpm warning: MySQL-devel-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing... ### [100%] file /usr/bin/comp_err from install of MySQL-devel- 4.0.20-0 conflicts with file from package mysql-3.23.58-9 file /usr/bin/mysql_config from install of MySQL-devel- 4.0.20-0 conflicts with file from package mysql-3.23.58-9 [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-server-4.0.20-0.i386.rpm MySQL-client-4.0.20-0.i386.rpm MySQL-devel-4.0.20-0.i386.rpm warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing... ### [100%] 1:MySQL-server ### [ 33%] Installing all prepared tables 040802 17:21:17 Warning: Asked for 196608 thread stack, but got 126976040802 17:21:17 /usr/sbin/mysqld: Shutdown Complete PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h localhost.localdomain password 'new- password'See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com 2:MySQL-client ### [ 67%] 3:MySQL-devel ### [100%] [EMAIL PROTECTED] Desktop]# 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: Upgrading mySQL 3.23 to 4.0 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 MySQL-server-4.0.20-0.i386.rpm and as root ran the following: [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-server-4.0.20- 0.i386.rpm MySQL-client-4.0.20-0.i386.rpm warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libmysqlclient.so.10 is needed by (installed) perl- DBD- MySQL-2.9003-4 libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-20030510-4.1 libmysqlclient.so.10 is needed by (installed) php- mysql- 4.3.4-11 [EMAIL PROTECTED] Desktop]# I am not sure what I need to do can someone please assist. Thank You Gary Install - MySQL-shared-4.0.20-0.i386.rpm
Re: Upgrading mySQL 3.23 to 4.0
supposedly ?, you can check if the mysqld daemon is running with: ps -ef | grep mysql if the daemon is running then the error is something else but my first bet is that is not running. Carlos From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Carlos Proal [EMAIL PROTECTED] CC: [EMAIL 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 pm Subject: Re: Upgrading mySQL 3.23 to 4.0 The upgrade shutdown the database, i think you must restart it manually, maybe using some of the init scripts. Carlos From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: Japheth Cleaver [EMAIL PROTECTED] Subject: Re: Upgrading mySQL 3.23 to 4.0 Date: Mon, 02 Aug 2004 17:31:03 -0400 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 - Original Message - From: [EMAIL PROTECTED] Date: Monday, 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... ### [100%] 1:MySQL-shared-compat ### [100%] [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm warning: MySQL-shared-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing... ### [100%] package MySQL-shared-4.0.20-0 is already installed [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-devel-4.0.20-0.i386.rpm warning: MySQL-devel-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing... ### [100%] file /usr/bin/comp_err from install of MySQL-devel- 4.0.20-0 conflicts with file from package mysql-3.23.58-9 file /usr/bin/mysql_config from install of MySQL-devel- 4.0.20-0 conflicts with file from package mysql-3.23.58-9 [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-server-4.0.20-0.i386.rpm MySQL-client-4.0.20-0.i386.rpm MySQL-devel-4.0.20-0.i386.rpm warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing... ### [100%] 1:MySQL-server ### [ 33%] Installing all prepared tables 040802 17:21:17 Warning: Asked for 196608 thread stack, but got 126976040802 17:21:17 /usr/sbin/mysqld: Shutdown Complete PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h localhost.localdomain password 'new- password'See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com 2:MySQL-client ### [ 67%] 3:MySQL-devel ### [100%] [EMAIL PROTECTED] Desktop]# 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: Upgrading mySQL 3.23 to 4.0 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 MySQL-server-4.0.20-0.i386.rpm and as root ran the following: [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-server-4.0.20- 0.i386.rpm MySQL-client-4.0.20-0.i386.rpm warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libmysqlclient.so.10 is needed by (installed) perl
Re: Upgrading mySQL 3.23 to 4.0
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 seems like your MySQL server is not running. Try: # /etc/init.d/mysql start And check what does the error log say. On my Fedora it is in: /var/lib/mysql/hostname.err -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading a server to latest MySQL
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: upgrading a server to latest MySQL I have MySQL 3.23.41 running on an Apache server with Red hat. it's hosted at EV1 (formerly Rackshack) but they do not provide any support for the server. I'd like to upgrade to the latest MySQL. Does anyone know of a bulletproof, step-by-step, online guide to doing this? Perhaps a reasonable priced resource that will do it? Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading from 3.23 to 4.0 Problem
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, 2004 9:12 AM Subject: Upgrading from 3.23 to 4.0 Problem Im trying to upgrade 3.23 on my redhat 9 machine. I have one lone perl-dbd-mysql libmysqlclient dependency that is throwing me off. when i try to upgrade it wont go. so i try to uninstall that perl rpm and it says its mysql 3.23 needs it and when i try to uninstall mysql 3.23 it says the perl dbd needs it. how do i get around this catch? __ Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Upgrading help please
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 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, and then told me to use the /usr/bin/mysql_fix_privilege_tables script which I did got horrid errors ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) So I specified mysql_fix_privilege_tables root_password Same Errors (2002) Tried the other method that is on the mysql manual mysql_fix_privilege_tables --password=root_password Same error 2002. now Unfortunately I am unable to even connect to mysql with either mysqladmin or the client. MySQL-bench-4.0.16-0.i386.rpm MySQL-client-4.0.16-0.i386.rpm MySQL-devel-4.0.16-0.i386.rpm MySQL-embedded-4.0.16-0.i386.rpm MySQL-Max-4.0.16-0.i386.rpm MySQL-server-4.0.16-0.i386.rpm MySQL-shared-4.0.16-0.i386.rpm MySQL-shared-compat-4.0.16-0.i386.rpm is a list of the RPMS that I downloaded and ran. Any ideas and help would be most appreciated. Thank you Andrew Message sent using UebiMiau 2.7.2 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading help please
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, and then told me to use the /usr/bin/mysql_fix_privilege_tables script which I did got horrid errors ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) So I specified mysql_fix_privilege_tables root_password Same Errors (2002) Tried the other method that is on the mysql manual mysql_fix_privilege_tables --password=root_password Same error 2002. now Unfortunately I am unable to even connect to mysql with either mysqladmin or the client. MySQL-bench-4.0.16-0.i386.rpm MySQL-client-4.0.16-0.i386.rpm MySQL-devel-4.0.16-0.i386.rpm MySQL-embedded-4.0.16-0.i386.rpm MySQL-Max-4.0.16-0.i386.rpm MySQL-server-4.0.16-0.i386.rpm MySQL-shared-4.0.16-0.i386.rpm MySQL-shared-compat-4.0.16-0.i386.rpm is a list of the RPMS that I downloaded and ran. Any ideas and help would be most appreciated. Thank you Andrew Message sent using UebiMiau 2.7.2 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading
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 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading 3.23-4.0 under WinXP ?
- 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
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?
mysql_fix_privilege_tables is a shell script for *nix. You can open it
in a text editor and see the ALTER and UPDATE queries that it would run.
I will post below the ones that I think are needed to upgrade the system
tables from 3.23 - 4.0. BTW, if you haven't modified the default
permissions or grants on anything, you can just drop the mysql
database (delete it from the data directory after stopping MySQL), and
then just reinstall MySQL 4.0 and it will put the correct default tables
there. Again, don't do this if you've changed the default MySQL
permissions (or you don't want to recreate them :-)).
Anyway, here's the queries from mysql_fix_privilege_tables that I think
you need to run on the mysql database (as the root user; and you ignore
any duplicate column errors, etc.):
USE mysql;
alter table user change password password char(16) NOT NULL;
alter table user add File_priv enum('N','Y') NOT NULL;
alter table user add Grant_priv enum('N','Y') NOT NULL,add
References_priv enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT
NULL,add Alter_priv enum('N','Y') NOT NULL;
alter table host add Grant_priv enum('N','Y') NOT NULL,add
References_priv enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT
NULL,add Alter_priv enum('N','Y') NOT NULL;
alter table db add Grant_priv enum('N','Y') NOT NULL,add References_priv
enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT NULL,add
Alter_priv enum('N','Y') NOT NULL;
UPDATE user SET
Grant_priv=File_priv,References_priv=Create_priv,Index_priv=Create_priv,
Alter_priv=Create_priv;
UPDATE db SET
References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_pri
v;
UPDATE host SET
References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_pri
v;
ALTER TABLE user
ADD ssl_type enum('','ANY','X509', 'SPECIFIED') NOT NULL,
ADD ssl_cipher BLOB NOT NULL,
ADD x509_issuer BLOB NOT NULL,
ADD x509_subject BLOB NOT NULL;
alter table user
add Show_db_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER alter_priv,
add Super_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Show_db_priv,
add Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER
Super_priv,
add Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER
Create_tmp_table_priv,
add Execute_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER
Lock_tables_priv,
add Repl_slave_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER
Execute_priv,
add Repl_client_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER
Repl_slave_priv;
update user set show_db_priv= select_priv, super_priv=process_priv,
execute_priv=process_priv, create_tmp_table_priv='Y',
Lock_tables_priv='Y', Repl_slave_priv=file_priv,
Repl_client_priv=file_priv where user;
alter table user
add max_questions int(11) NOT NULL AFTER x509_subject,
add max_updates int(11) unsigned NOT NULL AFTER max_questions,
add max_connections int(11) unsigned NOT NULL AFTER max_updates;
alter table db
add Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL,
add Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL;
alter table host
add Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL,
add Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL;
FLUSH PRIVILEGES;
(Everything seems to work except my guestbooks after the reinstall).
Not sure about that not working. :-/
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading to MySQL 4
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. The main question I have is should I take this opportunity to upgrade to MySQL4, or should I just upgrade to 3.24 with InnoDB support. I would like to go to 4 just because I am going to have to do it at some point, but that raises a few other questions that I haven't been able to find answers to. Can I install MySQL 4 on a system with MySQL 3.23 and then just switch over when I have it configured (with the only down time being the time it takes to move the data). Are the two versions compatible that I don't need to go through that trouble and can just reliably upgrade (via rpm). Are there any changes that I need to make to the PHP code running the web app that connects to MySQL (I can find this one out elsewhere I am sure). Any help will be appreciated, as will links to documentation/tutorials that I have missed with Google. Thanks, -Jackson I recently upgraded our web server from 3.23.56 to 4.0.13 It was already using INNODB tables in 3.23.56 and the INNODB table space files I did not have to delete and/or recreate or import. Shut the server down, de-installed 3.23.56, installed 4.0.13, started it up, all was good.. There is a script to run which adds some new security options in the users table I think. Other than that it was a very straight-forward and easy upgrade. Now then, my upgrade was from 3 to 4 with INNODB already in place. Any way you do it, MAKE BACKUPS! Make your backup with the --opt option to mysqldump which makes importing much faster whether MyISAM, INNODB or whatever. Someone else will have to confirm, but if MyISAM tables are as easy of an upgrade you could do the same I did with a functional 4.0.13 (.14 now I guess, just got the notice it's released today) with MyISAM tables. You could then later add INNODB table space and convert the tables over in-place, probably after temporarily taking the web site down until it completes. As far as the web site, our web applications in PHP required no changes at all.. YMMV but at least for us it was a painless switch. Row-level locking is great as well as lots of other things in 4. Check out the query cache if your web queries ask for the same pieces of data repeatedly with rare changes to it. The query results will get cached and returned very quickly after the initial query run... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading MySQL on RedHat 9
-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 (verion 4.0). Just thought I'd post to get a heads-up on any known issues or prerequisites. I just hate it when I try something like this and screw up my whole installation. My planned steps are to: 1. mysqldump everything to a backup file 2. stop the service 3. uninstall all the current rpm's 4. install the fresh rpm's 5. startup 6. \. the file from step 1 Anything I need to lookout for? If you want to keep apps that shipped with the distro but are linked against the 3.23 libmysqlclient, you may want to install MySQL-shared-compat to satisfy the RPM library dependencies. That should work, but after you install the new RPM files, use chkconfig --list mysql to make sure that the server is set to start on runlevels 2 through 5. If it's not, use: chkconfig --levels 2345 mysql on Otherwise, the server won't start automatically at system boot time. This problem has been seen on RH 8 and RH 9. I understand it's been fixed now, but I'm not sure if the fix is in the current release or the next one. It will be fixed for 4.0.14: http://bugs.mysql.com/bug.php?id=272 Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer MySQL GmbH, http://www.mysql.de/ Hamburg, Germany For technical support contracts, visit https://order.mysql.com/?ref=mlgr -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE/BIQsSVDhKrJykfIRAsaIAJ0RkCCcoWOTJ1gHCkZ+MSvvt3vxBACfeW7X P7xkEZ1GfESz7bwMpF4+5/E= =aHHD -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading MySQL on RedHat 9
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 it when I try something like this and screw up my whole installation. My planned steps are to: 1. mysqldump everything to a backup file 2. stop the service 3. uninstall all the current rpm's 4. install the fresh rpm's 5. startup 6. \. the file from step 1 Anything I need to lookout for? That should work, but after you install the new RPM files, use chkconfig --list mysql to make sure that the server is set to start on runlevels 2 through 5. If it's not, use: chkconfig --levels 2345 mysql on Otherwise, the server won't start automatically at system boot time. This problem has been seen on RH 8 and RH 9. I understand it's been fixed now, but I'm not sure if the fix is in the current release or the next one. Thanks. Andrew -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading
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 anybody explain to me how to proceed?? Thank you very much -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading to 4.0
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 :) as root : #pkg_deinstall mysql-server (...) #port_install -rR databases/mysql40-server (...) #mysqld_safe (it isnot anymore safe_mysqld ) and it runs :)) Well, better do some back-up first -- Anselme [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Upgrading to 4.0
Thank you for your answer Anselme!! I am working on Windows98. I've read some documents on mysql home page which explain the difference between version. That information talks about some script to be run for upgrading version but there is no related file to download. Could you help me?? Thank 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 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 :) as root : #pkg_deinstall mysql-server (...) #port_install -rR databases/mysql40-server (...) #mysqld_safe (it isnot anymore safe_mysqld ) and it runs :)) Well, better do some back-up first -- Anselme [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading, tuning and performance
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 immediately after you installed it. Whenever the performane question comes up than the first thing I read here in the mailing list Are you still running one of those old 3.23-xx versions ?? ;-) Unfortunately thats almost all I can tell you. Best regards Nils Valentin Tokyo/Japan 2003 6 16 21:45Andy Stubbs : 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 2500 with dual 1400MHz PIII processors and 4GB RAM with RedHat 7.3 kernel 2.4.18-10smp. The database itself is actually quite small; about 3.3GB on disk. Disk configuration is RAID-5, 3 disks, chunksize 8KB, default mounting options. Currently, when moderately busy, it's not unusual to see 400 queries/sec, so I imagine when running top whack at the moment we're probably hitting up to 500 selects/second. Keeping our developers focussed on how their design decisions affect performance is a continual process of course... Anyway, the load average on this server is hitting 2 occasionally, and it's time either to tune the configuration, move it onto some other kit, or buy in some kit specifically. Apparently I might be looking at the traffic on the database quadrupling in the next few months, so I'm keen on getting this sorted ASAP. Having Read The Fine Manual, and being more of a coder/sysadmin than a DBA I have some dumb questions. Which are: 1. Does anybody else have any experience with this situation? Good, Bad, Ugly? 2. I can move this DB to a dual PE2600 with dual Xeon 1.8GHz processors. and I can get up to 6GB RAM in there. Is it worth doing this? i.e., how much extra capacity does this buy me? Does enabling HyperThreading on the Xeons help or hinder database servers? 3. Would upgrading to 4.0.13 help at all? What kind of performance does it have compared with 3.23.56? This is a medium term goal anyway, and we'd like to take rather more time over it. 4. I read that on a 32 bit architecture (like these Pentium class CPUs) the database tables are not memory-mapped (i.e., it's not possible to store the entire database in memory anyway). Is this the case with the 64 bit Solaris too? Is there a planned implementation schedule for this functionality? 5. What's the performance of MySQL like on Solaris 8/9 compared to Linux 2.4.18? Is a big multiprocessor Sun box (like a Sun Fire 880 or 1280) a good choice for a database server running MySQL? Or are there more suitable platforms? Is, in fact, something like a SunFire 880 overkill? 6. Would it be complete lunacy, in the absence of memory-mapped tables, to specify a RAM-disk on which to store the database? Should improve seek times, eh? And lots of redundant UPS stuff. 7. Any other suggestions welcome. I'm a bit nervous about turning off atime on mounting the disks - is it really not used by the database anywhere? what kind of performance boost does it give? Regards, Andy -- Andy Stubbs, B.A., Ph.D. Network Manager, Active Hotels Ltd. +44 1223 578106 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading, tuning and performance
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 2500 with dual 1400MHz PIII processors and 4GB RAM with RedHat 7.3 kernel 2.4.18-10smp. The database itself is actually quite small; about 3.3GB on disk. Disk configuration is RAID-5, 3 disks, chunksize 8KB, default mounting options. Currently, when moderately busy, it's not unusual to see 400 queries/sec, so I imagine when running top whack at the moment we're probably hitting up to 500 selects/second. Keeping our developers focussed on how their design decisions affect performance is a continual process of course... Anyway, the load average on this server is hitting 2 occasionally, and it's time either to tune the configuration, move it onto some other kit, or buy in some kit specifically. Apparently I might be looking at the traffic on the database quadrupling in the next few months, so I'm keen on getting this sorted ASAP. Having Read The Fine Manual, and being more of a coder/sysadmin than a DBA I have some dumb questions. Which are: 1. Does anybody else have any experience with this situation? Good, Bad, Ugly? 2. I can move this DB to a dual PE2600 with dual Xeon 1.8GHz processors. and I can get up to 6GB RAM in there. Is it worth doing this? i.e., how much extra capacity does this buy me? Does enabling HyperThreading on the Xeons help or hinder database servers? 3. Would upgrading to 4.0.13 help at all? What kind of performance does it have compared with 3.23.56? This is a medium term goal anyway, and we'd like to take rather more time over it. 4. I read that on a 32 bit architecture (like these Pentium class CPUs) the database tables are not memory-mapped (i.e., it's not possible to store the entire database in memory anyway). Is this the case with the 64 bit Solaris too? Is there a planned implementation schedule for this functionality? 5. What's the performance of MySQL like on Solaris 8/9 compared to Linux 2.4.18? Is a big multiprocessor Sun box (like a Sun Fire 880 or 1280) a good choice for a database server running MySQL? Or are there more suitable platforms? Is, in fact, something like a SunFire 880 overkill? 6. Would it be complete lunacy, in the absence of memory-mapped tables, to specify a RAM-disk on which to store the database? Should improve seek times, eh? And lots of redundant UPS stuff. 7. Any other suggestions welcome. I'm a bit nervous about turning off atime on mounting the disks - is it really not used by the database anywhere? what kind of performance boost does it give? Regards, Andy -- Andy Stubbs, B.A., Ph.D. Network Manager, Active Hotels Ltd. +44 1223 578106 Andy, A load avg of 2 sounds like the machine is under a high I/O load. Have you considered using 15k rpm drives? Is your raid setup hardware or software? walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading, tuning and performance
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 avgrq-sz avgqu-sz await svctm %util /dev/sdb12.74 4.63 8.58 7.10 90.54 94.5845.2747.2911.81 0.054.73 4.10 0.64 I'd say the 95-percentile for load is rather more like 1.4 than 2. Thanks for the input, A On Mon, 16 Jun 2003, walt wrote: 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 2500 with dual 1400MHz PIII processors and 4GB RAM with RedHat 7.3 kernel 2.4.18-10smp. The database itself is actually quite small; about 3.3GB on disk. Disk configuration is RAID-5, 3 disks, chunksize 8KB, default mounting options. Currently, when moderately busy, it's not unusual to see 400 queries/sec, so I imagine when running top whack at the moment we're probably hitting up to 500 selects/second. Keeping our developers focussed on how their design decisions affect performance is a continual process of course... Anyway, the load average on this server is hitting 2 occasionally, and it's time either to tune the configuration, move it onto some other kit, or buy in some kit specifically. Apparently I might be looking at the traffic on the database quadrupling in the next few months, so I'm keen on getting this sorted ASAP. Having Read The Fine Manual, and being more of a coder/sysadmin than a DBA I have some dumb questions. Which are: 1. Does anybody else have any experience with this situation? Good, Bad, Ugly? 2. I can move this DB to a dual PE2600 with dual Xeon 1.8GHz processors. and I can get up to 6GB RAM in there. Is it worth doing this? i.e., how much extra capacity does this buy me? Does enabling HyperThreading on the Xeons help or hinder database servers? 3. Would upgrading to 4.0.13 help at all? What kind of performance does it have compared with 3.23.56? This is a medium term goal anyway, and we'd like to take rather more time over it. 4. I read that on a 32 bit architecture (like these Pentium class CPUs) the database tables are not memory-mapped (i.e., it's not possible to store the entire database in memory anyway). Is this the case with the 64 bit Solaris too? Is there a planned implementation schedule for this functionality? 5. What's the performance of MySQL like on Solaris 8/9 compared to Linux 2.4.18? Is a big multiprocessor Sun box (like a Sun Fire 880 or 1280) a good choice for a database server running MySQL? Or are there more suitable platforms? Is, in fact, something like a SunFire 880 overkill? 6. Would it be complete lunacy, in the absence of memory-mapped tables, to specify a RAM-disk on which to store the database? Should improve seek times, eh? And lots of redundant UPS stuff. 7. Any other suggestions welcome. I'm a bit nervous about turning off atime on mounting the disks - is it really not used by the database anywhere? what kind of performance boost does it give? Regards, Andy -- Andy Stubbs, B.A., Ph.D. Network Manager, Active Hotels Ltd. +44 1223 578106 Andy, A load avg of 2 sounds like the machine is under a high I/O load. Have you considered using 15k rpm drives? Is your raid setup hardware or software? walt -- Andy Stubbs, B.A., Ph.D. Network Manager, Active Hotels Ltd. +44 1223 578106 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading to 4.0 on Solaris
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 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 running Solaris 8, but would like to upgrade to 4.0 to be able to use UNION. To put it mildly, I'm having problems. These are two problems. 1. The upgrade instructions do not say anything about how you upgrade your old database. Section 2.3.2 of the manual only talks about things such as running things like mysql_fix_privilege_tables. From asking around I gather you are expected to use mysqldump to transfer databases, however I am totally in the dark as what stage of the new install you add the old tables. 2. In addition, I am having difficulty (this weekend - it was ok last weekend but then I scrapped it and went back to 3.23) in starting mysql 4.0 after doing an install. I did an mysqldump on 3.23, shut down the old server, and changed the mysql directory name to mysql3.23. I follow the instructions in 2.2.9, run scripts/mysql_install_db and check that the grant tables have been created in data. However when I try bin/safe_mysqld --user=mysql the daemon starts and then quits. The .err log says it can't find host.frm, but the file has definitely been created. I've installed the distribution as /usr/local/mysql - so everything would appear to be in the standard location. I'd be most grateful for any suggestions on either point. David -- ___ David P.Leader, Biochemistry and Molecular Biology Davidson Building, University of Glasgow, Glasgow G12 8QQ, UK Phone: +44 41 330-5905[EMAIL PROTECTED] http://doolittle.ibls.gla.ac.uk/leader ___ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading to v 4.1
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 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 problem anymore. So keep an eye out for how it behaves for you on Max OS X under load. Which version of FreeBSD and LinuxThreads are you using? I've never experienced that bug before. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 114 days, processed 3,574,536,636 queries (360/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 : mysql_fix_privilege_tables behaves odd, explain this Well this is very interesting At the start of the script they have root_password=$1 host=localhost user=root I added in just below the above echo -- echo $root_password echo -- Then if you try sh mysql_fix_privilege_tables -p somepassword Guess what you get... -- -p somepassword -- So it seems the script takes the whole argument... sh mysql_fix_privilege_tables my_root_pass Works fine Is this standard behavior? The Script says echo If you get 'Access denied' errors, you should run this script again echo and give the MySQL root user password as an argument! Does not really tell you there is some special way to do it. What is the heck is $1 anyway? And why is it a literally quoted value? - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: upgrading to v 4.1
AHHH! I bet that is why I was having such a horrible time last night trying to upgrade! I finally said fsck it and reverted back to 3.23.55... I don't use a root password on localhost... Now I'll try your suggestions and see if it works. *sigh* *crosses fingers* -Original Message- 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 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 : mysql_fix_privilege_tables behaves odd, explain this Well this is very interesting At the start of the script they have root_password=$1 host=localhost user=root I added in just below the above echo -- echo $root_password echo -- Then if you try sh mysql_fix_privilege_tables -p somepassword Guess what you get... -- -p somepassword -- So it seems the script takes the whole argument... sh mysql_fix_privilege_tables my_root_pass Works fine Is this standard behavior? The Script says echo If you get 'Access denied' errors, you should run this script again echo and give the MySQL root user password as an argument! Does not really tell you there is some special way to do it. What is the heck is $1 anyway? And why is it a literally quoted value? - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: upgrading to v 4.1
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 and read http://www.mysql.com/doc/en/Upgrading-from-3.23.html and http://www.mysql.com/doc/en/Mac_OS_X_installation.html and http://www.entropy.ch/software/macosx/mysql/ -Original Message- From: Ted Rogers [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 4:52 PM To: [EMAIL PROTECTED] Subject: upgrading to v 4.1 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 don't see that particular problem anymore. So keep an eye out for how it behaves for you on Max OS X under load. --- Ted Rogers [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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading to v 4.1
Hi, What do you call hung up ? All query appearing in opening table state when doing a show processlist ? If this is the case, 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 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 you on Max OS X under load. --- Ted Rogers [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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading to v 4.1
No, in my case, both queries report being in Connect state and just stay there. Something like this: | 14376 | unauthenticated user | 10.0.48.147 | | Connect | | login | | | 14416 | unauthenticated user | 10.0.48.147 | | Connect | | login Googling around on this I see various people have run into something similar from time to time, so perhaps it's an old bug that has been reintroduced in the 4.1alpha code --- Jocelyn Fournier [EMAIL PROTECTED] wrote: Hi, What do you call hung up ? All query appearing in opening table state when doing a show processlist ? If this is the case, 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 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 you on Max OS X under load. --- Ted Rogers [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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading to v 4.1
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 problem anymore. So keep an eye out for how it behaves for you on Max OS X under load. Which version of FreeBSD and LinuxThreads are you using? I've never experienced that bug before. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 114 days, processed 3,574,536,636 queries (360/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading from 3.23.5x to 4.0.12 version 4 show no tables in any database
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 and everything worked. On only Linux Redhat 7.3 server RPM upgrade also worked fine. The problem is that mysql server report no tables in any database. When I run MySQL client show tables; return empty dataset in databases. 3.23.5x work fine. I am reporting this from the server where upgrade was successful. The server where error occured is almost identical it only is Redhat 7.3 instead of 7.2. How-To-Repeat: I have downgraded to 3.23.56 where tables are seen. Every time I upgrade I get the same error. Fix: No idea. Submitter-Id: submitter ID Originator: Organization: MySQL support: none Synopsis: Upgrade problem Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.12 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.40 Distrib 4.0.12, for pc-linux on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.12 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 days 15 hours 11 min 33 sec Threads: 1 Questions: 3114 Slow queries: 0 Opens: 151 Flush tables: 1 Open tables: 46 Queries per second avg: 0.010 C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux falcon 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.2 2.96-112.7.2) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Mar 20 09:15 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285884 Mar 6 16:03 /lib/libc-2.2.4.so -rw-r--r--1 root root 27338566 Mar 6 15:05 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 6 15:05 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server' '--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Upgrading from 3.23.5x to 4.0.12 version 4 show no tables in any database
That was my first thought too. Shouldn't then MySQL also report nonexisting databases? When I run client mysql database_name it runs only on existing databases. When I write wrong database name it won't run, so it look in the right directory. If the database directory was wrong it shouldn't work 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 no tables in any database 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 and everything worked. On only Linux Redhat 7.3 server RPM upgrade also worked fine. The problem is that mysql server report no tables in any database. When I run MySQL client show tables; return empty dataset in databases. 3.23.5x work fine. I am reporting this from the server where upgrade was successful. The server where error occured is almost identical it only is Redhat 7.3 instead of 7.2. How-To-Repeat: I have downgraded to 3.23.56 where tables are seen. Every time I upgrade I get the same error. Fix: No idea. Submitter-Id: submitter ID Originator: Organization: MySQL support: none Synopsis: Upgrade problem Severity: serious Priority: medium Category: mysql Class: sw-bug Release:mysql-4.0.12 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.40 Distrib 4.0.12, for pc-linux on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.12 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 days 15 hours 11 min 33 sec Threads: 1 Questions: 3114 Slow queries: 0 Opens: 151 Flush tables: 1 Open tables: 46 Queries per second avg: 0.010 C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux falcon 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.2 2.96-112.7.2) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Mar 20 09:15 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285884 Mar 6 16:03 /lib/libc-2.2.4.so -rw-r--r--1 root root 27338566 Mar 6 15:05 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 6 15:05 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server' '--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading
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 pulls data from /home/mysql3/var. Also, neither version has a my.cnf file. Create one. You don't give enough information for any other answer. Thanks, Joe. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 hours soon. We are running win2k servers so I can't speak directly to any linux issues, but generically speaking, upgrading to 3.23.56 was easy: I downloaded the installation files to my server and unzipped them. Stopped the MySQL service AND mysqladmin (you will have errors if you don't do this!). Then ran the setup.exe, restarted the service, checked mysql admin and saw that the version had been updated, and smiled. I would imagine if you follow the corresponding linux-steps, you should have no problems. Good luck, Tab mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: upgrading mysql
On a linux box you do not have to stop everything like on Windows. We always leave our current version running, install the upgrade in a new location with a new data dir (a snapshot of the live one). We run the new install on a different port than the live install so we can test it and what not before switching over. We always leave our installs in a directory that gives the version info like mysql-3.23.55-pc-linux-i686 and then symlink a directory named mysql to the version that should be live. So when we decide it is time to go live with the new install we change the conf to point to the correct data dir and to be on the right port, stop mysqld, change the symlink and then restart with the new version. This allows for easy rollbacks just in case. We have had really poor luck with building from source on our VA Linux box and have used the binaries for the last two or three 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] 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 generically speaking, upgrading to 3.23.56 was easy: I downloaded the installation files to my server and unzipped them. Stopped the MySQL service AND mysqladmin (you will have errors if you don't do this!). Then ran the setup.exe, restarted the service, checked mysql admin and saw that the version had been updated, and smiled. I would imagine if you follow the corresponding linux-steps, you should have no problems. Good luck, Tab mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: upgrading mysql
Thank you for your reply. OK, I understand that. So what are the steps to install the file. Isn't there an RPM or something. Do I take the 4.0 binary and place it an any folder on my box? Then go to that directory and type a lynix command to unpack and install the files? Then, go to the config file (not sure which one), maybe the one in my database and point it to the new mqsql program? I relly appreciate your help. Thanks, Mike The following message was sent by Jennifer Goodie [EMAIL PROTECTED] on Fri, 21 Mar 2003 14:36:43 -0800. On a linux box you do not have to stop everything like on Windows. We always leave our current version running, install the upgrade in a new location with a new data dir (a snapshot of the live one). We run the new install on a different port than the live install so we can test it and what not before switching over. We always leave our installs in a directory that gives the version info like mysql-3.23.55-pc-linux-i686 and then symlink a directory named mysql to the version that should be live. So when we decide it is time to go live with the new install we change the conf to point to the correct data dir and to be on the right port, stop mysqld, change the symlink and then restart with the new version. This allows for easy rollbacks just in case. We have had really poor luck with building from source on our VA Linux box and have used the binaries for the last two or three 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] 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 generically speaking, upgrading to 3.23.56 was easy: I downloaded the installation files to my server and unzipped them. Stopped the MySQL service AND mysqladmin (you will have errors if you don't do this!). Then ran the setup.exe, restarted the service, checked mysql admin and saw that the version had been updated, and smiled. I would imagine if you follow the corresponding linux-steps, you should have no problems. Good luck, Tab mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: upgrading mysql
These links may help: 2.5.2 Upgrading From Version 3.23 to Version 4.0 http://www.mysql.com/doc/en/Upgrading-from-3.23.html 2.1.1 Installing MySQL on Linux http://www.mysql.com/doc/en/Linux-RPM.html 2.6.1.1 Linux Notes for Binary Distributions http://www.mysql.com/doc/en/Binary_notes-Linux.html 2.2 General Installation Issues http://www.mysql.com/doc/en/General_Installation_Issues.html At 16:59 -0500 3/21/03, [EMAIL PROTECTED] wrote: Thank you for your reply. OK, I understand that. So what are the steps to install the file. Isn't there an RPM or something. Do I take the 4.0 binary and place it an any folder on my box? Then go to that directory and type a lynix command to unpack and install the files? Then, go to the config file (not sure which one), maybe the one in my database and point it to the new mqsql program? I relly appreciate your help. Thanks, Mike The following message was sent by Jennifer Goodie [EMAIL PROTECTED] on Fri, 21 Mar 2003 14:36:43 -0800. On a linux box you do not have to stop everything like on Windows. We always leave our current version running, install the upgrade in a new location with a new data dir (a snapshot of the live one). We run the new install on a different port than the live install so we can test it and what not before switching over. We always leave our installs in a directory that gives the version info like mysql-3.23.55-pc-linux-i686 and then symlink a directory named mysql to the version that should be live. So when we decide it is time to go live with the new install we change the conf to point to the correct data dir and to be on the right port, stop mysqld, change the symlink and then restart with the new version. This allows for easy rollbacks just in case. We have had really poor luck with building from source on our VA Linux box and have used the binaries for the last two or three 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] 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 generically speaking, upgrading to 3.23.56 was easy: I downloaded the installation files to my server and unzipped them. Stopped the MySQL service AND mysqladmin (you will have errors if you don't do this!). Then ran the setup.exe, restarted the service, checked mysql admin and saw that the version had been updated, and smiled. I would imagine if you follow the corresponding linux-steps, you should have no problems. Good luck, Tab mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Jeff Shapiro, Colorado Springs, CO, USA At work I *have* to use a Windows machine, at home I *get* to use a Mac. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading from 3.22
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 check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading from 3.22
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 backup first, just in case something goes wrong. -- Paul DuBois http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading Red Hat rpms
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 then install --the new rpms (after backing everything up first, of course). Is there --anything else I should do or look out for? What I usually do whith RPMS...is to upgrade them...with -U option. rpm -U package.version.rpm -- --Thanks in advance -- --Walter -- -- --- --Before posting, please check: -- http://www.mysql.com/manual.php (the manual) -- http://lists.mysql.com/ (the list archive) -- --To request this thread, e-mail [EMAIL PROTECTED] --To unsubscribe, e-mail [EMAIL PROTECTED] --Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading to version 4.
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 wrong, but I would like to just double check. PHP's mysql_connect() is just a wrapper around the C API mysql_connect. As the manual says: This function is deprecated. It is preferable to use mysql_real_connect() instead. I assume that PHP 4.2.3 is already using mysql_real_connect(). If this is not the case, I'm quite sure (if no one here disagrees ;) that PHP 5 will. And I'm really sure that it will always be called mysql_connect() in PHP, just to keep things easy. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Maximo Migliari [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 13, 2003 7:45 PM Subject: Upgrading to version 4. 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 MySQL with CFLAGS=-DUSE_OLD_FUNCTIONS. Instead of doing this, it is preferable to change the client to use the new 4.0 API. - 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 wrong, but I would like to just double check. Thanks, Maximo. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading to version 4.
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 assume PHP uses these to communicated with MySQL. Perhaps I might be wrong, but I would like to just double check. PHP's mysql_connect() is just a wrapper around the C API mysql_connect. Huh? PHP's mysql_connect() has been using mysql_real_connect() for several years now. As the manual says: This function is deprecated. It is preferable to use mysql_real_connect() instead. I assume that PHP 4.2.3 is already using mysql_real_connect(). If this is not the case, I'm quite sure (if no one here disagrees ;) that PHP 5 will. And I'm really sure that it will always be called mysql_connect() in PHP, just to keep things easy. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading to version 4.
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 MySQL with CFLAGS=-DUSE_OLD_FUNCTIONS. Instead of doing this, it is preferable to change the client to use the new 4.0 API. - 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 wrong, but I would like to just double check. The PHP MySQL API will still work for you. Additionally, there is a new API that is currently in development that is intended to support the new features of MySQL like SSL connections, prepared statements, etc. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Find the highest score for a given name mysql SELECT name, max(score) FROM high_score GROUP BY name; Gosh, Batman. The nobility of the almost-human porpoise. --Robin, the Boy Wonder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading from MySQL 3.23.52 to 3.23.54
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 regarding this or patches but was unable to find any. I would appreciate your help. Thanks! Peter Teo Clickhere2 Network Pte Ltd Just update. You will not lose your database contents (though a backup is no bad idea, if you are unsure). -- Christian Kohlschütter [EMAIL PROTECTED] http://www.newsclub.de - Der Meta-Nachrichten-Dienst - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Upgrading from MySQL 3.23.52 to 3.23.54
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 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 stable version. How can I do this without uninstalling my current version? I tried to look for some documentation regarding this or patches but was unable to find any. I would appreciate any help. Thanks! Peter Teo Clickhere2 Network Pte Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading from MySQL 3.23.52 to 3.23.54
- 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 stable version. How can I do this without uninstalling my current version? I tried to look for some documentation regarding this or patches but was unable to find any. On my FreeBSD 4.7R box, I recently upgraded too, from 3.23.49 to 3.23.54a. I was lazy this time, and (oh mother of all shames) used the precompiled binary from the MySQL site. :) Worked like a charm though. Cool thing about the binary is, that it runs as is; so you could just use that one binary next to your existing distro. - Mark System Administrator Asarian-host.org --- If you were supposed to understand it, we wouldn't call it code. - FedEx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading MySQL/Solaris 2.7
-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 or should I wait for the binaries to be updated? There is a .54 release for 2.8 and 2.9 but not for 2.7. Or does this exploit not affect Solaris? Unfortunately it does affect all platforms. Sadly, our Solaris 2.7 build host has died (hardware failure) and we are currently unable to provide a 3.23.54 binary for Solaris 2.7 - sorry about that. However, I've already received a hint from a user who is using our Solaris 2.8 binary on a 2.7 system - you might want to try that first before doing a compile by yourself. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE9/4ijSVDhKrJykfIRAsOqAJ46tYXvOiNnT7I8wqiVEYToO9WrTQCeNzPs AQzcmaregampBpI8ff/B+Rs= =FVJq -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Upgrading MySQL from 3.23.41 to 3.23.53a
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 would like to upgrade MySQL to the latest production release (3.23.53a) from my current 3.23.41 I have the following packages installed already: mysql-devel-3.23.41-1 mysqlclient9-3.23.22-6 mysql-3.23.41-1 mysql-server-3.23.41-1 What do I need to do in order to upgrade to the newest version? I tried using the RPM facility to install and upgrade the new packages I just downloaded but I get conflicts... ie... [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: failed dependencies: MySQL-server conflicts with mysql-server-3.23.41-1 libmysqlclient.so.10 is needed by mysql-server-3.23.41-1 libmysqlclient.so.10 is needed by perl-DBD-MySQL-1.2216-4 [root@frodo MySQL]# So what should I do? Do I need to actually remove the old MySQL first and then install the new one? - Rick Root - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading MySQL from 3.23.41 to 3.23.53a
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: failed dependencies: MySQL-server conflicts with mysql-server-3.23.41-1 libmysqlclient.so.10 is needed by mysql-server-3.23.41-1 So what should I do? Do I need to actually remove the old MySQL first and then install the new one? You are trying to replace the redhat installed mysql with MySQL:s rpms. Do things in this order and it should work (I don't promise it will work =) 1. do a full mysqldump of all your databases. 2. shutdown and remove mysql with rpm -e your-old-package 3. Install the new mysql, start it and check if your databases are intact. Else restore from dumps. regards /Lars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Upgrading
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 under /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data in your case. Also, have you re-linked the usr/local/mysql link with the new folder? And check to make sure that the data folder is owned by MySQL and that its group is also MySQL with the correct permissions. I also found that once I installed the new MySQL, and got it working, I had to go back and recompile Apache with all the packages you need (of course making sure to add MySQL support) for it to work correctly. I don't know if this is necessary but it's how I resolved the problem. Hope this helps. -Nick 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 development in 3.22.32 (running in apache_1.3.12 on a linux kernel) I'd really like to upgrade to 3.23.49a but my installs in both rpm and binary have not succeeded in taking over from my previous install. I've read quite a bit at the mysql.com site, but haven't found the appropriate documentation ... my last attempt was by downloading MySQL-3.23.49-1.src.rpm, 0. Turn off current Web Server (/etc/rc.d/init.d/httpd stop) 1. cp MySQL-3.23.49-1.src.rpm into /usr/local 2. rpm --recompile MySQL-3.23.49-1.src.rpm 3. mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/safe_mysqld// To start MySQL use it This returns: Starting mysqld daemon with databases from /usr/local/m ysql-3.23.49a-pc-linux-gnu-i686/data 020908 15:53:33 mysqld ended And the Mysql database driven website works... Yet, when I want to go into line commands (to alter tables for easy searching) using: mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/mysql I get ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) There is no file by that name there... Well thankyou for any help :-) Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading
It means mysql does not own its directories and files. chown -R mysql /usr/local/that-long-directory-name-that-should-have-been -symlinked Richard W. Berriman wrote: The contents of the error log in mysql-3.23.49a-pc-linux-gnu-i686/data is: 020908 17:00:27 mysqld started 020908 17:00:28 /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/bin/mysqld: Can't c reate/write to file '/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data/accesscomm .ca.pid' (Errcode: 13) 020908 17:00:28 /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/bin/mysqld: Can't f ind file: './mysql/host.frm' (errno: 13) 020908 17:00:28 /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/bin/mysqld: Error o n delete of '/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data/accesscomm.ca.pid' (Errcode: 13) 020908 17:00:28 /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/bin/mysqld: Normal shutdown mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=8388600 record_buffer=131072 sort_buffer=2097144 max_used_connections=0 max_connections=100 threads_connected=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Hope that's ok, if not, decrease some variables in the equation 020908 17:00:28 mysqld ended End Log Could it be perhaps because I am installing 3.23 into a new directory? Would I be wiser to just install 4.x and be done with it? I am installing 3.23 primarily to access search capabilities...which I am now slugging out in php... Perhaps I need to reinstall the other associated packages (Apache and PHP) in order for compatibilty, but my now aging documentation for 3.22 had me test out the MySQL install before proceeding... Thanks Everyone for helping me out! I'm still hammering 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 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 under /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data in your case. Also, have you re-linked the usr/local/mysql link with the new folder? And check to make sure that the data folder is owned by MySQL and that its group is also MySQL with the correct permissions. I also found that once I installed the new MySQL, and got it working, I had to go back and recompile Apache with all the packages you need (of course making sure to add MySQL support) for it to work correctly. I don't know if this is necessary but it's how I resolved the problem. Hope this helps. -Nick 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 development in 3.22.32 (running in apache_1.3.12 on a linux kernel) I'd really like to upgrade to 3.23.49a but my installs in both rpm and binary have not succeeded in taking over from my previous install. I've read quite a bit at the mysql.com site, but haven't found the appropriate documentation ... my last attempt was by downloading MySQL-3.23.49-1.src.rpm, 0. Turn off current Web Server (/etc/rc.d/init.d/httpd stop) 1. cp MySQL-3.23.49-1.src.rpm into /usr/local 2. rpm --recompile MySQL-3.23.49-1.src.rpm 3. mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/safe_mysqld// To start MySQL use it This returns: Starting mysqld daemon with databases from /usr/local/m ysql-3.23.49a-pc-linux-gnu-i686/data 020908 15:53:33 mysqld ended And the Mysql database driven website works... Yet, when I want to go into line commands (to alter tables for easy searching) using: mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/mysql I get ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) There is no file by that name there... Well thankyou for any help :-) Richard - Before posting, please check: http://www.mysql.com
RE: Upgrading
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 development in 3.22.32 (running in apache_1.3.12 on a linux kernel) I'd really like to upgrade to 3.23.49a but my installs in both rpm and binary have not succeeded in taking over from my previous install. I've read quite a bit at the mysql.com site, but haven't found the appropriate documentation ... my last attempt was by downloading MySQL-3.23.49-1.src.rpm, 0. Turn off current Web Server (/etc/rc.d/init.d/httpd stop) 1. cp MySQL-3.23.49-1.src.rpm into /usr/local 2. rpm --recompile MySQL-3.23.49-1.src.rpm 3. mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/safe_mysqld// To start MySQL use it This returns: Starting mysqld daemon with databases from /usr/local/m ysql-3.23.49a-pc-linux-gnu-i686/data 020908 15:53:33 mysqld ended And the Mysql database driven website works... Yet, when I want to go into line commands (to alter tables for easy searching) using: mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/mysql I get ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) There is no file by that name there... Well thankyou for any help :-) Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103
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 mysql-4.0.2-alpha-win.zip into C:\mysql and the above happened I am using excessivly MyODBC to connect to M$ Access 2000 front-end. Please point me in the righrt direction as i really need to get version 4 up and running for transactions (innodb) Cheers Chuckie -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51
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 wrt upgrading: http://www.mysql.com/doc/en/Upgrading-from-3.21.html http://www.mysql.com/doc/en/Upgrading-from-3.22.html Lots of new reserved words. Lots of new features, too :) Make sure you upgrade from ISAM table format to MyISAM or InnoDB (use the mysql_convert_table_format script). -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51
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 mysqld, then install over the current directory tree? Pretty much. Make sure you run mysql_fix_privilege_tables after you start the new server, too, so you can use the extra privs. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: upgrading php for mysql support
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 please? I am currently using 4.0.6 which was installed before mysql and has no support. I have downloaded compiled and installed php 4.2.1, restarted Apache, but it continues to run the old 4.0.6. Is there a procedure I should follow or command line I dont know? Thank for the help :) -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading mysql from 3.22 to 3.23
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 to point to the new distribution, and restart. However, I was wondering what data files had to be moved across and how this might be done. At a guess, I would assume everything in the 'data' subdirectory of the old distro should be copied across (using e.g., 'cp -pR') but I also noticed that there a number of files in the root directory called 'recoftrans.XXX', where 'XXX' is a 3 digit number. Do these have to be moved as well? And is there anything else that has to be copied? Any help greatly appreciated. http://www.mysql.com/doc/U/p/Upgrading-from-3.22.html Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: upgrading mysql-3.23.48 and rpm package.
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 know if there any libc issues, though. bye michael Ireneusz Piasecki wrote: Hi all. I would upgrade my mysql serever from RPM: rpm -i MySQL-3.23.48-1.i386.rpm only packages with major numbers = 3 are supported by this version of RPM error: MySQL-3.23.48-1.i386.rpm cannot be installed What can i solve this problem. I use Red Hat 6.2 Where can i find the RPM engine to install mysql 3.23.48 ? With mysql 3.23.47 was no problem Pleas help. Regards I. Piasecki -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: upgrading mysql-3.23.48 and rpm package.
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 3.0.4 ? Try to install with a commandline like this: rpm -i -v MySQL-3.23.48-1.i386.rpm Adding -v will probably show you the cause of your trouble. IP Hi all. IP I would upgrade my mysql serever from RPM: IP rpm -i MySQL-3.23.48-1.i386.rpm IP only packages with major numbers = 3 are supported by this version of IP RPM IP error: MySQL-3.23.48-1.i386.rpm cannot be installed IP What can i solve this problem. I use Red Hat 6.2 IP Where can i find the RPM engine to install mysql 3.23.48 ? IP With mysql 3.23.47 was no problem May be you have a corrupted installation package. Try to download the MySQL 3.23.48 (rpm) again from: http://www.mysql.com/downloads/mysql-3.23.html IP Pleas help. IP Regards IP I. Piasecki -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: upgrading mysql-3.23.48 and rpm package.
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: [EMAIL PROTECTED] Sent: Monday, February 11, 2002 4:46 PM Subject: upgrading mysql-3.23.48 and rpm package. Ireneusz, Monday, February 11, 2002, 5:16:53 PM, you wrote: IP Hi all. IP I would upgrade my mysql serever from RPM: IP rpm -i MySQL-3.23.48-1.i386.rpm IP only packages with major numbers = 3 are supported by this version of RPM IP error: MySQL-3.23.48-1.i386.rpm cannot be installed IP What can i solve this problem. I use Red Hat 6.2 IP Where can i find the RPM engine to install mysql 3.23.48 ? IP With mysql 3.23.47 was no problem May be you have a corrupted installation package. Try to download the MySQL 3.23.48 (rpm) again from: http://www.mysql.com/downloads/mysql-3.23.html IP Pleas help. IP Regards IP I. Piasecki -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Tego nie znajdziesz w zadnym sklepie! [ http://oferty.onet.pl ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading from MySQL to MySQL max on a production server
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 either, but I have done exactly that on both a SuSE 7.1 server and a RedHat server, and in both cases it then started looking in /usr/local/mysql for things. Neither the SuSE box nor the RedHat box had a /usr/local/mysql directory before. Are you sure you did not change anything else in the system? I strongly assure you that I did not change the path, nor the my.cnf nor the init script nor any other thing on the whole system. Additionally, as soon as I run mv mysqld mysqld_inno ; mv mysqld_redhat mysqld I can call the init script restart and it immediately works fine again. What ever the problem is, it's hard-coded inside the mysql-max binary. I will say that I did not use the rpm, I used the tarball and copied mysqld out of the tarball's bin/ directory. Anyway, it is best that you make a new installation of MySQL-Max. The version 3.23.38 is very old and many bugs have been fixed to .46. From the manual I found a useful page: http://www.mysql.com/doc/A/u/Automatic_start.html There has been no change in MySQL table formats since .38, hence your database should run ok with .46 -Max too. For MyISAM type tables MySQL and MySQL -Max are equivalent. But if you have somehow a nonstandard installation, The SuSE installation is 100% standard SuSE, the RedHat installation is MySQL from an RPM from mysql.com, nothing edited or customized. Thanks. or have edited the startup scripts, better be prepared for some problems in starting up mysqld. Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ Hello, We're needing to use MySQL-Max because we need the functionality provided by InnoDB. According to InnoDB's web site, all I have to do is download the tarball and replace the /usr/sbin/mysqld with the mysqld in the tarball. I tried that on SuSE and I had to install a few other things and make a few symlinks too, but it did eventually work quite fine. However I was just trying that method on a redhat 7.0 production box and it doesn't work because when I call /etc/init.d/mysql start it says it can't find /usr/local/mysql/libexec/mysqld which is interesting, because I can't find any libexec directories associated with mysql on any of my linux boxes, no matter what distro. Anyway (unless someone has an answer to the libexec problem), I think I'm going to need to upgrade my whole MySQL version to a full MySQL-Max installation. Currently we're running MySQL-3.23.38-1 from an RPM from mysql.com. Our problem is that we are already using quite a few databases in our current mysql and we need to know _before_ we upgrade exactly what's going to happen to the databases we already have. Will MySQL-Max just start working with them without a hitch, or do we need to go through some sort of initialization routine? (note: we're not trying to convert our current DBs to InnoDB that is a whole separate issue. We just want to know what we'll need to to be able to continue accessing the data once we install MySQL-Max. Is it perfectly compatible with MySQL(non-max)? Just backup, install and /etc/init.d/mysql start? Or is there more to it then that? Thanks a lot. Jonathan Wilson System Administrator Cedar Creek Software http://www.cedarcreeksoftware.com Central Texas IT http://www.centraltexasit.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Jonathan Wilson System Administrator Cedar Creek Software http://www.cedarcreeksoftware.com Central Texas IT http://www.centraltexasit.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading from MySQL to MySQL max on a production server
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, it is best that you make a new installation of MySQL-Max. The version 3.23.38 is very old and many bugs have been fixed to .46. From the manual I found a useful page: http://www.mysql.com/doc/A/u/Automatic_start.html There has been no change in MySQL table formats since .38, hence your database should run ok with .46 -Max too. For MyISAM type tables MySQL and MySQL -Max are equivalent. But if you have somehow a nonstandard installation, or have edited the startup scripts, better be prepared for some problems in starting up mysqld. Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ Hello, We're needing to use MySQL-Max because we need the functionality provided by InnoDB. According to InnoDB's web site, all I have to do is download the tarball and replace the /usr/sbin/mysqld with the mysqld in the tarball. I tried that on SuSE and I had to install a few other things and make a few symlinks too, but it did eventually work quite fine. However I was just trying that method on a redhat 7.0 production box and it doesn't work because when I call /etc/init.d/mysql start it says it can't find /usr/local/mysql/libexec/mysqld which is interesting, because I can't find any libexec directories associated with mysql on any of my linux boxes, no matter what distro. Anyway (unless someone has an answer to the libexec problem), I think I'm going to need to upgrade my whole MySQL version to a full MySQL-Max installation. Currently we're running MySQL-3.23.38-1 from an RPM from mysql.com. Our problem is that we are already using quite a few databases in our current mysql and we need to know _before_ we upgrade exactly what's going to happen to the databases we already have. Will MySQL-Max just start working with them without a hitch, or do we need to go through some sort of initialization routine? (note: we're not trying to convert our current DBs to InnoDB that is a whole separate issue. We just want to know what we'll need to to be able to continue accessing the data once we install MySQL-Max. Is it perfectly compatible with MySQL(non-max)? Just backup, install and /etc/init.d/mysql start? Or is there more to it then that? Thanks a lot. Jonathan Wilson System Administrator Cedar Creek Software http://www.cedarcreeksoftware.com Central Texas IT http://www.centraltexasit.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading to MyISAM table type
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; # actually inserts a = 1; alter table crashme type=myisam; ERROR 1062 : Duplicate entry '1' for key 1 So, if you manage to set an autoincrement key to 0 in an ISAM table, alter table will always crash with a dupe key error. Before I saw your e-mail reply, which probably would have been simpler, I solved the problem by: Create a new table called job_new insert into job_new select fields_in_new_table_order from job; rename job to job_old rename job_new to job Perhaps alter table should be a bit more forgiving? Regards, Rich At 05:06 PM 10/30/01, Steve Meyers wrote: You might have a corrupt table. For 3.22 format, you'll need to use isamchk, I think... It's been a long time since I've worked with ISAM tables. Now that I look closer at your email, though, it is probably the fact that your id's start with 0, not 1. The alter table actually dumps the data into a new table. It may be inserting the 0 as a 1 (auto_increments tend to do that -- it can be annoying at times). Then the 1 fails because of the duplicate key. Seems rather silly for an alter table to do, though, so let me know what you find out. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading
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. RRK The question is what would be the best way to port my existing RRK MySQL databases? do a data dump? or just copy the MySQL files? RRK Thanx in advance for any advice on this. You need to dump databases with 'mysqldump' command. It's a safe way. read about it in mysql documentation. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 to another. Is this an ok method of transfering db? Or are there some 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 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. RRK The question is what would be the best way to port my existing RRK MySQL databases? do a data dump? or just copy the MySQL files? RRK Thanx in advance for any advice on this. You need to dump databases with 'mysqldump' command. It's a safe way. read about it in mysql documentation. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Upgrading
The db files are just like any othere. The only problmes you should have are if you try to copy the files when thay are beeing used. We have used tar and gzip with no problmes at all. I hope this helps a bit. Simon -Original Message- From: Jon Cheng [mailto:[EMAIL PROTECTED]] Sent: 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 to another. Is this an ok method of transfering db? Or are there some 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 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. RRK The question is what would be the best way to port my existing RRK MySQL databases? do a data dump? or just copy the MySQL files? RRK Thanx in advance for any advice on this. You need to dump databases with 'mysqldump' command. It's a safe way. read about it in mysql documentation. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading
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 way to port my existing MySQL databases? do a data dump? or just copy the MySQL files? if you have capacities on another machine you can use rsync to synchronize the mysql dir constantly and efficiently BTW: RH7.2beta is out and final should be released at the beginning of September; I'd wait for that short period due to some major bugfixes and releases... i.t - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Upgrading to 3.23.37 from 3.22.32
Ok but I've have chmod 777 on a couple of tables and I still receive table in read only message. Plus I was under the understanding that you only need say 700 because the mysql daemon it self would be modifying the files directly and not the client using MySQL. -Original Message- From: 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, 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 install the new one. Before I delete the old MySQL I copied all the database files to a temporary location. Once the new installation was successful I copied over all the database files into the proper location. My problem is I seem to have 3 extra tables now, A-1, A-9 and A-ce. The funny thing is they all seem to be linked to my tables. These tables to my knowledge were not present in the MySQL 3.22.32. Also I can't seem to remove the test user from mysql-db, MySQL says it's read only. I never made the table read only and doesn't seem to be. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading to 3.23.37 from 3.22.32
Dear Gerald, does mysqld run as user mysql? And does user mysql have the correct rights for datadir (e. g. /var/lib/mysql/) and all subdirectories? (The MySQL Daemon is supposed to be the only one who has rights for datadir. So, this could be 700 with user mysql as owner. No one else needs rights to this directory, as no one else will access the directories and files in datadir directly, only the daemon / server has to.) Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # 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. 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 install the new one. Before I delete the old MySQL I copied all the database files to a temporary location. Once the new installation was successful I copied over all the database files into the proper location. My problem is I seem to have 3 extra tables now, A-1, A-9 and A-ce. The funny thing is they all seem to be linked to my tables. These tables to my knowledge were not present in the MySQL 3.22.32. Also I can't seem to remove the test user from mysql-db, MySQL says it's read only. I never made the table read only and doesn't seem to be. Anyone have any ideas of what is going on? I feel kind of lost now, any help would be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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, 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 install the new one. Before I delete the old MySQL I copied all the database files to a temporary location. Once the new installation was successful I copied over all the database files into the proper location. My problem is I seem to have 3 extra tables now, A-1, A-9 and A-ce. The funny thing is they all seem to be linked to my tables. These tables to my knowledge were not present in the MySQL 3.22.32. Also I can't seem to remove the test user from mysql-db, MySQL says it's read only. I never made the table read only and doesn't seem to be. Anyone have any ideas of what is going on? I feel kind of lost now, any help would be greatly appreciated. -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading mysql on Win2K
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 servers, one a master and one a slave. Does this make a difference? No. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading to 3.23.37 from 3.22.32
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 installation was successful I copied over all the database files into the proper location. My problem is I seem to have 3 extra tables now, A-1, A-9 and A-ce. The funny thing is they all seem to be linked to my tables. These tables to my knowledge were not present in the MySQL 3.22.32. Also I can't seem to remove the test user from mysql-db, MySQL says it's read only. I never made the table read only and doesn't seem to be. Anyone have any ideas of what is going on? I feel kind of lost now, any help would be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Upgrading to 3.23.37 from 3.22.32
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 install the new one. Before I delete the old MySQL I copied all the database files to a temporary location. Once the new installation was successful I copied over all the database files into the proper location. My problem is I seem to have 3 extra tables now, A-1, A-9 and A-ce. The funny thing is they all seem to be linked to my tables. These tables to my knowledge were not present in the MySQL 3.22.32. Also I can't seem to remove the test user from mysql-db, MySQL says it's read only. I never made the table read only and doesn't seem to be. Anyone have any ideas of what is going on? I feel kind of lost now, any help would be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Upgrading MySQL on Windows Platform
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 should run or should I just re-install the latest version 3.23.39. Will it overwrite the old version automatically while preserving all the tables and databases? Please help. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading MySQL on Windows Platform
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 overwrite the old version automatically while preserving all the tables and databases? Please help. Thanks. The databases aren't overwrite. However before to run the setup, in the today distribution delete the older share directory for the err files to be updated. This distribution should be changed by one identify by the mysql-3.23.39a-win.zip. However, is always a good safe to make the backup of the databases, to avoid problem outside of the setup program. Regards, Miguel Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading RPM 3.23.33 to 3.23.34
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 upgrade an RPM installation of MySQL? Can I just run rpm -U 3.23.34-1.i386 and it will take care of the upgrade or is there another way? Also, should I bring down the server before attempting an upgrade? Is it likely I'll have to rebuild PHP or Apache after the upgrade? I'd appreciate any advice from the MySQL sages... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading MySQL causes Error - ASP
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 software. Now my site is running under Win2K, IIS5,
MySQL 3.23.33 and MyODBC 2.50.36.
In order to get easier to explain what is going wrong, I've built the
following test:
CREATE TABLE person (
person_ID INTEGER NULL,
name CHAR(50) NULL,
gender CHAR(1) NULL
);
INSERT INTO person (person_id, name, gender) values
(1,'Bob','m'),(2,'Mary','f'),(3,'Antony','m'),(4,'Rose','f'),(5,'Kuerten','m');
mysql select count(*) as quantity, gender
- from person
- group by gender;
+--++
| quantity | gender |
+--++
|2 | f |
|3 | m |
+--++
2 rows in set (0.01 sec)
*** As you can realize, so far so good. Now things get worse ***
html
head
titleGROUP BY TEST/title
/head
body bgcolor="#FF"
%
Response.Write "Beginbr"
strConn =
"DRIVER=MySQL;SERVER=myserver;DATABASE=mydatabase;UID=myuser;PWD=mypass;"
Set conn = Server.Createobject("ADODB.Connection")
conn.Open(strConn)
strSQL = "select count(*) as quantity, gender "
strSQL = strSQL "from person "
strSQL = strSQL "group by gender;"
Response.Write strSQL "BR"
Set Rs = conn.Execute(strSQL)
While Not Rs.EOF
Response.Write "Quantity: " RS("quantity") " - Gender: "
RS("gender") "BR"
Rs.MoveNext
Wend
Rs.Close
conn.close
response.write "The Endbr"
%
/body
/html
*** The page above should print:
Begin
select count(*) as quantity, gender from person group by gender;
Quantity: 2 - Gender: f
Quantity: 3 - Gender: m
The End
*** Instead, I'm getting this:
Begin
select count(*) as quantity, gender from person group by gender;
The End
*** It means that the record set is empty.
Thank you very much for any help.
Regards,
Celso.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading MySQL causes Error - ASP
Gerald,
I've written to them asking your question.
I'd like to point out that I just got an empty record set when it is running
under ASP.
The query runs successfully through phpMyAdmin 2.0.5. I realized that the
query
(select count(*) as quantity from person;) works well in ASP so that I think
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
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 software. Now my site is running under Win2K,
IIS5,
MySQL 3.23.33 and MyODBC 2.50.36.
In order to get easier to explain what is going wrong, I've built the
following test:
CREATE TABLE person (
person_ID INTEGER NULL,
name CHAR(50) NULL,
gender CHAR(1) NULL
);
INSERT INTO person (person_id, name, gender) values
(1,'Bob','m'),(2,'Mary','f'),(3,'Antony','m'),(4,'Rose','f'),(5,'Kuerten','m
');
mysql select count(*) as quantity, gender
- from person
- group by gender;
+--++
| quantity | gender |
+--++
|2 | f |
|3 | m |
+--++
2 rows in set (0.01 sec)
*** As you can realize, so far so good. Now things get worse ***
html
head
titleGROUP BY TEST/title
/head
body bgcolor="#FF"
%
Response.Write "Beginbr"
strConn =
"DRIVER=MySQL;SERVER=myserver;DATABASE=mydatabase;UID=myuser;PWD=mypass;"
Set conn = Server.Createobject("ADODB.Connection")
conn.Open(strConn)
strSQL = "select count(*) as quantity, gender "
strSQL = strSQL "from person "
strSQL = strSQL "group by gender;"
Response.Write strSQL "BR"
Set Rs = conn.Execute(strSQL)
While Not Rs.EOF
Response.Write "Quantity: " RS("quantity") " - Gender: "
RS("gender") "BR"
Rs.MoveNext
Wend
Rs.Close
conn.close
response.write "The Endbr"
%
/body
/html
*** The page above should print:
Begin
select count(*) as quantity, gender from person group by gender;
Quantity: 2 - Gender: f
Quantity: 3 - Gender: m
The End
*** Instead, I'm getting this:
Begin
select count(*) as quantity, gender from person group by gender;
The End
*** It means that the record set is empty.
Thank you very much for any help.
Regards,
Celso.
_
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading
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 distribution, ie. you'd have to recompile to get the new version. Try searching for a file that's named similarly, but without the 'src'. Regards, Jan-Aage -- Mr. Jan-Aage Bruvoll Managing Director Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK Office: +442072408283 Cell: +4792492482 Fax: +4792571158 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading
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 d'l the distro, go in as root (Apache, RedHat) and enter the following command: # rpm -U MySQL-3.23.32-1.src.rpm When I do I get no error messages, but no upgrade seems to occur (i.e., I get the old version number at the mysql prompt). How am I supposed to do the upgrade? TIA, BenO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
