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
, 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
.
-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
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 :)
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
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
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
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
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
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
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
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
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
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
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
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,
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
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
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
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
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]
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:
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
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
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
: 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
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
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
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
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
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
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
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
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
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)
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,
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
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
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]
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
?
- 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
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
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'
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
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
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
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
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
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
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
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
I would like to upgrade mysql 3.23.22to 3.23.33, anybody know how to do it?
PIVO
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
53 matches
Mail list logo
