List:General Discussion« Previous MessageNext Message »
From:Divesh Kamra Date:February 19 2013 10:53pm
Subject:Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6
View as plain text  
Hi Reindi


Thanks for solution .........

Can u share complete steps ? 

R's
DK

On 20-Feb-2013, at 2:50, Reindl Harald <h.reindl@stripped> wrote:

> surely
> 
> * use "mysql_upgrade -u root -p" after EACH update
> * upgrade regulary
> 
> we went from MySQL 3.x to 5.5.30 until know without
> any dump and here are around 5000 tables
> 
> Am 19.02.2013 22:12, schrieb Divesh Kamra:
>> Is there any better way for grade MySQL version without taking backup with
> mysqldump
>> 
>> Or if there any tool for this 
>> 
>> R's
>> DK
>> 
>> On 16-Feb-2013, at 16:07, Reindl Harald <h.reindl@stripped> wrote:
>>> 
>>> Am 16.02.2013 09:42, schrieb Manuel Arostegui:
>>>> 2013/2/15 Reindl Harald <h.reindl@stripped
> <mailto:h.reindl@stripped>>
>>>> 
>>>>   "our database is 400 GB, mysqldump is 600MB" was not a typo and you
>>>>   honestly believed that you can import this dump to somewhat?
>>>> 
>>>>   WTF - as admin you should be able to see if the things in front
>>>>   of you are theoretically possible before your start any action
>>>>   and 1:400 is impossible, specially because mysql-dumps are
>>>>   ALWAYS WAY LARGER then the databasses because they contain
>>>>   sql-statements and not only data
>>>> 
>>>> That's not completely true. If you have a poor maintained database or
> just tables with lot of writes and deletes
>>>> and you don't periodically optimize it - you can end up with lot of blank
> spaces in your tables which will use _a
>>>> lot_ of space. If you do a "du" or whatever to measure your database
> size...you can get really confused.
>>>> mysqldump obviously doesn't backup blank spaces and once you get rid of
> them, your database will use much less space.
>>> 
>>> ok, normally i expect there is a admin and doing his job
>>> especially for large datasets
> 
Thread
Upgrading form mysql 5.0.90 to 5.5 or 5.6Mike Franon14 Feb
  • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Akshay Suryavanshi14 Feb
    • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Mike Franon14 Feb
      • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Manuel Arostegui14 Feb
      • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Mihail Manolov14 Feb
        • RE: Upgrading form mysql 5.0.90 to 5.5 or 5.6Rick James14 Feb
        • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Singer Wang14 Feb
          • RE: Upgrading form mysql 5.0.90 to 5.5 or 5.6Rick James14 Feb
            • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Mihail Manolov14 Feb
              • RE: Upgrading form mysql 5.0.90 to 5.5 or 5.6Rick James14 Feb
            • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Singer Wang14 Feb
              • RE: Upgrading form mysql 5.0.90 to 5.5 or 5.6Rick James15 Feb
                • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Mike Franon15 Feb
                  • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Keith Murphy15 Feb
                    • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Mike Franon15 Feb
                      • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Keith Murphy15 Feb
                        • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Mike Franon15 Feb
                          • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Reindl Harald15 Feb
                            • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Johnny Withers15 Feb
                              • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Reindl Harald15 Feb
                            • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Akshay Suryavanshi15 Feb
                              • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Reindl Harald15 Feb
                            • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Manuel Arostegui16 Feb
                              • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Reindl Harald16 Feb
                                • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Divesh Kamra19 Feb
                                  • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Reindl Harald19 Feb
                                    • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Divesh Kamra19 Feb
                                      • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Reindl Harald19 Feb
                                        • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Mike Franon20 Feb
                                          • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Reindl Harald20 Feb
                                            • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Mike Franon20 Feb
                                              • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Mike Franon20 Feb
                                                • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Reindl Harald20 Feb
                                                  • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Mike Franon20 Feb
                                    • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Sabika Makhdoom19 Feb
                      • Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6Reindl Harald15 Feb