From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.50) id 1ETJUs-0005Ba-2m for garchives@archives.gentoo.org; Sat, 22 Oct 2005 13:33:18 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id j9MDSOH8031400; Sat, 22 Oct 2005 13:28:24 GMT Received: from qproxy.gmail.com (qproxy.gmail.com [72.14.204.207]) by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id j9MDSNiu015807 for ; Sat, 22 Oct 2005 13:28:24 GMT Received: by qproxy.gmail.com with SMTP id o12so17970qba for ; Sat, 22 Oct 2005 06:31:17 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=aFOGas4akILjJZ9ffADiCqZwMJgYUAxYFsPNb/sPCshJa8zd+p3L801ovCxWILdFNgGZfAuJ35Jo8NbMh0sAM76G0jRU3X7G3G4e9nU3Djvey8EJ7cvy9EvlvMgTWXCC9qCz8Nrr6qszYN14Bf34SNdae/1FthFjLCaarZeZz78= Received: by 10.64.242.2 with SMTP id p2mr2430197qbh; Sat, 22 Oct 2005 06:31:17 -0700 (PDT) Received: by 10.64.195.18 with HTTP; Sat, 22 Oct 2005 06:31:17 -0700 (PDT) Message-ID: Date: Sat, 22 Oct 2005 15:31:17 +0200 From: Dave Strydom To: gentoo-server@lists.gentoo.org Subject: Re: [gentoo-server] mysql-4.1 In-Reply-To: Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-server@gentoo.org Reply-to: gentoo-server@lists.gentoo.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3097_11664254.1129987877739" References: <4357203B.2060500@munat.com> <43588B41.6040009@munat.com> <200510211207.26060.vivo@gentoo.org> <4358EB92.2010605@gentoo.org> X-Archives-Salt: d1ae8867-7da6-4fa1-be72-73e77b59b61e X-Archives-Hash: c8b6bd9bc7ca85c1eaee947563b0246b ------=_Part_3097_11664254.1129987877739 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline try with my scripts? On 10/22/05, Barry Marler wrote: > > On 10/22/05, Dave Strydom wrote: > > oh yeah, and change the --password=3D'' field to your own password, don= t > just > > copy past. > > > > Dave > > > > > > On 10/22/05, Dave Strydom 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 peopl= e > 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 > > > > > > > > > # =3D commands to type > > > =3D =3D comments > > > > > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > > > # mkdir -p /home/backup/mysql > > > # nano mysql_backup.php > > > > > > =3D=3D > > > =3D Place the code below into the mysql_backup.php and save the file = =3D > > > =3D=3D > > > > > > /*------mysql_backup.php---------*/ > > > > > print("mysql backup\n"); > > > foreach (glob('/var/lib/mysql/*') as $fullname) > > > { > > > $database =3D basename($fullname); > > > $command =3D sprintf('mysqldump -a -B %s -c -v -Q > > > /home/backup/mysql/%s.sql --password=3D\'Our@db$IG\'', $database, > $database); > > > > > > exec($command); > > > print($database . ' : ' . $command . "\n\n\n"); > > > > > > } > > > ?> > > > > > > > > > /*-----------------------------------------------------*/ > > > > > > # nano mysql_restore.php > > > > > > =3D=3D > > > =3D Place the code below in the mysql_restore.php and save the file = =3D > > > =3D=3D > > > > > > /*------mysql_retore.php---------*/ > > > > > > > > print("mysql backup\n"); > > > > > > $dir =3D '/home/backup/mysql/'; > > > if ($fp =3D opendir($dir)) > > > { > > > print('running...'); > > > while (($file =3D readdir($fp)) !=3D=3D FALSE) { > > > echo "$file\n"; > > > > > > $database =3D basename($file); > > > $command =3D sprintf('mysql < /home/backup/mysql/%s > > --password=3D\'Our@db$IG\'', $database); > > > print($database . ' : ' . $command . "\n\n\n"); > > > exec($command); > > > > > > } > > > closedir($fp); > > > } > > > else > > > { > > > print('cannot open path ' . $dir); > > > } > > > > > > ?> > > > > > > /*---------------*/ > > > > > > # php mysql_backup.php > > > > > > =3D=3D > > > =3D This will make individual backup's of all your databases, the rea= son > i > > make it create scripts for each database > > > =3D instead of just pumping it all into 1 database, is because if the= re > is a > > problem on like 486590 of a 5 million > > > =3D line file, its going to be a bitch to work with, this way it just > > simplifies matters > > > =3D=3D > > > > > > # 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 =3Dmysql-4.1.14 > > > # revdep-rebuild --soname libmysqlclient.so.12 > > > # php mysql_restore.php > > > # mysql_fix_privilege_tables > > --defaults-file=3D/etc/mysql/my.cnf --user=3Droot > > --password=3D'PASSWORD' > > > # /etc/init.d/mysql restart > > > > > > And thats it. > > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > > > > > > 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 > > ------=_Part_3097_11664254.1129987877739 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline try with my scripts?

