Re: upgrading mysql client and server

2006-09-02 Thread Matthew Seaman
Dave wrote: >I've got mysql server and client v4.1 running on a FreeBSD6.x box. > They were installed via ports not packages using custom make options > which i have in portupgrade's pkgtools.conf file. I now would like to > upgrade both of them to v5, without causing dependency issues with >

upgrading mysql client and server

2006-09-02 Thread Dave
Hello, I've got mysql server and client v4.1 running on a FreeBSD6.x box. They were installed via ports not packages using custom make options which i have in portupgrade's pkgtools.conf file. I now would like to upgrade both of them to v5, without causing dependency issues with installed ap

Re: upgrading mysql-server

2006-06-11 Thread Michael P. Soulier
On 10/06/06 Gerard Seibert said: > > I'm not aware of any port doing this. If you use portupgrade, use the > > AFTERINSTALL configuration options to call the rc.d scripts and restart. > > You can configure 'portmanager' to stop and restart a program also. I > was having the same problem with MySQ

Re: upgrading mysql-server

2006-06-10 Thread Nikolas Britton
On 6/8/06, Michael P. Soulier <[EMAIL PROTECTED]> wrote: So, my nightly security report says that I should upgrade mysql-server. [EMAIL PROTECTED] ~]# pkg_info | grep mysql-server mysql-server-4.1.15 Multithreaded SQL database (server) But, what port does this correspond to? Simply cd into /

Re: upgrading mysql-server

2006-06-10 Thread Gerard Seibert
Riemer Palstra wrote: > On Fri, Jun 09, 2006 at 09:08:03PM -0400, Michael P. Soulier wrote: > > And it shuts down my mysql server, but does not start it again. That's > > not very nice. Should the upgrade not handle this? > > I'm not aware of any port doing this. If you use portupgrade, use the >

Re: upgrading mysql-server

2006-06-10 Thread Riemer Palstra
On Fri, Jun 09, 2006 at 09:08:03PM -0400, Michael P. Soulier wrote: > And it shuts down my mysql server, but does not start it again. That's > not very nice. Should the upgrade not handle this? I'm not aware of any port doing this. If you use portupgrade, use the AFTERINSTALL configuration options

Re: upgrading mysql-server

2006-06-10 Thread Riemer Palstra
On Fri, Jun 09, 2006 at 09:01:00PM -0400, Michael P. Soulier wrote: > If the port is mysql41-server, maybe the package name should be similar? Ah, because the package is named mysql-server-4.1.20.tbz you mean? Hm, for people using packages, this would maybe make life easier, but to be honest, I do

Re: upgrading mysql-server

2006-06-09 Thread Michael P. Soulier
On 09/06/06 Michael P. Soulier said: > Ok. Upgrading now. And it shuts down my mysql server, but does not start it again. That's not very nice. Should the upgrade not handle this? Mike -- Michael P. Soulier <[EMAIL PROTECTED]> "Any intelligent fool can make things bigger and more complex... I

Re: upgrading mysql-server

2006-06-09 Thread Michael P. Soulier
On 09/06/06 Riemer Palstra said: > > I'm assuming mysql41-server, since it's version 4.1.15. > > Your assumption is right. Ok. Upgrading now. If the port is mysql41-server, maybe the package name should be similar? Thanks, Mike -- Michael P. Soulier <[EMAIL PROTECTED]> "Any intelligent foo

Re: upgrading mysql-server

2006-06-09 Thread Riemer Palstra
On Thu, Jun 08, 2006 at 06:40:01PM -0400, Michael P. Soulier wrote: > [EMAIL PROTECTED] ~]# ls -d /usr/ports/databases/mysql*server > /usr/ports/databases/mysql323-server/ /usr/ports/databases/mysql50-server/ > /usr/ports/databases/mysql40-server//usr/ports/databases/mysql51-server/ > /usr/po

upgrading mysql-server

2006-06-08 Thread Michael P. Soulier
So, my nightly security report says that I should upgrade mysql-server. [EMAIL PROTECTED] ~]# pkg_info | grep mysql-server mysql-server-4.1.15 Multithreaded SQL database (server) But, what port does this correspond to? [EMAIL PROTECTED] ~]# ls -d /usr/ports/databases/mysql*server /usr/ports/data

