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

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

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 MySQL.

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

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 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 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-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/

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 fool can

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... It

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

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

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 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 mysql41-\* or should I

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 list

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

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 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

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 I were to dump

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't trust

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 could find no mention of upgrading. Hi Doug, As a rule

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

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 also

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 these

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,

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 series.

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.x series.

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

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

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

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: 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

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,