On 10/22/05, <= b class=3D"gmail_sendername">Barry Marler <barry.marler@gmail.com> wrote:
On 10/22/05, Dave Strydom <str= ydom.dave@gmail.com> wrote:
> oh yeah, and change the --passwo= rd=3D'' field to your own password, dont just
> copy past.
> >  Dave
>
>
> On 10/22/05, Dave Strydom <= strydom.dave@gmail.com> wr= ote:
> > 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
> &= gt;
> >
> > #  =3D commands to type
> > = =3D  =3D comments
> >
> > =3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D
> > # mkdir -p /home/backup/mysql
> > # nano= mysql_backup.php
> >
> > =3D=3D
> > =3D Place the code below into th= e mysql_backup.php and save the file =3D
> > =3D=3D
> >> > /*------mysql_backup.php---------*/
> > <?
> = > print("mysql backup\n");
> > foreach (glob('/var/lib/mysql/*') as $fullname)
> > = {
> >         $database = =3D basename($fullname);
> >      &n= bsp;  $command =3D sprintf('mysqldump -a -B %s -c -v -Q >
> /= home/backup/mysql/%s.sql --password=3D\' Our@db$IG\'', $database, $database);
> >
> >  &= nbsp;      exec($command);
> >  = ;       print($database . ' : ' . $command . = "\n\n\n");
> >
> > }
> > ?>
>= >
> >
> > /*----------------------------------------------= -------*/
> >
> > # nano mysql_restore.php
> >> > =3D=3D
> > =3D Place the code below in the mysql_resto= re.php and save the file =3D
> > =3D=3D
> >
> > /*------mysql_retore.php----= -----*/
> > <?
> >
> > print("mysql back= up\n");
> >
> > $dir =3D '/home/backup/mysql/';
&= gt; > if ($fp =3D opendir($dir))
> > {
> >        = ; print('running...');
> >  while (($file =3D readdir($f= p)) !=3D=3D FALSE) {
> >      echo &= quot;$file\n";
> >
> >     =  $database =3D basename($file);
> >      $command =3D sprintf('mysql &l= t; /home/backup/mysql/%s
> --password=3D\'Our@db$IG\'', $database);> >      print($database . ' : ' . $c= ommand . "\n\n\n");
> >     &nb= sp;exec($command);
> >
> >  }
> >  closedir($f= p);
> > }
> > else
> > {
> >  = ;       print('cannot open path ' . $dir);> > }
> >
> > ?>
> >
> > /*---------------*/
> >
> > # php mysql_bac= kup.php
> >
> > =3D=3D
> > =3D This will make in= dividual backup's of all your databases, the reason i
> make it creat= e scripts for each database
> > =3D instead of just pumping it all into 1 database, is becaus= e if there is a
> problem on like 486590 of a 5 million
> > = =3D line file, its going to be a bitch to work with, this way it just
&g= t; simplifies matters
> > =3D=3D
> >
> > # quickpkg dev-db/mysql
&= gt; > # /etc/init.d/mysql stop
> > # emerge -C mysql
> &g= t; # rm -rf /var/lib/mysql/ /var/log/mysql
> > # emerge mysql
&= gt; > # etc-update
> > # emerge --config =3Dmysql-4.1.14
> > # revdep-rebui= ld --soname libmysqlclient.so.12
> > # php mysql_restore.php
&g= t; > # mysql_fix_privilege_tables
> --defaults-file=3D/etc/mysql/m= y.cnf --user=3Droot
> --password=3D'PASSWORD'
> > # /etc/init.d/mysql restart> >
> > And thats it.
> > =3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D
> >
> > Dave
> >
>>

The upgrade TOTALLY pfutzed my test box. After installing 4.1,
r= evdep-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
runnin= g 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 ma= iling list


------=_Part_3097_11664254.1129987877739-- -- gentoo-server@gentoo.org mailing list