Re: Upgrading mysql 4.0 to 4.1

2005-09-22 Thread Gerard Seibert
On Thu, 22 Sep 2005 10:05:31 +0700, Roger Merritt <[EMAIL PROTECTED]> Subject: Upgrading mysql 4.0 to 4.1 Wrote these words of wisdom: > I want to upgrade mysql from ver. 4.0.26 to 4.1.x but am daunted by the > existence of the separate ports. Can I just run "portinstall -R

Re: Upgrading mysql 4.0 to 4.1

2005-09-22 Thread martin hudec
Hello, On Thu, Sep 22, 2005 at 09:40:32AM +0200 or thereabouts, Erik Norgaard wrote: > mysql client 4.1 cannot connect to server 4.0 (and AFAIK, nor can client 4.0 > connect to server 4.1) which justifies the existence of > separate ports. Actually mysql 4.1 client is able to connect to mysql

Re: Upgrading mysql 4.0 to 4.1

2005-09-22 Thread Erik Norgaard
Roger Merritt wrote: I want to upgrade mysql from ver. 4.0.26 to 4.1.x but am daunted by the existence of the separate ports. Can I just run "portinstall -R mysql41-\*" or should I do "pkgdeinstall mysql40-\*" first? mysql client 4.1 cannot connect to server 4.0 (and AFAIK, nor can client 4.0

Upgrading mysql 4.0 to 4.1

2005-09-21 Thread Roger Merritt
I want to upgrade mysql from ver. 4.0.26 to 4.1.x but am daunted by the existence of the separate ports. Can I just run "portinstall -R mysql41-\*" or should I do "pkgdeinstall mysql40-\*" first? -- Roger ___ freebsd-questions@freebsd.org mailing li

Re: Upgrading MySQL Without Wrecking Bacula

2005-06-11 Thread Drew Tomlinson
On 6/10/2005 10:25 PM Kevin Kinsey wrote: Drew Tomlinson wrote: I am a total noob regarding MySQL. I have version 3.23 installed on my 4.10 system. The only thing it's been used for and by is Bacula. I have never used it directly. But now I have reason to learn MySQL and feel it would be

Re: Upgrading MySQL Without Wrecking Bacula

2005-06-10 Thread Kevin Kinsey
Drew Tomlinson wrote: I am a total noob regarding MySQL. I have version 3.23 installed on my 4.10 system. The only thing it's been used for and by is Bacula. I have never used it directly. But now I have reason to learn MySQL and feel it would be appropriate to start with a newer version.

Upgrading MySQL Without Wrecking Bacula

2005-06-10 Thread Drew Tomlinson
I am a total noob regarding MySQL. I have version 3.23 installed on my 4.10 system. The only thing it's been used for and by is Bacula. I have never used it directly. But now I have reason to learn MySQL and feel it would be appropriate to start with a newer version. I see there's 4.1 and

Re: Upgrading MySQL strategies

2004-06-24 Thread Doug Poland
David Fuchs said: > Doug Poland wrote: >> Does someone have a strategy for upgrading MySQL? > > >> I've searched the archives and have turned up nothing useful. One would >> think this would be covered in MySQL's excellent on-line docs, but I >> co

Re: Upgrading MySQL strategies

2004-06-24 Thread David Fuchs
Doug Poland wrote: Does someone have a strategy for upgrading MySQL? > I've searched the archives and have turned up nothing useful. One would think this would be covered in MySQL's excellent on-line docs, but I could find no mention of upgrading. Hi Doug, As a rule, you shouldn

Upgrading MySQL strategies

2004-06-24 Thread Doug Poland
Hello, Does someone have a strategy for upgrading MySQL? For example, I'm currently running 5.2.1-RELEASE with mysql-server-4.1.1_2. The current MySQL version is 4.1.2. If I simply run portupgrade, will the new MySQL binary be "OK" with the older-style database files? If

Re: Question about something in ports/CHANGES file (re: upgrading MySQL)

2004-03-23 Thread Matthew Seaman
On Tue, Mar 23, 2004 at 01:10:38PM -0800, Paul D. Schmidt wrote: > Where can I find more information about the following? (Taken > from /usr/ports/CHANGES) > > 20040204: >... >The ports system now supports MySQL 3.23, 4.0, 4.1, and 5.0. >Also, the ability to scale to newer versions was

Question about something in ports/CHANGES file (re: upgrading MySQL)

2004-03-23 Thread Paul D. Schmidt
Where can I find more information about the following? (Taken from /usr/ports/CHANGES) 20040204: ... The ports system now supports MySQL 3.23, 4.0, 4.1, and 5.0. Also, the ability to scale to newer versions was also but in place. ... I don't see anything in the mysql40-server Makefil

Re: upgrading mysql

2004-01-23 Thread Dinesh Nair
On Thu, 22 Jan 2004, Christer Solskogen wrote: > I was wondering upgrading the mysql ports to 4.x series. should this be > okay? > > gallery-1.4.1 ,p5-Mysql-modules-1.2219, php4-4.3.4_5, phpMyAdmin-2.5.4, > phpSysInfo-2.1 and squirrelmail-1.4.2_1 seems to like mysql-3, and i was > wondering if the

Re: upgrading mysql

2004-01-22 Thread Matthew Seaman
On Thu, Jan 22, 2004 at 05:51:52PM +0100, Christer Solskogen wrote: > It seems like some port i want to install depend on mysql4, but i have > some programs that depends on mysql-client-3.23.58_1 ( I also have > mysql-server-3.23.58_1 installed) > > I was wondering upgrading the mysql ports to 4.x

Re: upgrading mysql

2004-01-22 Thread Christer Solskogen
> On Thursday 22 January 2004 10:51 am, Christer Solskogen wrote: >> It seems like some port i want to install depend on mysql4, but i have >> some programs that depends on mysql-client-3.23.58_1 ( I also have >> mysql-server-3.23.58_1 installed) >> >> I was wondering upgrading the mysql ports to 4

Re: upgrading mysql

2004-01-22 Thread Andrew L. Gould
On Thursday 22 January 2004 10:51 am, Christer Solskogen wrote: > It seems like some port i want to install depend on mysql4, but i have > some programs that depends on mysql-client-3.23.58_1 ( I also have > mysql-server-3.23.58_1 installed) > > I was wondering upgrading the mysql ports to 4.x seri

upgrading mysql

2004-01-22 Thread Christer Solskogen
It seems like some port i want to install depend on mysql4, but i have some programs that depends on mysql-client-3.23.58_1 ( I also have mysql-server-3.23.58_1 installed) I was wondering upgrading the mysql ports to 4.x series. should this be okay? gallery-1.4.1 ,p5-Mysql-modules-1.2219, php4-4.

Re: restoring mysql databases from mysqldump was Re: upgrading mysql

2003-08-29 Thread Michelle
I believe I succesfully restored the databases by running simply mysql > backup-file.sql. However, I believe the permissions are not working properly. Apache is unable to connect the sql server and I cannot shutdown the sql server with the user name and password I normally use. On Friday, Aug

Re: restoring mysql databases from mysqldump was Re: upgrading mysql

2003-08-29 Thread Alan Batie
On Fri, Aug 29, 2003 at 02:33:07PM -0700, Michelle wrote: > I ran mysqldump -A > backup-file.sql and then upgraded the mysql port, > but now when I try to restore the backups using mysql "database name" > < backup-file.sql, It states unknown database. I've never had a mysql upgrade trash my dat

restoring mysql databases from mysqldump was Re: upgrading mysql

2003-08-29 Thread Michelle
I ran mysqldump -A > backup-file.sql and then upgraded the mysql port, but now when I try to restore the backups using mysql "database name" < backup-file.sql, It states unknown database. I also have a mysqlhotcopy backup of all my databases. Am I doing something wrong when trying to recover

Re: upgrading mysql

2003-08-29 Thread Jack L. Stone
At 11:56 AM 8.29.2003 -0700, Michelle wrote: >I would like to upgrade mysql from mysql-server-3.23.54 to >mysql-server-3.23.57 and understand that I will need to do a dump >before upgrading since the upgrade needs to overwrite the databases. >Since I have never done this before, I just want to

upgrading mysql

2003-08-29 Thread Michelle
I would like to upgrade mysql from mysql-server-3.23.54 to mysql-server-3.23.57 and understand that I will need to do a dump before upgrading since the upgrade needs to overwrite the databases. Since I have never done this before, I just want to make sure I have the correct steps after reading