From: Reindl Harald Date: February 20 2013 7:33pm Subject: Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6 List-Archive: http://lists.mysql.com/mysql/229021 Message-Id: <5125250C.8030601@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="----enig2OUTDBWVXFPBNDBBQJBHF" ------enig2OUTDBWVXFPBNDBBQJBHF Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable fine and much faster and probably safer too :-) a backup with rsync is faster as dump/import and can be done with minimize downtime by use it twice, the first time hot-backup with running server and the second time after stop server to get the diffs doing rsync -> stop -> rsync -> start in a script may reduce the downtime to a few seconds Am 20.02.2013 20:29, schrieb Mike Franon: > OK I got it to work. >=20 > I dumped the tables that it was complaining about first, and then > dumped the triggers. >=20 > I then uninstalled anything to do with mysql, and installed 5.1 >=20 > Then imported the tables and triggers, and and able to run > mysql_upgrade without any errors. >=20 > This is all without using a full mysqldump. >=20 > I am now going to go from 5.1 to 5.5 >=20 >=20 >=20 > On Wed, Feb 20, 2013 at 12:54 PM, Mike Franon wr= ote: >> I am pretty sure I did, and when I did I got the following errors: >> >> >> Error: Table Upgrade Required, Please dump/reload to fix it >> >> >> I got that on 10 tables, and also got the following: >> >> Warning: Triggers for table ' have no creation context. >> >> I think it has to do with no triggers. >> >> >> I know hen I ran the mysql_upgrade it tired to auto repair but did not= >> work and failed. >> >> But I will give it a shot again, maybe I missed something. The other >> thing I was thinking was maybe I can just mysqldump those 10 tables >> that it fails on, and just restore those instead of my entire db. >> >> >> On Wed, Feb 20, 2013 at 12:43 PM, Reindl Harald wrote: >>> >>> >>> Am 20.02.2013 18:26, schrieb Mike Franon: >>>> So I did a full mysqldump over the weekend for a second time and thi= s >>>> time it is 220GB, no clue what happened last time, I should have >>>> realized looking at the file size something was wrong, but since I g= ot >>>> no errors did not think about it, and this time I timed it, took 7 >>>> hours to do a complete mysqldump >>>> >>>> Restoring it is not fun 18+ hours and counting, at this rate it will= >>>> be a week, there has to be a better way of doing this, and this is >>>> only going form 5.0 to 5.1 >>>> >>>> I know some are saying don't need to do a mysqldump, but if i don't = do >>>> it, the upgrade errors out on 10 tables, and then gives me errors >>>> about triggers >>> >>> and did you ALWAYS "mysql_upgarde -root -p" after ANY mysql-update? >>> at least before try a major upgrade? >>> >>> did you try "mysqlcheck -h localhost --check-upgrade --all-databases = --auto-repair --user=3Droot -p" >>> BEFORE the upgrade? did you try it ALSo after the upgrade? >>> >>> sorry, i do not believe that dump/import is needed and idoubt >>> it will not give better results ------enig2OUTDBWVXFPBNDBBQJBHF Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.13 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iEYEARECAAYFAlElJQwACgkQhmBjz394AnlIkgCgjCWbC2+rPgsXaUErqvYFYyHA L3YAn2XRvaPQVsl9jVdqpHhE5/lka+r0 =59B/ -----END PGP SIGNATURE----- ------enig2OUTDBWVXFPBNDBBQJBHF--