Re: [gentoo-server] mysql-4.1

Re: [gentoo-server] mysql-4.1

[Covington, Chris]

> all you need to do is the follow step by step what's written 
> here : http://www.gentoo.org/doc/en/mysql-upgrading.xml

I followed that and I wasn't able to restore my backup.  Specifically,
the snort database was screwed up:

frank2k3 ccovington # cat BACKUP_MYSQL_4.0.SQL | mysql -uroot
-hlocalhost --max_allowed_packet=16M
ERROR 1005 (HY000) at line 1813: Can't create table './snort/data.frm'
(errno: 150)

So I'm still using 4.0.25


---
Chris Covington
IT
Plus One Health Management
75 Maiden Lane Suite 801
NY, NY 10038
646-312-6269
http://www.plusoneactive.com

-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Dark]

Hey list,

I too had problems with a single database that didn't restore correct.. 
A rather large one (a few mb's) that was in a single line in the 
backupfile that was suggested in the guide. After I removed that line 
from the guide, the databases restored correctly and I had no other 
problems upgrading mysqld.

So now I'm running two mysqld's - one for the db that didn't restore, 
and one for all the others. Just untill I , or someone else , find out 
how to do this so it works.

Just my .02,
/Jakob Rosenlund

Covington, Chris wrote:

>>all you need to do is the follow step by step what's written 
>>here : http://www.gentoo.org/doc/en/mysql-upgrading.xml
>>    
>>
>
>I followed that and I wasn't able to restore my backup.  Specifically,
>the snort database was screwed up:
>
>frank2k3 ccovington # cat BACKUP_MYSQL_4.0.SQL | mysql -uroot
>-hlocalhost --max_allowed_packet=16M
>ERROR 1005 (HY000) at line 1813: Can't create table './snort/data.frm'
>(errno: 150)
>
>So I'm still using 4.0.25
>
>
>---
>Chris Covington
>IT
>Plus One Health Management
>75 Maiden Lane Suite 801
>NY, NY 10038
>646-312-6269
>http://www.plusoneactive.com
>
>  
>

-- 
gentoo-server@gentoo.org mailing list

[gentoo-server] mysql-4.1

[Ben Munat]

I see that MySQL-4.1 has been marked stable... anyone have any warnings I should heed 
before undertaking the upgrade (from 4.0.25-r2)? Francesco, you still lurking?

b
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Bertrand CHERRIER]

Hi,

I've upgraded my test server yesterday, and it went as documented, the 
only thing revdep-rebuild didn't do was for mod_php, appart from that, 
the migration was done in less than 15 minutes (on a bi-opteron 248 4Go)

all you need to do is the follow step by step what's written here :
http://www.gentoo.org/doc/en/mysql-upgrading.xml

have fun !

Ben Munat a écrit :

> I see that MySQL-4.1 has been marked stable... anyone have any 
> warnings I should heed before undertaking the upgrade (from 
> 4.0.25-r2)? Francesco, you still lurking?
>
> b


-- 
Bertrand CHERRIER
chr@linux-nc.org
Linux chr 2.6.13-gentoo-r4 #1 Thu Oct 13 11:13:14 NCT 2005 x86_64 AMD Athlon(tm) 64 Processor 3700+ AuthenticAMD GNU/Linux
-----
Bow before me, for I am root

-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[W.Kenworthy]

Running it now - up to the revdep-rebuild stage and no problems.  On an
existing mysql installation, the emerge stops with a message and points
you to an upgrade guide
("http://www.gentoo.org/doc/en/mysql-upgrading.xml").  There is a
paragraph (with warnings) at the bottom for a faster method.  Iam using
the implied "its safer" way!

The slower process involves taking a copy of your existing msql
installation (binaries+databases), emerge -C'ing mysql, rm -rf'ing the
remnants, install/rebuilding deps and then restoring the DB.  Count on
downtime!

BillK



On Wed, 2005-10-19 at 21:42 -0700, Ben Munat wrote:
> I see that MySQL-4.1 has been marked stable... anyone have any warnings I should heed 
> before undertaking the upgrade (from 4.0.25-r2)? Francesco, you still lurking?
> 
> b
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Dave Strydom]

