; 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
pkins [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 q
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 Genera
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 :)
abase 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
>
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 rem
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 us
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
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 importe
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
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
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
> MyS
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-
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
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 mys
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 o
> 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.
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
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.
> 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 i
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
Fo
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
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-DB
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\bin>mysql -e mysql_fix_privilege_tables
> but i keep on getting the error:
>
> ERROR 1064 a
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
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\bin>mysql -e mysql_fix_privilege_tables
but i keep on getting the error:
ERROR 1064 at line 1: You have an error in your SQL synta
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
>
&g
odules). 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 v
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'l
Thanks!
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 7:04 AM
To: [EMAIL PROTECTED]
Subject: 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.
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 questi
> 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 Apach
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
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://ord
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 file
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 l
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 th
?
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "MikeBlezien" <[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, Mi
On Sat, Jul 21, 2001 at 04:21:35PM -0500, MikeBlezien 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
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]> wro
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
On Thu, Jul 19, 2001 at 05:57:15PM -0500, MikeBlezien 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.
> >>>
> >>> An
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
"MikeBlezien" <[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 ha
>>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 fro
On Thu, Jul 19, 2001 at 04:47:29PM -0500, MikeBlezien 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 curr
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
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
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
Think you're right, but I've hundreds of mysql_connects on the server. The
php.ini trick did it though. Thanks.
Whit
On Tue, Jun 12, 2001 at 04:32:10PM -0500, Joe Stump wrote:
> You can also put this in your mysql_connect ... check out the syntax for it
> but I believe you can do this:
>
> mysq
On Mon, Jun 11, 2001 at 09:12:36PM -0500, Joe Stump wrote:
> 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,
Thanks. By coincidence this appeared in the php.net annotated manual today:
===
You can also put this in your mysql_connect ... check out the syntax for it
but I believe you can do this:
mysql_connect("server:port:socket","username","password");
--Joe
On Tue, Jun 12, 2001 at 05:17:58PM -0500, Whit Blauvelt wrote:
> On Mon, Jun 11, 2001 at 09:12:36PM -0500, Joe Stump wrote:
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
> Apac
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
th
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
--
58 matches
Mail list logo
