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 <h.rei...@thelounge.net> wrote: > > > Am 20.02.2013 18:26, schrieb Mike Franon: >> So I did a full mysqldump over the weekend for a second time and this >> 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 got >> 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=root -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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql