From: Reindl Harald
Date: February 19 2013 9:20pm
Subject: Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6
List-Archive: http://lists.mysql.com/mysql/229012
Message-Id: <5123ECB0.1010408@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="----enig2XFISLXTGVBUBWBEWFEKB"

------enig2XFISLXTGVBUBWBEWFEKB
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 w=
ith mysqldump
>=20
> Or if there any tool for this=20
>=20
> R's
> DK
>=20
> 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@thel=
ounge.net>>
>>>
>>>    "our database is 400 GB, mysqldump is 600MB" was not a typo and yo=
u
>>>    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 b=
lank 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


------enig2XFISLXTGVBUBWBEWFEKB
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/

iEYEARECAAYFAlEj7LAACgkQhmBjz394AnmCNgCbB4wv3AJh+8MSt1Vpv9rxFu7W
fNsAoJufe0xkbFt0B5O3fZqe4JEDd4tE
=TD42
-----END PGP SIGNATURE-----

------enig2XFISLXTGVBUBWBEWFEKB--