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.
> I dumped the tables that it was complaining about first, and then
> dumped the triggers.
> I then uninstalled anything to do with mysql, and installed 5.1
> Then imported the tables and triggers, and and able to run
> mysql_upgrade without any errors.
> This is all without using a full mysqldump.
> I am now going to go from 5.1 to 5.5
> On Wed, Feb 20, 2013 at 12:54 PM, Mike Franon <kongfranon@stripped> wrote:
>> 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.reindl@stripped>
>>> 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
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc