Am 19.02.2013 23:53, schrieb Divesh Kamra: > Hi Reindi > > > Thanks for solution ......... > > Can u share complete steps ?
which steps? * update * call "mysql_upgrade -u root -p" in doubt "mysqlcheck -h localhost --check-upgrade --all-databases --auto-repair --user=root -p" and if you do "mysql_upgrade -u root -p" and are always up-to-date that was it, no matter if you move your data from windows to MacOSX and finally to linux or whatever OS > On 20-Feb-2013, at 2:50, Reindl Harald <h.rei...@thelounge.net> 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.rei...@thelounge.net> wrote: >>>> >>>> Am 16.02.2013 09:42, schrieb Manuel Arostegui: >>>>> 2013/2/15 Reindl Harald <h.rei...@thelounge.net >>>>> <mailto:h.rei...@thelounge.net>> >>>>> >>>>> "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 >> -- Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / CISO / Software-Development p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature