How often should we upgrade MySQL version
We are running MySQL 5.1.46 with master to master replication with 3 other servers for 3 different websites in 3 different parts of the world. My question is how often should we be looking to upgrade our MySQL version considering we can't really afford any downtime. Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: How often should we upgrade MySQL version
Ever heard the old saying, If it ain't broke, don't fix it. ;-) I'd say that as a general rule: 1. if you aren't experiencing problems then don't upgrade. 2. if you aren't subject to any vulnerabilities that may be found, then don't upgrade 3. if you don't need a new feature introduced, then don't upgrade 4. if you need to be up 100%, then don't upgrade Having said that, it is possible to upgrade with minimal downtime if you're smart about it. Get another server (or two or three) that is a clone of the existing ones. Upgrade those. Test those. Swap over. Then for the next release, do the same thing with the servers you now have as the spares. If you're in such a mission critical situation, you should have spare servers and live hot-swapable backups anyways right. -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: Friday, November 18, 2011 11:54 AM To: MySQL ML Subject: How often should we upgrade MySQL version We are running MySQL 5.1.46 with master to master replication with 3 other servers for 3 different websites in 3 different parts of the world. My question is how often should we be looking to upgrade our MySQL version considering we can't really afford any downtime. Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=dae...@daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How often should we upgrade MySQL version
I love the answer On Fri, Nov 18, 2011 at 10:59 PM, Daevid Vincent dae...@daevid.com wrote: Ever heard the old saying, If it ain't broke, don't fix it. ;-) I'd say that as a general rule: 1. if you aren't experiencing problems then don't upgrade. 2. if you aren't subject to any vulnerabilities that may be found, then don't upgrade 3. if you don't need a new feature introduced, then don't upgrade 4. if you need to be up 100%, then don't upgrade Having said that, it is possible to upgrade with minimal downtime if you're smart about it. Get another server (or two or three) that is a clone of the existing ones. Upgrade those. Test those. Swap over. Then for the next release, do the same thing with the servers you now have as the spares. If you're in such a mission critical situation, you should have spare servers and live hot-swapable backups anyways right. -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: Friday, November 18, 2011 11:54 AM To: MySQL ML Subject: How often should we upgrade MySQL version We are running MySQL 5.1.46 with master to master replication with 3 other servers for 3 different websites in 3 different parts of the world. My question is how often should we be looking to upgrade our MySQL version considering we can't really afford any downtime. Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=dae...@daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=muadshib...@gmail.com -- *___* * * السجل .. كل الأخبار من كل مكان www.alsjl.com صفحة السجل على فيسبوك http://www.facebook.com/alsjl *Muad Shibani* * * Aden Yemen Mobile: 00967 733045678 www.muadshibani.com
Re: Upgrade Mysql
Thank You for all the help. I was upgrading from 4.0.x to 5.0.x The new mysql recognized the old databases without problems. Bye :)
Upgrade Mysql
Hi, I need to upgrade Mysql 4 to Mysql 5 on Linux. I will uninstall version 4 and install version 5. With uninstallation usually database files remain in /var/lib/mysql/ I want to know if with the installation of Mysql 5 those database will be recognized and imported to work with the new version automatically. Thank You.
Re: Upgrade Mysql
On May 20, 2009, at 1:27 AM, Webmaster Studio Informatica wrote: I need to upgrade Mysql 4 to Mysql 5 on Linux. Sometimes I will uninstall version 4 and install version 5. With uninstallation usually database files remain in /var/lib/mysql/ I want to know if with the installation of Mysql 5 those database will be recognized and imported to work with the new version automatically. In most cases, but you should have a database dump of all of them just in case. You do not specify what version of 4 you are at. You need to at least read this: http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html Specifically look at Incompatible change, there are quote a few. Most will not bother you. For me, the biggest issue was my use of timestamp, and how that changed a bit. Luckily I had a function that I used in my code to format that timestamp value, so it was just a matter of going through all my code and updating one function to all sites. This was also only a display issue for me and did not change my data. You do have to know your code. If you do not, I would use a staging server, and do them one database at a time, test, make sure it works, and go from there. -- Scott * If you contact me off list replace talklists@ with scott@ * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Upgrade Mysql
On Wed, May 20, 2009 at 10:27:51AM +0200, Webmaster Studio Informatica wrote: Hi, I need to upgrade Mysql 4 to Mysql 5 on Linux. I will uninstall version 4 and install version 5. With uninstallation usually database files remain in /var/lib/mysql/ I want to know if with the installation of Mysql 5 those database will be recognized and imported to work with the new version automatically. Thank You. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Your best path is to If 4.0, Compile 4.1 Follow upgrade procedure If 4.1 Compile 5.0 Follow upgrade procedure If 5.0 Compile 5.1 Follow upgrade procedure. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Upgrade Mysql
Hi, I don't know what Linux distro you're using, but I'd make a backup of /var/lib/mysql dir before you do anything (in case the mysql package decides to nuke your stuff). If you have a dump of your dbs, that's fine too. And maybe a backup of your my.cnf. Just install the new mysql package, then start it. Then you'll need to run mysqlupgrade. Depending on the size of your database and type of tables you are using it can take a while. For InnoDB tables, for example, upgrade simply means copy to tmp table... that's really slow if you have a large table. Once mysqlupgrade runs without a hitch, you should be back in business. -Paul Webmaster Studio Informatica wrote: Hi, I need to upgrade Mysql 4 to Mysql 5 on Linux. I will uninstall version 4 and install version 5. With uninstallation usually database files remain in /var/lib/mysql/ I want to know if with the installation of Mysql 5 those database will be recognized and imported to work with the new version automatically. Thank You. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Upgrade Mysql
I already posted about this: http://lists.mysql.com/mysql/215100 or google for moving from 3.23.58 to 5.0.45 I never recommend to install mysql as default package, is way too limiting. I manage to have as many mysql installations on the same server as the hardware can carry, but not software conflict. Always install mysql in custom way: http://lists.mysql.com/mysql/211957 Cheers Claudio 2009/5/20 Paul Choi paulc...@plaxo.com Hi, I don't know what Linux distro you're using, but I'd make a backup of /var/lib/mysql dir before you do anything (in case the mysql package decides to nuke your stuff). If you have a dump of your dbs, that's fine too. And maybe a backup of your my.cnf. Just install the new mysql package, then start it. Then you'll need to run mysqlupgrade. Depending on the size of your database and type of tables you are using it can take a while. For InnoDB tables, for example, upgrade simply means copy to tmp table... that's really slow if you have a large table. Once mysqlupgrade runs without a hitch, you should be back in business. -Paul Webmaster Studio Informatica wrote: Hi, I need to upgrade Mysql 4 to Mysql 5 on Linux. I will uninstall version 4 and install version 5. With uninstallation usually database files remain in /var/lib/mysql/ I want to know if with the installation of Mysql 5 those database will be recognized and imported to work with the new version automatically. Thank You. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
Re: upgrade mysql 3.23.58 to 4.1
Hassan Schroeder wrote: mm wrote: There is a lot a pain here. I downloaded the rpm packages that's where the pain starts :-) If you're trying to run multiple versions of MySQL for pre-migration testing (or whatever), *don't use rpms* -- get the tar file of the binary, and just untar it as /usr/local/mysql-4.1.12 or whatever. It will be *so* much simpler to switch between the old and new, or run them simultaneously as needed. FWIW! Thanks a lot. Now I have 2 folders with 4.0 and 4.1 distribution. (/usr/local/mysql40, /usr/local/mysql41) They said to upgrade from 3.23 to 4.0 and then from 4.0 to 4.1 2.7 Installing MySQL on Other Unix-Like Systems ... 6. If you haven't installed MySQL before, you must create the MySQL grant tables: what about 'Else' ? --- Finally I did start the server and mysql 4.0 with my database. I did this by running my script mount-mysql [EMAIL PROTECTED] mircea]# ./mount-mysql [EMAIL PROTECTED] mircea]# Starting mysqld daemon with databases from /var/lib/mysql mount-mysql: mount --bind /mnt/120GB/mysql5 /var/lib/mysql cd /usr/local/mysql40 ; /usr/local/mysql40/bin/safe_mysqld [EMAIL PROTECTED] ~]$ /usr/local/mysql40/bin/mysql -u mircea -psome_pass -S/var/lib/mysql/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.0.24-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql Now, as I am yang in Linux, wish to understand what it is all about in: mysql_install_db mysql.server mysql_setpermission mysqld_safe safe_mysqld mysqlaccess mysqlbug I have to read about bash suppose. Thank you Hassan, Kishore, Gleb, and others for your help! mt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade mysql 3.23.58 to 4.1
Hi,
There is a lot a pain here.
I downloaded the rpm packages
MySQL-server-4.1.12-1.i386.rpm
MySQL-shared-4.1.12-1.i386.rpm
MySQL-bench-4.1.12-1.i386.rpm
MySQL-shared-compat-4.1.11-0.i386.rpm
MySQL-client-4.1.12-1.i386.rpm
MySQL-devel-4.1.12-1.i386.rpm
MySQL-embedded-4.1.12-1.i386.rpm
MySQL-Max-4.1.12-1.i386.rpm
Maximum RPM said:
---
rpm -qp --queryformat %{defaultprefix}\n packagefile
Just replace packagefile with the name of the package file you want to
check out. If the package is not relocatable, you'll only see the word
(none).
This doesn't work.
--
[EMAIL PROTECTED] MySQL]$ rpm -qp --queryformat %{defaultprefix}\n
MySQL-Max-4.1.12-1.i386.rpm
warning: MySQL-Max-4.1.12-1.i386.rpm: V3 DSA signature: NOKEY, key ID
5072e1f5
error: incorrect format: unknown tag
The MD5 check sum was OK bat Signature Checking Using RPM was not.
---
My Linux experience is short so I have to read a lot for every movement.
If you can gave me more help ti will be easier for me.
Thanks,
MT
Kishore Jalleda wrote:
Yes You can have both versions, infact this is the preferred way to
upgrade, but the only thing is that have the new version install in
/usr/local/mysql2/ or what ever you want and change the port that the
newer daemon listens on instead of the default 3306, here's a good
link from the doc's of mysql...
http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html
Hope this helps,
Kishore Jalleda
On 6/24/05, mm [EMAIL PROTECTED] wrote:
I have on my system, Fedora core 3, MySql 3.23.58
Working with wikipedia database I get one error an one advise to upgrade
to Mysql 4.xx
Can I have old mySQL and the new one on my system?
It is necessary to recreate databases and reload the data?
What other kind of problem is suppose to find on my way during upgrade?
Thanks,
MT
--
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: upgrade mysql 3.23.58 to 4.1
Selon mm [EMAIL PROTECTED]:
Hi,
There is a lot a pain here.
I downloaded the rpm packages
MySQL-server-4.1.12-1.i386.rpm
MySQL-shared-4.1.12-1.i386.rpm
MySQL-bench-4.1.12-1.i386.rpm
MySQL-shared-compat-4.1.11-0.i386.rpm
MySQL-client-4.1.12-1.i386.rpm
MySQL-devel-4.1.12-1.i386.rpm
MySQL-embedded-4.1.12-1.i386.rpm
MySQL-Max-4.1.12-1.i386.rpm
Maximum RPM said:
---
rpm -qp --queryformat %{defaultprefix}\n packagefile
Just replace packagefile with the name of the package file you want to
check out. If the package is not relocatable, you'll only see the word
(none).
This doesn't work.
--
[EMAIL PROTECTED] MySQL]$ rpm -qp --queryformat %{defaultprefix}\n
MySQL-Max-4.1.12-1.i386.rpm
warning: MySQL-Max-4.1.12-1.i386.rpm: V3 DSA signature: NOKEY, key ID
5072e1f5
error: incorrect format: unknown tag
The MD5 check sum was OK bat Signature Checking Using RPM was not.
---
My Linux experience is short so I have to read a lot for every movement.
If you can gave me more help ti will be easier for me.
Thanks,
MT
Kishore Jalleda wrote:
Yes You can have both versions, infact this is the preferred way to
upgrade, but the only thing is that have the new version install in
/usr/local/mysql2/ or what ever you want and change the port that the
newer daemon listens on instead of the default 3306, here's a good
link from the doc's of mysql...
http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html
Hope this helps,
Kishore Jalleda
On 6/24/05, mm [EMAIL PROTECTED] wrote:
I have on my system, Fedora core 3, MySql 3.23.58
Working with wikipedia database I get one error an one advise to upgrade
to Mysql 4.xx
Can I have old mySQL and the new one on my system?
It is necessary to recreate databases and reload the data?
What other kind of problem is suppose to find on my way during upgrade?
Thanks,
MT
--
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]
Hi, if you transfered them from windows to linux with ftp without binary, that
should be the reason.
just retransfer using binary mode.
ELse, i can't see.
have you tried an install of one of them ?
Hope that helps
:o)
Mathias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade mysql 3.23.58 to 4.1
mm wrote: There is a lot a pain here. I downloaded the rpm packages that's where the pain starts :-) If you're trying to run multiple versions of MySQL for pre-migration testing (or whatever), *don't use rpms* -- get the tar file of the binary, and just untar it as /usr/local/mysql-4.1.12 or whatever. It will be *so* much simpler to switch between the old and new, or run them simultaneously as needed. FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
upgrade mysql 3.23.58 to 4.1
I have on my system, Fedora core 3, MySql 3.23.58 Working with wikipedia database I get one error an one advise to upgrade to Mysql 4.xx Can I have old mySQL and the new one on my system? It is necessary to recreate databases and reload the data? What other kind of problem is suppose to find on my way during upgrade? Thanks, MT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade mysql 3.23.58 to 4.1
Yes You can have both versions, infact this is the preferred way to upgrade, but the only thing is that have the new version install in /usr/local/mysql2/ or what ever you want and change the port that the newer daemon listens on instead of the default 3306, here's a good link from the doc's of mysql... http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html Hope this helps, Kishore Jalleda On 6/24/05, mm [EMAIL PROTECTED] wrote: I have on my system, Fedora core 3, MySql 3.23.58 Working with wikipedia database I get one error an one advise to upgrade to Mysql 4.xx Can I have old mySQL and the new one on my system? It is necessary to recreate databases and reload the data? What other kind of problem is suppose to find on my way during upgrade? Thanks, MT -- 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: upgrade mysql 3.23.58 to 4.1
Hello. Read: http://dev.mysql.com/doc/mysql/en/upgrade.html http://dev.mysql.com/doc/mysql/en/multiple-servers.html And search in archives about possible troubleshooting: http://lists.mysql.com/mysql/ mm [EMAIL PROTECTED] wrote: I have on my system, Fedora core 3, MySql 3.23.58 Working with wikipedia database I get one error an one advise to upgrade to Mysql 4.xx Can I have old mySQL and the new one on my system? It is necessary to recreate databases and reload the data? What other kind of problem is suppose to find on my way during upgrade? Thanks, MT -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
Upgrade MySQL and replication dies
I use Debian Sarge as my Linux distribution on two servers who replicate MySQL. Every time I upgrade the MySQL package my replication dies. Any ideas why? Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrade MySQL and replication dies
Hello. Does Debian package preserve a master.info and relay-log.info files? Do you stop slave before the upgrade? What does the 'SHOW SLAVE STATUS' statement report? Jacob Friis Larsen [EMAIL PROTECTED] wrote: I use Debian Sarge as my Linux distribution on two servers who replicate MySQL. Every time I upgrade the MySQL package my replication dies. Any ideas why? Thanks, Jacob -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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: Upgrade MySQL and replication dies
Does Debian package preserve a master.info and relay-log.info files? I'll check with some Debian experts. Do you stop slave before the upgrade? No. What does the 'SHOW SLAVE STATUS' statement report? Before that everything is ok, after I don't know now that it is running ok, but I'll check next time. Thanks, Jacob Jacob Friis Larsen [EMAIL PROTECTED] wrote: I use Debian Sarge as my Linux distribution on two servers who replicate MySQL. Every time I upgrade the MySQL package my replication dies. Any ideas why? Thanks, Jacob -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fedora Core 2: upgrade mysql 3 to mysql 4
Hello. I want to upgrade mysql 3 to mysql 4. At first, you should read: http://dev.mysql.com/doc/mysql/en/upgrade.html Search the MySQL lists archives about possible problems which you can expect. It is strongly recommended to make a backup. How to remove mysql3 and install mysql 4? It depends on what kind of distribution you have. Probably rpm -U would help for the rpm distribution. Jerry Swanson [EMAIL PROTECTED] wrote: I want to upgrade mysql 3 to mysql 4. Operating System is Fedore Core 2. Is there any package dependency? How to remove mysql3 and install mysql 4? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
Fedora Core 2: upgrade mysql 3 to mysql 4
I want to upgrade mysql 3 to mysql 4. Operating System is Fedore Core 2. Is there any package dependency? How to remove mysql3 and install mysql 4? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to upgrade mysql from 3.20 to 3.23
Dear All, I want to upgrade my mysql ver 3.20.32a-3 on my Red Hat linux 6.2 machine to mysql 3.23 version. Presently i have glib-1.2.6-3 and libc-5.3.12-3.1. How can i upgrade to version 3.23. thanks in advance sankalap -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to upgrade mysql from 3.20 to 3.23
Dear All, I want to upgrade my mysql ver 3.20.32a-3 on my Red Hat linux 6.2 machine to mysql 3.23 version. Presently i have glib-1.2.6-3 and libc-5.3.12-3.1. How can i upgrade to version 3.23. thanks in advance sankalap -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to Upgrade MySQL 3.23 to MySQL 4.0
Hi All, I have a dependency problem in libmysqlclient.so.10 when I try to install MySQL 4.0 (rpm downloaded from www.mysql.com) This is a Redhat 8.0 system (original rpm install) If I perform a rpm -e mysql* it will tell me there's a dependency for libmysqlclient.so.10 for perl-DBD-mysql. Can anyone please let me know how I can upgrade or I need to compile it on my own or ??? Pls Help. Cheers, Mun Heng, Ow H/M Engineering Western Digital M'sia DID : 03-7870 5168
upgrade mySQL
Greetings I'm currently upgrading mySQL v3.23 to mySQL v4.0, the installation of v4.0 was a success,I tried to execute mysql_fix_privilege_tables c:\mysql\binmysql -e mysql_fix_privilege_tables but i keep on getting the error: ERROR 1064 at line 1: You have an error in your SQL syntax. Check the manual that corresponds to your mySQL server version for the right syntax to use near 'mysql_fix_privilege_tables' at line 1 what is the right way of running this script? OS: win98se mySQL: version 4.0.9 -gamma winMySQLAdmin 1.4: started lewell The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - 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: upgrade mySQL
Lewell, ERROR 1064 at line 1: You have an error in your SQL syntax. Check the manual that corresponds to your mySQL server version for the right syntax to use near 'mysql_fix_privilege_tables' at line 1 The script your speaking of is a Unix shell script, and there is nothing like that in the Windows binary dist, AFAIK. The MySQL 4.0.x setup should set up the new privileges (privilege tables), too. I guess this will only happen when you delete / rename your old mysql database beforehand. I'll send Cc: to Miguel who is in care of setting up the dists at MySQL AB, AFAIK. He should know what to do best to change the priv tables to have the new privs available. 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: pazenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 1:18 PM Subject: upgrade mySQL Greetings I'm currently upgrading mySQL v3.23 to mySQL v4.0, the installation of v4.0 was a success,I tried to execute mysql_fix_privilege_tables c:\mysql\binmysql -e mysql_fix_privilege_tables but i keep on getting the error: ERROR 1064 at line 1: You have an error in your SQL syntax. Check the manual that corresponds to your mySQL server version for the right syntax to use near 'mysql_fix_privilege_tables' at line 1 what is the right way of running this script? OS: win98se mySQL: version 4.0.9 -gamma winMySQLAdmin 1.4: started lewell The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - 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: upgrade mySQL
In the last episode (Jan 25), pazenko said: I'm currently upgrading mySQL v3.23 to mySQL v4.0, the installation of v4.0 was a success,I tried to execute mysql_fix_privilege_tables c:\mysql\binmysql -e mysql_fix_privilege_tables but i keep on getting the error: ERROR 1064 at line 1: You have an error in your SQL syntax. Check the manual that corresponds to your mySQL server version for the right syntax to use near 'mysql_fix_privilege_tables' at line 1 what is the right way of running this script? I don't know if there's a windows version if it. It's a shell script. If you have cygwin installed, try running sh mysql_fix_privilege_tables -- 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
Just being prudent - upgrade MySql v3.23 to v4.0.2
Still haven't recieved a simple answer when i unzip the mysql-4.0.2-alpha-win.zip Do i simply extract into C:\mysql Folder and override everthing . as i have working db's so i just would like confirmation prior to proceeding. The MySql Doc's don't clarify this I assume you do but i thought i'll remain prudent. Plz confirm ASAP as I have another MySql Project that'll conbine Transactions (Innodb) Table TimeStamp datatype field for all the Project Tables . -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - 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: Just being prudent - upgrade MySql v3.23 to v4.0.2
Please see http://www.mysql.com/downloads/mysql-4.0.html, specifically the link for You can find how to upgrade from MySQL 3.23 Here (http://www.mysql.com/doc/en/Upgrading-from-3.23.html) ... In general what you have to do when upgrading to 4.0 from an earlier MySQL version: Run the mysql_fix_privilege_tables to add new privileges and features to the MySQL privilege tables. Edit any MySQL startup scripts or configure files to not use any of the deprecated options listed below. Convert your old ISAM files to MyISAM files with the command: mysql_convert_table_format database. Note that this should only be run if all tables in the given database is ISAM or MyISAM tables. If this is not the case you should run ALTER TABLE table_name TYPE=MyISAM on all ISAM tables. Ensure that you don't have any MySQL clients that uses shared libraries (like the perl Msql-Mysql-modules). If you have, you should recompile them as structures used in `libmysqlclient.so' have changed. ... HTH, Dw. -Original Message- From: Chuck Amadi [mailto:[EMAIL PROTECTED]] Sent: 02 September 2002 08:02 To: [EMAIL PROTECTED] Subject: Just being prudent - upgrade MySql v3.23 to v4.0.2 Still haven't recieved a simple answer when i unzip the mysql-4.0.2-alpha-win.zip Do i simply extract into C:\mysql Folder and override everthing . as i have working db's so i just would like confirmation prior to proceeding. The MySql Doc's don't clarify this I assume you do but i thought i'll remain prudent. Plz confirm ASAP as I have another MySql Project that'll conbine Transactions (Innodb) Table TimeStamp datatype field for all the Project Tables . -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - 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: Just being prudent - upgrade MySql v3.23 to v4.0.2
At 10:20 -0700 9/2/02, Sqlcoders.com Programming Dept wrote: Please see http://www.mysql.com/downloads/mysql-4.0.html, specifically the link for You can find how to upgrade from MySQL 3.23 Here (http://www.mysql.com/doc/en/Upgrading-from-3.23.html) ... In general what you have to do when upgrading to 4.0 from an earlier MySQL version: Run the mysql_fix_privilege_tables to add new privileges and features to the MySQL privilege tables. That doesn't help much for Windows, which has no mysql_fix_privilege_tables script. Edit any MySQL startup scripts or configure files to not use any of the deprecated options listed below. Convert your old ISAM files to MyISAM files with the command: mysql_convert_table_format database. Note that this should only be run if all tables in the given database is ISAM or MyISAM tables. If this is not the case you should run ALTER TABLE table_name TYPE=MyISAM on all ISAM tables. Ensure that you don't have any MySQL clients that uses shared libraries (like the perl Msql-Mysql-modules). If you have, you should recompile them as structures used in `libmysqlclient.so' have changed. ... HTH, Dw. -Original Message- From: Chuck Amadi [mailto:[EMAIL PROTECTED]] Sent: 02 September 2002 08:02 To: [EMAIL PROTECTED] Subject: Just being prudent - upgrade MySql v3.23 to v4.0.2 Still haven't recieved a simple answer when i unzip the mysql-4.0.2-alpha-win.zip Do i simply extract into C:\mysql Folder and override everthing . as i have working db's so i just would like confirmation prior to proceeding. The MySql Doc's don't clarify this I assume you do but i thought i'll remain prudent. Plz confirm ASAP as I have another MySql Project that'll conbine Transactions (Innodb) Table TimeStamp datatype field for all the Project Tables . -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - 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: How to upgrade MySql?
Hong, Thursday, May 02, 2002, 10:22:56 PM, you wrote: HT We have a Web server with Apache 1.3.22+MySql 3.23.44+php 4.0.6 HT on Solaris 8. Now we want to upgrade MySql to latest version. HT Should I re-compile both Apache, MySql, and PHP or just re-compile HT MySql? The question is how to upgrade MySql on Apache server with HT multi-application? If you want to upgrade MySQL to v3.23.XX you may leave Apache and PHP intact. HT TIA -- 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
How to upgrade MySql?
Hi, We have a Web server with Apache 1.3.22+MySql 3.23.44+php 4.0.6 on Solaris 8. Now we want to upgrade MySql to latest version. Should I re-compile both Apache, MySql, and PHP or just re-compile MySql? The question is how to upgrade MySql on Apache server with multi-application? TIA - 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
FW: How to upgrade MySql?
Hi, We have a Web server with Apache 1.3.22+MySql 3.23.44+php 4.0.6 on Solaris 8. Now we want to upgrade MySql to latest version. Should I re-compile both Apache, MySql, and PHP or just re-compile MySql? The question is how to upgrade MySql on Apache server with multi-application? TIA - 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
Upgrade MySQL
Joey, Saturday, February 02, 2002, 8:16:21 PM, you wrote: JF Dear all, JF I am running MySQL 3.22.xx at Mandrake 8.1, how can I JF grade my MySQL?? Please, find your answers at: http://www.mysql.com/doc/U/p/Upgrade.html JF Thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
Upgrade MySQL
Dear all, I am running MySQL 3.22.xx at Mandrake 8.1, how can I grade my MySQL?? 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: Upgrade MySQL
Hi, - Original Message - From: Michael Tam [EMAIL PROTECTED] I am using MySQL 3.23.41 under Win2000. I wonder what is the easiest way to upgrade the MySQL to 3.23.46 with my existing data and grant table? From what I see is that I need to dump the data tables as files, uninstall the service, uninstall MySQL ( with the my.ini remains in the system folder). Then install the latest version import the data back and manually set the grant tables again. am I write about this?? No. Well, it's always good to make a backup! But you can simply stop the service (no need to uninstall the service or mysql), and run the setup.exe of the new version. Then you can start the service again. It's that easy. Regards, Arjen. -- 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
How to upgrade mysql version on linux
hi we are using two different servers for our operation. unfortunately they have installed two different version of mysql. on one server we are using 3.22.32 ( mysqldump 7.1 ) on another server we are using 3.23.23 ( mysqldump 8.8 ) i want to know how to update the two versions to the present latest versions. this is why because i wnat transfer the database to only one server. i tried with mysqldump option,but when i try to install to get inot another server. i is dumping. i think due to version problem. if any one has solution, let me know. Regards and thanks. Bharat Kumar, SurgoSystems (Singapore) 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
Re: Upgrade MySQL
Regarding the upgrading posting I posted, I must install the upgrade in the same data dir as the current version or else our customer WebHosting Manager browser interface will not work properly when access their database's . The current data dir install is /var/lib/mysql. Now when you install the binary distro, you can specify where you want to install,..correct?? I didn't notice any options settings like that are used with the source distro install. How do I specify where I want the binary install to go?? THX's [EMAIL PROTECTED] wrote: Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. Any suggestion would be much appreciated :) Use the MySQL-MAX binary from mysql.com rather than building your own. thanks Jeremy, appreciate the feedback. Would I just follow the Quick Install for the binary. I've only installed MySQL with the source in the past. Can you just briefly touch on why the binary is better then using the source?? :) The binary is known to be good (or at least known). It is a static binary built with a specific compiler, specific compiler options, and specificly tuned libraries. The MySQL team has put a lot of working into getting it right so that the rest of us don't have to. If you run into a problem using their binary, it's often easier for them to track down what went wrong. If you build it yourself and have problems, they have to rule out things which may be related to how you built the binary. Plus, the binary is a piece of cake to install. I use the binary tarballs, since I'm not an RPM fan. Just untar it and have a look at the installation notes. But you may (or may not) want to wait for 3.23.40 which will be out soon, I believe. Jeremy Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: Upgrade MySQL
I have one other question, does it make a difference where you put the tar.gz file on the server before you untar it for the install?? Does this have a bearing on the installation, when you using the binary install?? On Thu, 19 Jul 2001 15:50:13 -0700, Jeremy Zawodny [EMAIL PROTECTED] wrote: The only databases currently are the default 'test' and the 'mysql' db's no other db's created. The current variables show: basedir/ datadir /var/lib/mysql My question is, when upgrading and to replace the current version, I assume I would need to install using the paths,..correct?? You can. Or you can install anywehere else and just copy the data files from /var/lib/mysql to the new data dir when your're done. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: Upgrade MySQL
On Sat, Jul 21, 2001 at 04:21:35PM -0500, MikemickaloBlezien wrote: I have one other question, does it make a difference where you put the tar.gz file on the server before you untar it for the install?? Does this have a bearing on the installation, when you using the binary install?? It doesn't matter, no. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 35 days, processed 271,979,567 queries (88/sec. avg) - 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: Upgrade MySQL
? - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: MikemickaloBlezien [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, July 22, 2001 12:31 AM Subject: Re: Upgrade MySQL On Sat, Jul 21, 2001 at 04:21:35PM -0500, MikemickaloBlezien wrote: I have one other question, does it make a difference where you put the tar.gz file on the server before you untar it for the install?? Does this have a bearing on the installation, when you using the binary install?? It doesn't matter, no. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 35 days, processed 271,979,567 queries (88/sec. avg) - 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
Upgrade MySQL
Hi All, I need to upgrade a server running MySQL v.3.23.38 to .39 Specs: RedHat/Linux 6.2 i386 512RAM The only databases currently are the default 'test' and the 'mysql' db's no other db's created. The current variables show: basedir/ datadir /var/lib/mysql My question is, when upgrading and to replace the current version, I assume I would need to install using the paths,..correct?? Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. Any suggestion would be much appreciated :) THX's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: Upgrade MySQL
does someone have a windows based program to manage, create and edit a database abd table off line MikeBlezien wrote: Hi All, I need to upgrade a server running MySQL v.3.23.38 to .39 Specs: RedHat/Linux 6.2 i386 512RAM The only databases currently are the default 'test' and the 'mysql' db's no other db's created. The current variables show: basedir/ datadir /var/lib/mysql My question is, when upgrading and to replace the current version, I assume I would need to install using the paths,..correct?? Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. Any suggestion would be much appreciated :) THX's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: Upgrade MySQL
On Thu, Jul 19, 2001 at 04:47:29PM -0500, MikemickaloBlezien wrote: The only databases currently are the default 'test' and the 'mysql' db's no other db's created. The current variables show: basedir/ datadir /var/lib/mysql My question is, when upgrading and to replace the current version, I assume I would need to install using the paths,..correct?? You can. Or you can install anywehere else and just copy the data files from /var/lib/mysql to the new data dir when your're done. Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. Any suggestion would be much appreciated :) Use the MySQL-MAX binary from mysql.com rather than building your own. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 33 days, processed 261,298,544 queries (90/sec. avg) - 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: Upgrade MySQL
On Thu, 19 Jul 2001 15:50:13 -0700, Jeremy Zawodny [EMAIL PROTECTED] wrote: Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. Any suggestion would be much appreciated :) Use the MySQL-MAX binary from mysql.com rather than building your own. thanks Jeremy, appreciate the feedback. Would I just follow the Quick Install for the binary. I've only installed MySQL with the source in the past. Can you just briefly touch on why the binary is better then using the source?? :) Again,..much THX's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: Upgrade MySQL
MikemickaloBlezien [EMAIL PROTECTED] wrote: I need to upgrade a server running MySQL v.3.23.38 to .39 Specs: RedHat/Linux 6.2 i386 512RAM The only databases currently are the default 'test' and the 'mysql' db's no other db's created. It seems you have nothing worth keeping, unless you have users and privileges setup you don't want to have to recreate. If that's the case backup the database mysql by copying the directory or using mysqldump so you can copy that database or load it from the dump file after installing MySQL. The current variables show: basedir/ datadir /var/lib/mysql My question is, when upgrading and to replace the current version, I assume I would need to install using the paths,..correct?? Or use whatever paths you want and copy the mysql database to whatever directory you chose. Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. I don't know how the RPM version is configured, but you can't go wrong with the source distro since you'll have more control over configuration options. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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: Upgrade MySQL
You may want to have a look at http://www.mysqlfront.de/ Sie schrieben am Freitag, 20. Juli 2001, 20:29:32: does someone have a windows based program to manage, create and edit a database abd table off line -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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: Upgrade MySQL
On Thu, Jul 19, 2001 at 05:57:15PM -0500, MikemickaloBlezien wrote: On Thu, 19 Jul 2001 15:50:13 -0700, Jeremy Zawodny [EMAIL PROTECTED] wrote: Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. Any suggestion would be much appreciated :) Use the MySQL-MAX binary from mysql.com rather than building your own. thanks Jeremy, appreciate the feedback. Would I just follow the Quick Install for the binary. I've only installed MySQL with the source in the past. Can you just briefly touch on why the binary is better then using the source?? :) The binary is known to be good (or at least known). It is a static binary built with a specific compiler, specific compiler options, and specificly tuned libraries. The MySQL team has put a lot of working into getting it right so that the rest of us don't have to. If you run into a problem using their binary, it's often easier for them to track down what went wrong. If you build it yourself and have problems, they have to rule out things which may be related to how you built the binary. Plus, the binary is a piece of cake to install. I use the binary tarballs, since I'm not an RPM fan. Just untar it and have a look at the installation notes. But you may (or may not) want to wait for 3.23.40 which will be out soon, I believe. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 33 days, processed 261,910,062 queries (90/sec. avg) - 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: Upgrade MySQL
Jeremy, Appreciate the info. I think we'll install the Mysql-Max and see how it goes. THX's On Thu, 19 Jul 2001 17:53:12 -0700, Jeremy Zawodny [EMAIL PROTECTED] wrote: The binary is known to be good (or at least known). It is a static binary built with a specific compiler, specific compiler options, and specificly tuned libraries. The MySQL team has put a lot of working into getting it right so that the rest of us don't have to. If you run into a problem using their binary, it's often easier for them to track down what went wrong. If you build it yourself and have problems, they have to rule out things which may be related to how you built the binary. Plus, the binary is a piece of cake to install. I use the binary tarballs, since I'm not an RPM fan. Just untar it and have a look at the installation notes. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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
How to upgrade MySQL without breaking PHP/Apache?
Trying to upgrade from 3.23.27 to 3.23.38 via rpm. The problem is then Apache/PHP cannot connect to the database (using the mysql routines internal to PHP), so I'm left having to --force --nodeps a downgrade to keep the system up. Now, PHP can be compiled to use the current MySQL libraries, but the last time I had to do that (with an install of MySQL 3.23.37 from binary tar to a Debian box) a needed MySQL library or two wasn't on the system, and to get it I had to compile MySQL from the source tar. Okay: 1. Is there a way to just get PHP/Apache to talk to the current MySQL without recompiling to reference the current MySQL libraries? 2. Does the development rpm actually contain what I'll need to point to if I _do_ have to recompile everything? 3. Considering that PHP/Apache is one of the most common MySQL front ends, why isn't this set of problems prominently dealt with in the documentation, if not avoided through clever programming and/or making sure the PHP team has early access to any interface changes coming along? Whit - 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: How to upgrade MySQL without breaking PHP/Apache?
You should be able to change your mysql.sock in your my.cnf or php.ini file and it will work. I'm thinking that it's a sock error you are getting. --Joe On Mon, Jun 11, 2001 at 09:43:56PM -0500, Whit Blauvelt wrote: Trying to upgrade from 3.23.27 to 3.23.38 via rpm. The problem is then Apache/PHP cannot connect to the database (using the mysql routines internal to PHP), so I'm left having to --force --nodeps a downgrade to keep the system up. Now, PHP can be compiled to use the current MySQL libraries, but the last time I had to do that (with an install of MySQL 3.23.37 from binary tar to a Debian box) a needed MySQL library or two wasn't on the system, and to get it I had to compile MySQL from the source tar. Okay: 1. Is there a way to just get PHP/Apache to talk to the current MySQL without recompiling to reference the current MySQL libraries? 2. Does the development rpm actually contain what I'll need to point to if I _do_ have to recompile everything? 3. Considering that PHP/Apache is one of the most common MySQL front ends, why isn't this set of problems prominently dealt with in the documentation, if not avoided through clever programming and/or making sure the PHP team has early access to any interface changes coming along? Whit - 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 Joe Stump [EMAIL PROTECTED] To each his own - My own is GNU/Linux --Joe Stump - 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
Upgrade mysql
I would like to upgrade mysql 3.23.22to 3.23.33, anybody know how to do it? PIVO
upgrade mysql version
Dear All, I was installed MySql 3.22.32 with PHP and Apache and I decide to upgrade to 3.32.32. Could I only install New version of MySql or reinstall all of related software (PHP Apache)?? Thank you, Sommai Fongnamthip - 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