[-- Attachment #1: Type: text/plain, Size: 1110 bytes --]

Mine broke holy :(

applications kept moaning that it couldnt find libmysqlclient.so.12, even
tho it is in /usr/lib/libmysqlclient.so.12

Dave

On 10/20/05, W.Kenworthy <billk@iinet.net.au> wrote:
>
> Running it now - up to the revdep-rebuild stage and no problems. On an
> existing mysql installation, the emerge stops with a message and points
> you to an upgrade guide
> ("http://www.gentoo.org/doc/en/mysql-upgrading.xml"). There is a
> paragraph (with warnings) at the bottom for a faster method. Iam using
> the implied "its safer" way!
>
> The slower process involves taking a copy of your existing msql
> installation (binaries+databases), emerge -C'ing mysql, rm -rf'ing the
> remnants, install/rebuilding deps and then restoring the DB. Count on
> downtime!
>
> BillK
>
>
>
> On Wed, 2005-10-19 at 21:42 -0700, Ben Munat wrote:
> > I see that MySQL-4.1 has been marked stable... anyone have any warnings
> I should heed
> > before undertaking the upgrade (from 4.0.25-r2)? Francesco, you still
> lurking?
> >
> > b
> --
> gentoo-server@gentoo.org mailing list
>
>

[-- Attachment #2: Type: text/html, Size: 1593 bytes --]

Re: [gentoo-server] mysql-4.1

[W.Kenworthy]

revdep-rebuild came up clean.  However, so far I have discovered postfix
and mythtv are both broken, and probably the remote myth boxes as well.
To be expected, but this is going to time consuming.  If revdep-rebuild
is useless here, how can I find what apps I need to fix - I still have
PHP to check and who knows what else :(

BillK


On Wed, 2005-10-19 at 21:42 -0700, Ben Munat wrote:
> I see that MySQL-4.1 has been marked stable... anyone have any warnings I should heed 
> before undertaking the upgrade (from 4.0.25-r2)? Francesco, you still lurking?
> 
> b
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Francesco R.]

Alle 08:51, giovedì 20 ottobre 2005, W.Kenworthy ha scritto:
> revdep-rebuild came up clean.  However, so far I have discovered
> postfix and mythtv are both broken, and probably the remote myth
> boxes as well. To be expected, but this is going to time consuming. 
> If revdep-rebuild is useless here, how can I find what apps I need to
> fix - I still have PHP to check and who knows what else :(
>
> BillK
>
> On Wed, 2005-10-19 at 21:42 -0700, Ben Munat wrote:
> > I see that MySQL-4.1 has been marked stable... anyone have any
> > warnings I should heed before undertaking the upgrade (from
> > 4.0.25-r2)? Francesco, you still lurking?
> >
> > b

odd, wich version of "app-portage/gentoolkit" do you have installed, 
look like you're not alone having this issue.

-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Wolf Giesen]

> odd, wich version of "app-portage/gentoolkit" do you have installed, 
> look like you're not alone having this issue.

Current stable here. Not the first time revdep-rebuild is blind on one
eye. I had to rebuild libwww, mod_php and php "manually", so far.
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Dark]

Hey list,

I had no problem doing revdep-rebuild during my upgrade ( I too followed 
that guide ).
I'm using app-portage/gentoolkit-0.2.0-r2 , dev-php/mod_php-4.4.0-r3 , 
dev-php/php-4.4.0-r1 and net-libs/libwww-5.4.0-r3 ..
Those got rebuild without a problem by revdep-rebuild .. Also it rebuild 
eggdrop and some other minor things.

Do you have other packages it want to rebuild? Because I had a 
blackdown-jdk and blackdown-jre that it couldn't find because they were 
heavily outdated and had sneaked it's way through my "emerge -auDv 
world".. So I just deleted those since I'm using the sun JDK at the 
moment anyway. Then revdep-rebuild worked wonders.

/Jakob Rosenlund

Wolf Giesen wrote:

>>odd, wich version of "app-portage/gentoolkit" do you have installed, 
>>look like you're not alone having this issue.
>>    
>>
>
>Current stable here. Not the first time revdep-rebuild is blind on one
>eye. I had to rebuild libwww, mod_php and php "manually", so far.
>  
>

-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[William Kenworthy]

I have now done two systems - and I now have two broken systems - and
worse I cant find out whats broken until I go to use it ...

The one where revdep-rebuild is showing nothing at all is at gentoolkit
version 0.2.0-r2 - there are quite a few broken packages. (mostly from
php, postfix and I think samba so far plus potentially a lot more)

My work laptop is now deeply ill and I am going to have to spend a few
hours on it on Monday.  Revdep-rebuild lists many broken apps but isnt
interested in fixing them!  Just exits saying nothing to rebuild.

Whats interesting about this is how mysql seems to have wriggled is way
into the core of so many apps.  I am really regretting turning that use
flag on when it was only one app I wanted it for.

crap!

BillK

On Thu, 2005-10-20 at 15:16 +0200, Francesco R. wrote:
> Alle 08:51, giovedì 20 ottobre 2005, W.Kenworthy ha scritto:
> > revdep-rebuild came up clean.  However, so far I have discovered
> > postfix and mythtv are both broken, and probably the remote myth
> > boxes as well. To be expected, but this is going to time consuming. 
> > If revdep-rebuild is useless here, how can I find what apps I need to
> > fix - I still have PHP to check and who knows what else :(
> >
> > BillK
> >
> > On Wed, 2005-10-19 at 21:42 -0700, Ben Munat wrote:
> > > I see that MySQL-4.1 has been marked stable... anyone have any
> > > warnings I should heed before undertaking the upgrade (from
> > > 4.0.25-r2)? Francesco, you still lurking?
> > >
> > > b
> 
> odd, wich version of "app-portage/gentoolkit" do you have installed, 
> look like you're not alone having this issue.
> 
-- 
William Kenworthy <billk@iinet.net.au>
Home!
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Francesco R.]

Alle 14:00, venerdì 21 ottobre 2005, William Kenworthy ha scritto:
> I have now done two systems - and I now have two broken systems - and
> worse I cant find out whats broken until I go to use it ...
>
> The one where revdep-rebuild is showing nothing at all is at
> gentoolkit version 0.2.0-r2 - there are quite a few broken packages.
> (mostly from php, postfix and I think samba so far plus potentially a
> lot more)

<quoting from previous message>
A rather awful workaround is to rebuild every package that has the mysql 
useflag. to generate a list try this oneliner:

emerge -epv --columns mysql \
| grep mysql | grep -v 'dev-db/mysql '\
| cut -c 17- \
| awk '{print "emerge --oneshot --nodeps", $1}'

then adjust the list for your needs.
</quoting from previous message>

This list will contain also packages with "mysql" use flag turned off.

>
> My work laptop is now deeply ill and I am going to have to spend a
> few hours on it on Monday.  Revdep-rebuild lists many broken apps but
> isnt interested in fixing them!  Just exits saying nothing to
> rebuild.

Hope that that will be cpu time and not human one

>
> Whats interesting about this is how mysql seems to have wriggled is
> way into the core of so many apps.  I am really regretting turning
> that use flag on when it was only one app I wanted it for.

to achieve this it suffice to put USE="-mysql" in /etc/make.conf and to 
enable it for required ebuild into /etc/portage/packge.use


-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Francesco R.]

[sorry if this is duplicated, having some problems switching email 
client]

Re: [gentoo-server] mysql-4.1
 (Francesco R., Thu Oct 20 12:39:07 2005)
Alle 06:42, giovedì 20 ottobre 2005, Ben Munat ha scritto:
> I see that MySQL-4.1 has been marked stable... anyone have any
> warnings I should heed before undertaking the upgrade (from

Yes, I've spent some time with a user that had problem upgrading a phpBB 
site.


first: a duplicate primary key, reproduce case below

========= failed insert ===========
DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` (
  `f1` varchar(50) binary NOT NULL default '',
  primary KEY  (`f1`)
) ENGINE=MyISAM;


/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
LOCK TABLES `t1` WRITE;
INSERT INTO `t1` VALUES ( 0x686D6D),( 0x686D6DB2);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;

--ERROR 1062 (23000) at line 10: Duplicate entry 'hmm' for key 1
========= failed insert ===========

the duplicate key is "hmm" with "hmm²"

Another problem was MySQL importing truncated fields, 
the fields where truncated at charachter with dieresis.

The solution here was to pipe the dump through iconv:

# iconv -f ISO-8859-15 -t UTF-8 dump.sql | mysql 

The other problem was with php-4 and the well known connection charset 
problem.

To be sincere we 've not solved the last one in a satisfing way, but 
this is my fault, it's way too much time I've setted up my boxes to 
work with php-5 and mysql-4.1.

> 4.0.25-r2)? Francesco, you still lurking?
>
> b

when having time ;-)

-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Ben Munat]

So, do any of you folks reporting success or failure happen to be using vpopmail? The last 
big MySQL debacle took down vpopmail and therefore all the mail... that sucked.

b

Ben Munat wrote:
> I see that MySQL-4.1 has been marked stable... anyone have any warnings 
> I should heed before undertaking the upgrade (from 4.0.25-r2)? 
> Francesco, you still lurking?
> 
> b
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Dave Strydom]

[-- Attachment #1: Type: text/plain, Size: 791 bytes --]

Well i have only had failure, due to programs not being able to find the
libmysqlclient.so.12
even after updating with ldconfig or env-update

my MailScanner and exim broke because of this (well i only got that far into
it because i rolled back to the old version)

Dave

On 10/21/05, Ben Munat <bent@munat.com> wrote:
>
> So, do any of you folks reporting success or failure happen to be using
> vpopmail? The last
> big MySQL debacle took down vpopmail and therefore all the mail... that
> sucked.
>
> b
>
> Ben Munat wrote:
> > I see that MySQL-4.1 has been marked stable... anyone have any warnings
> > I should heed before undertaking the upgrade (from 4.0.25-r2)?
> > Francesco, you still lurking?
> >
> > b
> --
> gentoo-server@gentoo.org mailing list
>
>

[-- Attachment #2: Type: text/html, Size: 1135 bytes --]

Re: [gentoo-server] mysql-4.1

[Ben Munat]

Francesco, any thoughts on this? I seem to remember my last disaster with mysql/vpopmail 
was due to libmysqlclient.so.12 disappearing. This makes me very nervous. Shouldn't 
revdep-rebuild take care of this? Anyone else have vopopmail installed but have 
successfully done this upgrade?

b

Dave Strydom wrote:
> Well i have only had failure, due to programs not being able to find the 
> libmysqlclient.so.12
> even after updating with ldconfig or env-update
> 
> my MailScanner and exim broke because of this (well i only got that far 
> into it because i rolled back to the old version)
> 
> Dave
> 
> On 10/21/05, *Ben Munat* <bent@munat.com <mailto:bent@munat.com>> wrote:
> 
>     So, do any of you folks reporting success or failure happen to be
>     using vpopmail? The last
>     big MySQL debacle took down vpopmail and therefore all the mail...
>     that sucked.
> 
>     b
> 
>     Ben Munat wrote:
>      > I see that MySQL-4.1 has been marked stable... anyone have any
>     warnings
>      > I should heed before undertaking the upgrade (from 4.0.25-r2)?
>      > Francesco, you still lurking?
>      >
>      > b
>     --
>     gentoo-server@gentoo.org <mailto:gentoo-server@gentoo.org> mailing list
> 
> 
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Francesco R.]

Alle 08:31, venerdì 21 ottobre 2005, Ben Munat ha scritto:
> Francesco, any thoughts on this? I seem to remember my last disaster
> with mysql/vpopmail was due to libmysqlclient.so.12 disappearing.
> This makes me very nervous. Shouldn't revdep-rebuild take care of
> this? Anyone else have vopopmail installed but have successfully done
> this upgrade?
>
revdep-rebuild *should*, having problem me too with it not rebuilding 
*all* what I need.

A rather awful workaround is to rebuild every package that has the mysql 
useflag. to generate a list try this oneliner:

emerge -epv --columns mysql \
| grep mysql | grep -v 'dev-db/mysql '\
| cut -c 17- \
| awk 'emerge --oneshot {print $1}' \
| awk '{print "emerge --oneshot --nodeps", $1}'

then adjust the list for your needs.

> Dave Strydom wrote:
> > Well i have only had failure, due to programs not being able to
> > find the libmysqlclient.so.12
> > even after updating with ldconfig or env-update
> >
> > my MailScanner and exim broke because of this (well i only got that
> > far into it because i rolled back to the old version)
> >
> >     So, do any of you folks reporting success or failure happen to
> > be using vpopmail? The last
> >     big MySQL debacle took down vpopmail and therefore all the
> > mail... that sucked.
[snip]

Sorry for the problems, I can setup a test environment on a public ip 
address (x86 running stable), following your instruction (I don't use 
vpopmail).

Then we can test everything there.

Best regards,
Francesco R.



-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Francesco R.]

not a good day today 

> emerge -epv --columns mysql \
> | grep mysql | grep -v 'dev-db/mysql '\
> | cut -c 17- \
> | awk 'emerge --oneshot {print $1}' \
> | awk '{print "emerge --oneshot --nodeps", $1}'
>

should be

emerge -epv --columns mysql \
| grep mysql | grep -v 'dev-db/mysql '\
| cut -c 17- \
| awk '{print "emerge --oneshot --nodeps", $1}'
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Lance Albertson]

[-- Attachment #1: Type: text/plain, Size: 1224 bytes --]

Francesco R. wrote:
> Alle 08:31, venerdì 21 ottobre 2005, Ben Munat ha scritto:
> 
>>Francesco, any thoughts on this? I seem to remember my last disaster
>>with mysql/vpopmail was due to libmysqlclient.so.12 disappearing.
>>This makes me very nervous. Shouldn't revdep-rebuild take care of
>>this? Anyone else have vopopmail installed but have successfully done
>>this upgrade?
>>
> 
> revdep-rebuild *should*, having problem me too with it not rebuilding 
> *all* what I need.
> 
> A rather awful workaround is to rebuild every package that has the mysql 
> useflag. to generate a list try this oneliner:
> 
> emerge -epv --columns mysql \
> | grep mysql | grep -v 'dev-db/mysql '\
> | cut -c 17- \
> | awk 'emerge --oneshot {print $1}' \
> | awk '{print "emerge --oneshot --nodeps", $1}'
> 
> then adjust the list for your needs.

Shouldn't using revdep-rebuild as the following catch everything?

revdep-rebuild --soname libmysqlclient.so.12

-- 
Lance Albertson <ramereth@gentoo.org>
Gentoo Infrastructure | Operations Manager

---
GPG Public Key:  <http://www.ramereth.net/lance.asc>
Key fingerprint: 0423 92F3 544A 1282 5AB1  4D07 416F A15D 27F4 B742

ramereth/irc.freenode.net


[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 186 bytes --]

Re: [gentoo-server] mysql-4.1

[Dave Strydom]

[-- Attachment #1: Type: text/plain, Size: 2318 bytes --]

Man, this ...... page messed up my mysql stuff seriously, ok, for those who
had the same libmysqlclient.so.12 problems i had or for those people who get
to the importing of all your database backup and it stuffs up. here is
DAVE'S guide to upgrading to MySQL 4.1


# = commands to type
= = comments

====================================
# mkdir -p /home/backup/mysql
# nano mysql_backup.php

==
= Place the code below into the mysql_backup.php and save the file =
==

/*------mysql_backup.php---------*/
<?
print("mysql backup\n");
foreach (glob('/var/lib/mysql/*') as $fullname)
{
$database = basename($fullname);
$command = sprintf('mysqldump -a -B %s -c -v -Q > /home/backup/mysql/%s.sql
--password=\'Our@db$IG\'', $database, $database);

exec($command);
print($database . ' : ' . $command . "\n\n\n");

}
?>


/*-----------------------------------------------------*/

# nano mysql_restore.php

==
= Place the code below in the mysql_restore.php and save the file =
==

/*------mysql_retore.php---------*/
<?

print("mysql backup\n");

$dir = '/home/backup/mysql/';
if ($fp = opendir($dir))
{
print('running...');
while (($file = readdir($fp)) !== FALSE) {
echo "$file\n";

$database = basename($file);
$command = sprintf('mysql < /home/backup/mysql/%s --password=\'Our@db$IG\'',
$database);
print($database . ' : ' . $command . "\n\n\n");
exec($command);

}
closedir($fp);
}
else
{
print('cannot open path ' . $dir);
}

?>

/*---------------*/

# php mysql_backup.php

==
= This will make individual backup's of all your databases, the reason i
make it create scripts for each database
= instead of just pumping it all into 1 database, is because if there is a
problem on like 486590 of a 5 million
= line file, its going to be a bitch to work with, this way it just
simplifies matters
==

# quickpkg dev-db/mysql
# /etc/init.d/mysql stop
# emerge -C mysql
# rm -rf /var/lib/mysql/ /var/log/mysql
# emerge mysql
# etc-update
# emerge --config =mysql-4.1.14
# revdep-rebuild --soname libmysqlclient.so.12
# php mysql_restore.php
# mysql_fix_privilege_tables --defaults-file=/etc/mysql/my.cnf --user=root
--password='PASSWORD'
# /etc/init.d/mysql restart

And thats it.
=======================================

Dave

[-- Attachment #2: Type: text/html, Size: 3159 bytes --]

Re: [gentoo-server] mysql-4.1

[Dave Strydom]

[-- Attachment #1: Type: text/plain, Size: 2660 bytes --]

oh yeah, and change the --password='' field to your own password, dont just
copy past.

Dave

On 10/22/05, Dave Strydom <strydom.dave@gmail.com> wrote:
>
> Man, this ...... page messed up my mysql stuff seriously, ok, for those
> who had the same libmysqlclient.so.12 problems i had or for those people
> who get to the importing of all your database backup and it stuffs up. here
> is DAVE'S guide to upgrading to MySQL 4.1
>
>
> # = commands to type
> = = comments
>
> ====================================
> # mkdir -p /home/backup/mysql
> # nano mysql_backup.php
>
> ==
> = Place the code below into the mysql_backup.php and save the file =
> ==
>
> /*------mysql_backup.php---------*/
> <?
> print("mysql backup\n");
> foreach (glob('/var/lib/mysql/*') as $fullname)
> {
> $database = basename($fullname);
> $command = sprintf('mysqldump -a -B %s -c -v -Q >
> /home/backup/mysql/%s.sql --password=\'Our@db$IG\'', $database,
> $database);
>
> exec($command);
> print($database . ' : ' . $command . "\n\n\n");
>
> }
> ?>
>
>
> /*-----------------------------------------------------*/
>
> # nano mysql_restore.php
>
> ==
> = Place the code below in the mysql_restore.php and save the file =
> ==
>
> /*------mysql_retore.php---------*/
> <?
>
> print("mysql backup\n");
>
> $dir = '/home/backup/mysql/';
> if ($fp = opendir($dir))
> {
> print('running...');
> while (($file = readdir($fp)) !== FALSE) {
> echo "$file\n";
>
> $database = basename($file);
> $command = sprintf('mysql < /home/backup/mysql/%s --password=\'Our@db$IG\'',
> $database);
> print($database . ' : ' . $command . "\n\n\n");
> exec($command);
>
> }
> closedir($fp);
> }
> else
> {
> print('cannot open path ' . $dir);
> }
>
> ?>
>
> /*---------------*/
>
> # php mysql_backup.php
>
> ==
> = This will make individual backup's of all your databases, the reason i
> make it create scripts for each database
> = instead of just pumping it all into 1 database, is because if there is a
> problem on like 486590 of a 5 million
> = line file, its going to be a bitch to work with, this way it just
> simplifies matters
> ==
>
> # quickpkg dev-db/mysql
> # /etc/init.d/mysql stop
> # emerge -C mysql
> # rm -rf /var/lib/mysql/ /var/log/mysql
> # emerge mysql
> # etc-update
> # emerge --config =mysql-4.1.14
> # revdep-rebuild --soname libmysqlclient.so.12
> # php mysql_restore.php
> # mysql_fix_privilege_tables --defaults-file=/etc/mysql/my.cnf --user=root
> --password='PASSWORD'
> # /etc/init.d/mysql restart
>
> And thats it.
> =======================================
>
> Dave
>

[-- Attachment #2: Type: text/html, Size: 3628 bytes --]

Re: [gentoo-server] mysql-4.1

[Barry Marler]

On 10/22/05, Dave Strydom <strydom.dave@gmail.com> wrote:
> oh yeah, and change the --password='' field to your own password, dont just
> copy past.
>
>  Dave
>
>
> On 10/22/05, Dave Strydom <strydom.dave@gmail.com> wrote:
> > Man, this ...... page messed up my mysql stuff seriously, ok, for those
> who had the same libmysqlclient.so.12 problems i had or for those people who
> get to the importing of all your database backup and it stuffs up. here is
> DAVE'S guide to upgrading to MySQL 4.1
> >
> >
> > #  = commands to type
> > =  = comments
> >
> > ====================================
> > # mkdir -p /home/backup/mysql
> > # nano mysql_backup.php
> >
> > ==
> > = Place the code below into the mysql_backup.php and save the file =
> > ==
> >
> > /*------mysql_backup.php---------*/
> > <?
> > print("mysql backup\n");
> > foreach (glob('/var/lib/mysql/*') as $fullname)
> > {
> >         $database = basename($fullname);
> >         $command = sprintf('mysqldump -a -B %s -c -v -Q >
> /home/backup/mysql/%s.sql --password=\'Our@db$IG\'', $database, $database);
> >
> >         exec($command);
> >         print($database . ' : ' . $command . "\n\n\n");
> >
> > }
> > ?>
> >
> >
> > /*-----------------------------------------------------*/
> >
> > # nano mysql_restore.php
> >
> > ==
> > = Place the code below in the mysql_restore.php and save the file =
> > ==
> >
> > /*------mysql_retore.php---------*/
> > <?
> >
> > print("mysql backup\n");
> >
> > $dir = '/home/backup/mysql/';
> > if ($fp = opendir($dir))
> > {
> >         print('running...');
> >  while (($file = readdir($fp)) !== FALSE) {
> >      echo "$file\n";
> >
> >      $database = basename($file);
> >      $command = sprintf('mysql < /home/backup/mysql/%s
> --password=\'Our@db$IG\'', $database);
> >      print($database . ' : ' . $command . "\n\n\n");
> >      exec($command);
> >
> >  }
> >  closedir($fp);
> > }
> > else
> > {
> >         print('cannot open path ' . $dir);
> > }
> >
> > ?>
> >
> > /*---------------*/
> >
> > # php mysql_backup.php
> >
> > ==
> > = This will make individual backup's of all your databases, the reason i
> make it create scripts for each database
> > = instead of just pumping it all into 1 database, is because if there is a
> problem on like 486590 of a 5 million
> > = line file, its going to be a bitch to work with, this way it just
> simplifies matters
> > ==
> >
> > # quickpkg dev-db/mysql
> > # /etc/init.d/mysql stop
> > # emerge -C mysql
> > # rm -rf /var/lib/mysql/ /var/log/mysql
> > # emerge mysql
> > # etc-update
> > # emerge --config =mysql-4.1.14
> > # revdep-rebuild --soname libmysqlclient.so.12
> > # php mysql_restore.php
> > # mysql_fix_privilege_tables
> --defaults-file=/etc/mysql/my.cnf --user=root
> --password='PASSWORD'
> > # /etc/init.d/mysql restart
> >
> > And thats it.
> > =======================================
> >
> > Dave
> >
>
>

The upgrade TOTALLY pfutzed my test box. After installing 4.1,
revdep-rebuild wanted to build a bunch of ~x86 stuff (mod_php among
them). I went back to the old version. I have three production servers
running MySQL/Apache2/PHP, none of which will get this upgrade. For
the 1st time in 3 years, Gentoo is really pissing me off.

-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Dave Strydom]

[-- Attachment #1: Type: text/plain, Size: 3648 bytes --]

try with my scripts?

On 10/22/05, Barry Marler <barry.marler@gmail.com> wrote:
>
> On 10/22/05, Dave Strydom <strydom.dave@gmail.com> wrote:
> > oh yeah, and change the --password='' field to your own password, dont
> just
> > copy past.
> >
> > Dave
> >
> >
> > On 10/22/05, Dave Strydom <strydom.dave@gmail.com> wrote:
> > > Man, this ...... page messed up my mysql stuff seriously, ok, for
> those
> > who had the same libmysqlclient.so.12 problems i had or for those people
> who
> > get to the importing of all your database backup and it stuffs up. here
> is
> > DAVE'S guide to upgrading to MySQL 4.1
> > >
> > >
> > > # = commands to type
> > > = = comments
> > >
> > > ====================================
> > > # mkdir -p /home/backup/mysql
> > > # nano mysql_backup.php
> > >
> > > ==
> > > = Place the code below into the mysql_backup.php and save the file =
> > > ==
> > >
> > > /*------mysql_backup.php---------*/
> > > <?
> > > print("mysql backup\n");
> > > foreach (glob('/var/lib/mysql/*') as $fullname)
> > > {
> > > $database = basename($fullname);
> > > $command = sprintf('mysqldump -a -B %s -c -v -Q >
> > /home/backup/mysql/%s.sql --password=\'Our@db$IG\'', $database,
> $database);
> > >
> > > exec($command);
> > > print($database . ' : ' . $command . "\n\n\n");
> > >
> > > }
> > > ?>
> > >
> > >
> > > /*-----------------------------------------------------*/
> > >
> > > # nano mysql_restore.php
> > >
> > > ==
> > > = Place the code below in the mysql_restore.php and save the file =
> > > ==
> > >
> > > /*------mysql_retore.php---------*/
> > > <?
> > >
> > > print("mysql backup\n");
> > >
> > > $dir = '/home/backup/mysql/';
> > > if ($fp = opendir($dir))
> > > {
> > > print('running...');
> > > while (($file = readdir($fp)) !== FALSE) {
> > > echo "$file\n";
> > >
> > > $database = basename($file);
> > > $command = sprintf('mysql < /home/backup/mysql/%s
> > --password=\'Our@db$IG\'', $database);
> > > print($database . ' : ' . $command . "\n\n\n");
> > > exec($command);
> > >
> > > }
> > > closedir($fp);
> > > }
> > > else
> > > {
> > > print('cannot open path ' . $dir);
> > > }
> > >
> > > ?>
> > >
> > > /*---------------*/
> > >
> > > # php mysql_backup.php
> > >
> > > ==
> > > = This will make individual backup's of all your databases, the reason
> i
> > make it create scripts for each database
> > > = instead of just pumping it all into 1 database, is because if there
> is a
> > problem on like 486590 of a 5 million
> > > = line file, its going to be a bitch to work with, this way it just
> > simplifies matters
> > > ==
> > >
> > > # quickpkg dev-db/mysql
> > > # /etc/init.d/mysql stop
> > > # emerge -C mysql
> > > # rm -rf /var/lib/mysql/ /var/log/mysql
> > > # emerge mysql
> > > # etc-update
> > > # emerge --config =mysql-4.1.14
> > > # revdep-rebuild --soname libmysqlclient.so.12
> > > # php mysql_restore.php
> > > # mysql_fix_privilege_tables
> > --defaults-file=/etc/mysql/my.cnf --user=root
> > --password='PASSWORD'
> > > # /etc/init.d/mysql restart
> > >
> > > And thats it.
> > > =======================================
> > >
> > > Dave
> > >
> >
> >
>
> The upgrade TOTALLY pfutzed my test box. After installing 4.1,
> revdep-rebuild wanted to build a bunch of ~x86 stuff (mod_php among
> them). I went back to the old version. I have three production servers
> running MySQL/Apache2/PHP, none of which will get this upgrade. For
> the 1st time in 3 years, Gentoo is really pissing me off.
>
> --
> gentoo-server@gentoo.org mailing list
>
>

[-- Attachment #2: Type: text/html, Size: 5284 bytes --]

Re: [gentoo-server] mysql-4.1

[Lance Albertson]

[-- Attachment #1: Type: text/plain, Size: 1119 bytes --]

Barry Marler wrote:

> The upgrade TOTALLY pfutzed my test box. After installing 4.1,
> revdep-rebuild wanted to build a bunch of ~x86 stuff (mod_php among
> them). I went back to the old version. I have three production servers
> running MySQL/Apache2/PHP, none of which will get this upgrade. For
> the 1st time in 3 years, Gentoo is really pissing me off.

Have you updated to the new Gentoo apache layout? If not, I imagine that
might be what have happened (and I'm not too happy about it myself). The
one thing that seems odd is that revdep is pulling ~x86 versions. Are
you sure its doing that, or is it pulling the new apache layout stuff
that appears to be ~x86 but is really stable now?

Believe me, I've complained about the whole 'apache upgrade' crap. I'm
just as pissed as you (and I'm even a developer!).

Best of luck and let us know if we can help you in any way.

-- 
Lance Albertson <ramereth@gentoo.org>
Gentoo Infrastructure | Operations Manager

---
GPG Public Key:  <http://www.ramereth.net/lance.asc>
Key fingerprint: 0423 92F3 544A 1282 5AB1  4D07 416F A15D 27F4 B742

ramereth/irc.freenode.net

[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 189 bytes --]

Re: [gentoo-server] mysql-4.1

[Dave Strydom]

[-- Attachment #1: Type: text/plain, Size: 1671 bytes --]

I actually rather like the apache upgrade, I just upgraded one of my main
webservers now.

I did a emerge -u apache dev-php/php mod_php

Moved my vhost files (since i have a serperate .conf file for each website
on the server, makes for easier management), edited the httpd.conf and
restarted apache, and everything works, no downtime at all.

Dave

============================================
On 10/22/05, Lance Albertson <ramereth@gentoo.org> wrote:
>
> Barry Marler wrote:
>
> > The upgrade TOTALLY pfutzed my test box. After installing 4.1,
> > revdep-rebuild wanted to build a bunch of ~x86 stuff (mod_php among
> > them). I went back to the old version. I have three production servers
> > running MySQL/Apache2/PHP, none of which will get this upgrade. For
> > the 1st time in 3 years, Gentoo is really pissing me off.
>
> Have you updated to the new Gentoo apache layout? If not, I imagine that
> might be what have happened (and I'm not too happy about it myself). The
> one thing that seems odd is that revdep is pulling ~x86 versions. Are
> you sure its doing that, or is it pulling the new apache layout stuff
> that appears to be ~x86 but is really stable now?
>
> Believe me, I've complained about the whole 'apache upgrade' crap. I'm
> just as pissed as you (and I'm even a developer!).
>
> Best of luck and let us know if we can help you in any way.
>
> --
> Lance Albertson <ramereth@gentoo.org>
> Gentoo Infrastructure | Operations Manager
>
> ---
> GPG Public Key: <http://www.ramereth.net/lance.asc>
> Key fingerprint: 0423 92F3 544A 1282 5AB1 4D07 416F A15D 27F4 B742
>
> ramereth/irc.freenode.net
>
>
>

[-- Attachment #2: Type: text/html, Size: 2127 bytes --]

Re: [gentoo-server] mysql-4.1

[Craig Webster]

On 22 Oct 2005, at 14:55, Dave Strydom wrote:
> I actually rather like the apache upgrade, I just upgraded one of  
> my main webservers now.
>
> I did a emerge -u apache dev-php/php mod_php
>
> Moved my vhost files (since i have a serperate .conf file for each  
> website on the server, makes for easier management), edited the  
> httpd.conf and restarted apache, and everything works, no downtime  
> at all.

Then in just a little while we're moving to dev-lang/php. Joys!

I've got the new dev-lang/php-4 and dev-lang/php-5 along with www- 
apache/mod_suphp installed on a new amd64 box and they're going  
amazingly but the chops and changes are still very frustrating --  
especially as there currently seems to be no way to get mod_php5!

Yours,
Craig
--
Craig Webster | t: +44 (0)131 516 8595 | e: craig@xeriom.net
Xeriom.NET    | f: +44 (0)709 287 1902 | w: http://xeriom.net


-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Luca Longinotti]

[-- Attachment #1: Type: text/plain, Size: 725 bytes --]

>> I've got the new dev-lang/php-4 and dev-lang/php-5 along with www-
apache/mod_suphp installed on a new amd64 box and they're going
>> amazingly but the chops and changes are still very frustrating -- 
especially as there currently seems to be no way to get mod_php5!


USE="apache2" emerge =dev-lang/php-5*

or USE="apache" if you still use Apache1, dev-lang/php now builds
mod_php itself, if you enable one of the apache/apache2 USE flags.
Please read
http://svn.gnqs.org/projects/gentoo-php-overlay/file/docs/php-upgrading.html?format=raw
for more informations.

-- 
Best regards,
Luca Longinotti aka CHTEKK

LongiTEKK Networks Admin: chtekk@longitekk.com
MaxDev Dev: chtekk@maxdev.com
TILUG Supporter: chtekk@tilug.ch


[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 256 bytes --]

Re: [gentoo-server] mysql-4.1

[Craig Webster]

On 22 Oct 2005, at 15:32, Luca Longinotti wrote:
> USE="apache2" emerge =dev-lang/php-5*

Ah, many thanks -- hadn't read the new php stuff properly yet. :)

Yours,
Craig
--
Craig Webster | t: +44 (0)131 516 8595 | e: craig@xeriom.net
Xeriom.NET    | f: +44 (0)709 287 1902 | w: http://xeriom.net


-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Francesco R.]

Alle 16:51, sabato 22 ottobre 2005, Craig Webster ha scritto:
> On 22 Oct 2005, at 15:32, Luca Longinotti wrote:
> > USE="apache2" emerge =dev-lang/php-5*
>
> Ah, many thanks -- hadn't read the new php stuff properly yet. :)
>
>
Also quite everyone will want USE="pecl" to enable perl regular 
expression, quite every php package use it.
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Craig Webster]

On 22 Oct 2005, at 20:43, Francesco R. wrote:
> Alle 16:51, sabato 22 ottobre 2005, Craig Webster ha scritto:
>> On 22 Oct 2005, at 15:32, Luca Longinotti wrote:
>>> USE="apache2" emerge =dev-lang/php-5*
>> Ah, many thanks -- hadn't read the new php stuff properly yet. :)
> Also quite everyone will want USE="pecl" to enable perl regular
> expression, quite every php package use it.

Isn't that included in the pcre flag?

Yours,
Craig
--
Craig Webster | t: +44 (0)131 516 8595 | e: craig@xeriom.net
Xeriom.NET    | f: +44 (0)709 287 1902 | w: http://xeriom.net


-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Francesco R.]

Alle 21:46, sabato 22 ottobre 2005, Craig Webster ha scritto:
> On 22 Oct 2005, at 20:43, Francesco R. wrote:
> > Alle 16:51, sabato 22 ottobre 2005, Craig Webster ha scritto:
> >> On 22 Oct 2005, at 15:32, Luca Longinotti wrote:
> >>> USE="apache2" emerge =dev-lang/php-5*
> >>
> >> Ah, many thanks -- hadn't read the new php stuff properly yet. :)
> >
> > Also quite everyone will want USE="pecl" to enable perl regular
> > expression, quite every php package use it.
>
> Isn't that included in the pcre flag?

it *is* the pcre flag, problem in multitasking thinking

>
> Yours,
> Craig
> --
> Craig Webster | t: +44 (0)131 516 8595 | e: craig@xeriom.net
> Xeriom.NET    | f: +44 (0)709 287 1902 | w: http://xeriom.net
-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Luca Longinotti]

[-- Attachment #1: Type: text/plain, Size: 927 bytes --]

Craig Webster wrote:

> On 22 Oct 2005, at 20:43, Francesco R. wrote:
>
>> Alle 16:51, sabato 22 ottobre 2005, Craig Webster ha scritto:
>>
>>> On 22 Oct 2005, at 15:32, Luca Longinotti wrote:
>>>
>>>> USE="apache2" emerge =dev-lang/php-5*
>>>
>>> Ah, many thanks -- hadn't read the new php stuff properly yet. :)
>>
>> Also quite everyone will want USE="pecl" to enable perl regular
>> expression, quite every php package use it.
>
>
> Isn't that included in the pcre flag?

Yeah correct, "pcre" USE flag in dev-lang/php enables
PerlCompatibleRegularExpressions, and also please don't forget the
"session" USE flag, both "pcre" and "session" are used by practically
any script and not having them causes obviously failures in the scripts.

-- 
Best regards,
Luca Longinotti aka CHTEKK

LongiTEKK Networks Admin: chtekk@longitekk.com
Gentoo Dev: chtekk@gentoo.org
MaxDev Dev: chtekk@maxdev.com
TILUG Supporter: chtekk@tilug.ch

[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 256 bytes --]

Re: [gentoo-server] mysql-4.1

[Petteri Räty]

[-- Attachment #1: Type: text/plain, Size: 1171 bytes --]

Luca Longinotti wrote:
> Craig Webster wrote:
> 
> 
>>On 22 Oct 2005, at 20:43, Francesco R. wrote:
>>
>>
>>>Alle 16:51, sabato 22 ottobre 2005, Craig Webster ha scritto:
>>>
>>>
>>>>On 22 Oct 2005, at 15:32, Luca Longinotti wrote:
>>>>
>>>>
>>>>>USE="apache2" emerge =dev-lang/php-5*
>>>>
>>>>Ah, many thanks -- hadn't read the new php stuff properly yet. :)
>>>
>>>Also quite everyone will want USE="pecl" to enable perl regular
>>>expression, quite every php package use it.
>>
>>
>>Isn't that included in the pcre flag?
> 
> 
> Yeah correct, "pcre" USE flag in dev-lang/php enables
> PerlCompatibleRegularExpressions, and also please don't forget the
> "session" USE flag, both "pcre" and "session" are used by practically
> any script and not having them causes obviously failures in the scripts.
> 

So is there any reason for having these use flags if they cause so many
gray hairs for users? They could be added on the day when we have the
support to turn on local use flags by default. Or at least they should
be moved under for example the minimal use flag so they would get
installed by default.

Regards,
Petteri Räty


[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 256 bytes --]

Re: [gentoo-server] mysql-4.1

[Barry Marler]

On 10/22/05, Lance Albertson <ramereth@gentoo.org> wrote:
> Barry Marler wrote:
>
> > The upgrade TOTALLY pfutzed my test box. After installing 4.1,
> > revdep-rebuild wanted to build a bunch of ~x86 stuff (mod_php among
> > them). I went back to the old version. I have three production servers
> > running MySQL/Apache2/PHP, none of which will get this upgrade. For
> > the 1st time in 3 years, Gentoo is really pissing me off.
>
> Have you updated to the new Gentoo apache layout? If not, I imagine that
> might be what have happened (and I'm not too happy about it myself). The
> one thing that seems odd is that revdep is pulling ~x86 versions. Are
> you sure its doing that, or is it pulling the new apache layout stuff
> that appears to be ~x86 but is really stable now?
>
> Believe me, I've complained about the whole 'apache upgrade' crap. I'm
> just as pissed as you (and I'm even a developer!).
>
> Best of luck and let us know if we can help you in any way.
>
> --
> Lance Albertson <ramereth@gentoo.org>
> Gentoo Infrastructure | Operations Manager
>
> ---
> GPG Public Key:  <http://www.ramereth.net/lance.asc>
> Key fingerprint: 0423 92F3 544A 1282 5AB1  4D07 416F A15D 27F4 B742
>
> ramereth/irc.freenode.net

No, I upgraded Apache a while ago.

-- 
gentoo-server@gentoo.org mailing list

Re: [gentoo-server] mysql-4.1

[Francesco R.]

> The upgrade TOTALLY pfutzed my test box. After installing 4.1,
> revdep-rebuild wanted to build a bunch of ~x86 stuff (mod_php among
> them). I went back to the old version. I have three production
> servers running MySQL/Apache2/PHP, none of which will get this
> upgrade. For the 1st time in 3 years, Gentoo is really pissing me
> off.

use 
# revdep-rebuild --soname=libmysqlclient.so.12
as suggested from Lance Albertson in this thread, look like the best 
solution to rebuild everything was using mysql-4.0 libraries.

For the record it's 

libmysqlclient.so.12 = mysql-4.0
libmysqlclient.so.14 = mysql-4.1
libmysqlclient.so.15 = mysql-5.0

Regards,
Francesco
-- 
gentoo-server@gentoo.org mailing list