Re: [gentoo-server] mysql-4.1

[Dave Strydom]

try with my scripts?

On 10/22/05, Barry Marler <barry.marler@×××××.com> wrote:
>
> On 10/22/05, Dave Strydom <strydom.dave@×××××.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@×××××.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@g.o mailing list
>
>