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 :)
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
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,
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/
>
>
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 My
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
> 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
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
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 i
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
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
27 matches
Mail list logo
