![\"logo-mysql-110x57\"](\"https:\/\/www.nazca.hu\/wp-content\/uploads\/2013\/01\/logo-mysql-110x57.png\" "\\"MySQL\\""){kind=logo}
A MySQL 5.5 referencia k\u00e9zik\u00f6nyv<\/a> alapj\u00e1n az \u00e1ltal\u00e1nos szab\u00e1ly az, hogy az egyik kiad\u00e1si sorozatr\u00f3l az \u00e1tt\u00e9r\u00e9st egy m\u00e1sikra l\u00e9p\u00e9senk\u00e9nt aj\u00e1nlott v\u00e9grehajtani, a k\u00f6zbens\u0151 sorozatok kihagy\u00e1sa n\u00e9lk\u00fcl.<\/p>\nAhhoz, hogy \u00e1tt\u00e9rjen a MySQL 5.5 verzi\u00f3t megel\u0151z\u0151 kiad\u00e1si sorozatr\u00f3l, t\u00e9rjen \u00e1t sorban az egym\u00e1s k\u00f6vet\u0151 kiad\u00e1si sorozatokra mindaddig, am\u00edg el nem \u00e9ri a\u00a0 MySQL 5.5 verzi\u00f3t. P\u00e9ld\u00e1ul, ha jelenleg a MySQL 5.0 verzi\u00f3t futtatja \u00e9s \u00e1t szeretne t\u00e9rni egy \u00fajabb \u00fajabb sorozatra, akkor el\u0151bb t\u00e9rjen \u00e1t a MySQL 5.1 verzi\u00f3ra miel\u0151tt \u00e1tt\u00e9rne az 5.5 verzi\u00f3ra, \u00e9s \u00edgy tov\u00e1bb.<\/p>\n
Figyelmeztet\u00e9s<\/strong>: Mindenf\u00e9le \u00e1tt\u00e9r\u00e9s megkezd\u00e9se el\u0151tt k\u00e9sz\u00edtsen adatment\u00e9st adatb\u00e1zisair\u00f3l, bele\u00e9rtve a mysql <\/strong>adatb\u00e1zist is, amely tartalmazza az enged\u00e9lyek t\u00e1bl\u00e1j\u00e1t. MySQL adatb\u00e1zis ment\u00e9si m\u00f3dszerek<\/a><\/h6>\nM\u00f3dszerek<\/h2>\n
Az \u00e1tt\u00e9r\u00e9s v\u00e9grehajt\u00e1s\u00e1nak alapvet\u0151en k\u00e9t m\u00f3dja van: a bin\u00e1ris (in-place) \u00e9s a ment\u00e9s\/vissza\u00e1ll\u00edt\u00e1s (dump\/restore).<\/p>\n
\n- A bin\u00e1ris<\/strong> m\u00f3dszer eset\u00e9n az \u00e1tt\u00e9r\u00e9s k\u00f6zben az adatb\u00e1zisok f\u00e1jljai \u00e9rintetetlenek maradnak, ezeken az \u00faj verzi\u00f3ra val\u00f3 \u00e1tt\u00e9r\u00e9s ut\u00e1n le kell futtatni a mysql_upgrade<\/a><\/strong> programot.<\/li>\n
- A m\u00e1sik m\u00f3dszer a ment\u00e9s\/vissza\u00e1ll\u00edt\u00e1s<\/strong> (dump\/restore) elj\u00e1r\u00e1s. Ennek sor\u00e1n az adatb\u00e1zisokat export\u00e1lni kell az \u00e1tt\u00e9r\u00e9s megkezd\u00e9se el\u0151tt, majd az \u00faj verzi\u00f3ra val\u00f3 \u00e1tt\u00e9r\u00e9s ut\u00e1n vissza kell \u00e1ll\u00edtani az adatb\u00e1zisokat. Enn\u00e9l a m\u00f3dszern\u00e9l is le kell futtatni a mysql_upgrade<\/a><\/strong> programot, hogy a MySQL specifikus adatb\u00e1zisok (pl. felhaszn\u00e1l\u00f3-nyilv\u00e1ntart\u00e1s) friss\u00edtve legyenek.<\/li>\n<\/ul>\n
Sajnos a szem\u00e9lyes tapasztalok azt mutatj\u00e1k, hogy a MySQL 5.0 verzi\u00f3r\u00f3l az 5.1-es verzi\u00f3ra val\u00f3 bin\u00e1ris m\u00f3dszer nem igaz\u00e1n megy z\u00f6kken\u0151mentesen, ez\u00e9rt itt a m\u00e1sodik m\u00f3dszer ker\u00fcl bemutat\u00e1sra.<\/p>\n
A bin\u00e1ris m\u00f3dszert a MySQL 5.1 verzi\u00f3r\u00f3l az 5.5 verzi\u00f3ra val\u00f3 \u00e1tt\u00e9r\u00e9sn\u00e9l tal\u00e1lhat\u00f3 meg.<\/a><\/p>\nElj\u00e1r\u00e1s (dump\/restore)<\/h2>\n
Itt minden fontos l\u00e9p\u00e9st megtal\u00e1lhat az \u00e1tt\u00e9r\u00e9s megfelel\u0151 v\u00e9grehajt\u00e1s\u00e1hoz.<\/p>\n
\n- Az els\u0151 \u00e9s legfontosabb l\u00e9p\u00e9s a biztons\u00e1gi ment\u00e9s k\u00e9sz\u00edt\u00e9se<\/strong><\/a> az adatb\u00e1zisokr\u00f3l, m\u00e9gpedig oly m\u00f3don, hogy az egyes adatb\u00e1zisok k\u00fcl\u00f6n sql<\/em> f\u00e1jlba ker\u00fcljenek.
\nFontos, hogy lementse a mysql<\/strong> adatb\u00e1zist, mert ebben vannak a felhaszn\u00e1l\u00f3k \u00e9s az enged\u00e9lyek!
\nAz adatment\u00e9s el\u0151tt \u00e1ll\u00edtsa le az \u00f6sszes alkalmaz\u00e1st, amely haszn\u00e1lja MySQL adatb\u00e1zist.<\/li>\n- Ellen\u0151rizni kell, hogy mely portok f\u00fcggnek az aktu\u00e1lisan telep\u00edtett mysql-client<\/em> verzi\u00f3t\u00f3l, ez a k\u00f6vetkez\u0151 paranccsal tehet\u0151 meg:
\n[shell]# portupgrade -frn mysql-client[\/shell]<\/p>\nEz a parancs megpr\u00f3b\u00e1lja \u00fajraford\u00edtani az \u00f6sszes olyan portot, amely f\u00fcgg a mysql-client<\/em> portt\u00f3l, mivel azonban az -n<\/em> kapcsol\u00f3 is meg lett adva, ez\u00e9rt nem lesz v\u00e9grehajtva semmi (csak egy teszt fut le). A parancs eredm\u00e9nyek\u00e9nt egy r\u00f6videbb-hosszabb list\u00e1t fog kapni azokr\u00f3l a portokr\u00f3l, amelyekhez sz\u00fcks\u00e9ges, hogy a mysql-client<\/em> port helyesen m\u0171k\u00f6dj\u00f6n.<\/p>\n[shell gutter=”false” toolbar=”false”]…
\n + databases\/mysql50-client (mysql-client-5.0.95 ->; mysql-client-5.0.95)
\n + databases\/mysql50-server (mysql-server-5.0.95 ->; mysql-server-5.0.95)
\n + mail\/dovecot (dovecot-1.2.17 ->; dovecot-1.2.17)
\n + security\/cyrus-sasl2 (cyrus-sasl-2.1.26_2 ->; cyrus-sasl-2.1.26_2)
\n + mail\/postfix28 (postfix-2.8.12_2,1 ->; postfix-2.8.12_2,1)
\n + databases\/p5-DBD-mysql (p5-DBD-mysql-4.021 ->; p5-DBD-mysql-4.021)
\n + security\/amavisd-new (amavisd-new-2.8.0_2,1 ->; amavisd-new-2.8.0_2,1)
\n + mail\/dovecot-sieve (dovecot-sieve-1.2+0.1.19 ->; dovecot-sieve-1.2+0.1.19)
\n + databases\/mysql50-scripts (mysql-scripts-5.0.95 ->; mysql-scripts-5.0.95)
\n + mail\/dovecot-managesieve (dovecot-managesieve-0.11.13 ->; dovecot-managesieve-0.11.13)
\n + security\/maia (maia-1.0.3.r1575_3 ->; maia-1.0.3.r1575_3)
\n…[\/shell]<\/li>\n
- Mentse el a list\u00e1t egy biztons\u00e1gos helyre, mivel k\u00e9s\u0151bb sz\u00fcks\u00e9g lesz m\u00e9g r\u00e1 (a list\u00e1r\u00f3l elt\u00e1vol\u00edthatja a mysql-client<\/em>, mysql-server<\/em> \u00e9s mysql-scripts<\/em> portokat, mivel ezek egy\u00e9bk\u00e9nt is friss\u00edtve lesznek)<\/li>\n
- T\u00e1vol\u00edtsa el a mysql50-client<\/em>, mysql50-server<\/em> \u00e9s mysql50-scripts<\/em> portokat.
\n[shell gutter=”false” toolbar=”false”]# cd \/usr\/ports\/databases\/mysql50-client
\n# make deinstall
\n# cd \/usr\/ports\/databases\/mysql50-server
\n# make deinstall
\n# cd \/usr\/ports\/databases\/mysql50-scripts
\n# make deinstall[\/shell]<\/li>\n- Mivel ez most nem a bin\u00e1ris (in-place) m\u00f3dszer, ez\u00e9rt mindent el kell t\u00e1vol\u00edtani a MySQL adat\u00fatvonal\u00e1r\u00f3l. Ez FreeBSD<\/strong> est\u00e9n alap\u00e9rtelmez\u00e9sben a \/var\/db\/mysql<\/em> \u00fatvonalon tal\u00e1lhat\u00f3. Miel\u0151tt mindent kit\u00f6r\u00f6lne vagy \u00e1thelyezne innen, ellen\u0151rizze, hogy rendelkezik-e \u00e9rv\u00e9nyes \u00e9s m\u0171k\u00f6d\u0151 biztons\u00e1gi ment\u00e9ssel<\/a> adatb\u00e1zisair\u00f3l!<\/strong>
\nFontos, hogy a MySQL konfigur\u00e1ci\u00f3s f\u00e1jlj\u00e1r\u00f3l (\/usr\/local\/etcl\/my.cnf<\/em>) is k\u00e9sz\u00edtsen biztons\u00e1gi ment\u00e9st, mert a be\u00e1ll\u00edt\u00e1sokat \u00e1t kell vinni majd az \u00faj verzi\u00f3 konfigur\u00e1ci\u00f3s f\u00e1jlj\u00e1ba.<\/li>\n- Most telep\u00edtse a mysql51-server<\/em> portot, ez automatikusan telep\u00edteni fogja a mysql51-client<\/em> portot is.
\n[shell gutter=”false” toolbar=”false”]# cd \/usr\/ports\/databases\/mysql51-server
\n# make install clean[\/shell]<\/p>\nSz\u00fcks\u00e9g eset\u00e9n telep\u00edtse a mysql51-scripts<\/em> portot is.<\/p>\n[shell gutter=”false” toolbar=”false”]# cd \/usr\/ports\/databases\/mysql51-scripts
\n# make install clean[\/shell]<\/li>\n
- Hozza l\u00e9tre a \/usr\/local\/etc\/my.cnf<\/em> konfigur\u00e1ci\u00f3s f\u00e1jlt a megfelel\u0151 my-{small,medium,large,huge}.cnf<\/em> f\u00e1jlb\u00f3l a \/usr\/local\/share\/mysql<\/em> \u00fatvonalr\u00f3l (a be\u00e1ll\u00edt\u00e1sok megv\u00e1ltoztak). Vigye \u00e1t a sz\u00fcks\u00e9ges be\u00e1ll\u00edt\u00e1sokat a r\u00e9gi konfigur\u00e1ci\u00f3s f\u00e1jlb\u00f3l az \u00faj konfigur\u00e1ci\u00f3s f\u00e1jlba.
\n\u00c1ll\u00edtsa be a \/usr\/local\/etc\/my.cnf<\/em> f\u00e1jl megfelel\u0151en:
\n[shell gutter=”false” toolbar=”false”]# chown mysql:mysql \/usr\/local\/etc\/my.cnf
\n# chmod 644 \/usr\/local\/etc\/my.cnf[\/shell]<\/li>\n- Ind\u00edtsa el a MySQL 5.1 adatb\u00e1zis kiszolg\u00e1l\u00f3t.
\n[shell gutter=”false” toolbar=”false”]# \/usr\/local\/etc\/rc.d\/mysql-server start[\/shell]<\/p>\nAutomatikusan l\u00e9trej\u00f6nnek az alap\u00e9rtelmezett adatb\u00e1zisok (mysql<\/em>, performance_schema<\/em>, test<\/em>) a \/var\/db\/mysql<\/em> \u00fatvonalon, valamint InnoDB<\/strong> eset\u00e9n a napl\u00f3f\u00e1jlok.<\/li>\n- Most, hogy m\u00e1r telep\u00edtve van \u00e9s fut a MySQL 5.1, de az \u00f6sszes \u00e9rintett szoftver m\u00e9g az 5.0-\u00e1s klienst haszn\u00e1lja, ez\u00e9rt most m\u00e9g ne ind\u00edtsa \u00fajra a szoftvereket. Most vegye el\u0151 a portok elmentett list\u00e1j\u00e1t, \u00e9s ford\u00edtsa \u00fajra minden egyes elem\u00e9t.
\nKezdje pl. a postfix<\/strong> \u00e9s hozz\u00e1 sz\u00fcks\u00e9ges portokkal:
\n[shell gutter=”false” toolbar=”false”]# portupgrade -fO postfix
\n# portupgrade -fO p5-DBD-mysql
\n…[\/shell]<\/p>\nA portok friss\u00edt\u00e9se ut\u00e1n ellen\u0151rizze le a portok adatb\u00e1zis\u00e1t a k\u00f6vetkez\u0151 paranccsal, hogy minden rendben van-e.<\/p>\n
[shell gutter=”false” toolbar=”false”]# pkgdb -F[\/shell]<\/li>\n
- Most m\u00e1r csak az adatb\u00e1zisokat kell vissza\u00e1ll\u00edtani. Els\u0151k\u00e9nt a mysql<\/strong> adatb\u00e1zist kell vissza\u00e1ll\u00edtani \u00e9s lefuttatni rajta a friss\u00edt\u00e9st. (A jelsz\u00f3 nem kell megadni, mert m\u00e9g nincs meghat\u00e1rozva.)
\n[shell gutter=”false” toolbar=”false”]# mysql -uroot mysql < mysql.sql
\n# mysql_upgrade -uroot
\nLooking for ‘mysql’ as: mysql
\nLooking for ‘mysqlcheck’ as: mysqlcheck
\nRunning ‘mysqlcheck’ with connection arguments: ‘–port=3306’ ‘–socket=\/tmp\/mysql.sock’
\nRunning ‘mysqlcheck’ with connection arguments: ‘–port=3306’ ‘–socket=\/tmp\/mysql.sock’
\nmysql.columns_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.db\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.event\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.func\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.general_log\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.help_category\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.help_keyword\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.help_relation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.help_topic\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.host\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.ndb_binlog_index\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.plugin\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.proc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.procs_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.proxies_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.servers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.slow_log\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.tables_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.time_zone\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.time_zone_leap_second\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.time_zone_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.time_zone_transition\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.time_zone_transition_type\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.user\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.user_info\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nRunning ‘mysql_fix_privilege_tables’…
\nOK[\/shell]<\/li>\n- Ezut\u00e1n \u00e9rdemes \u00fajraind\u00edtani a mysql-server<\/em> d\u00e9mont, hogy ellen\u0151rizni lehessen, minden rendben van az adatb\u00e1zisok visszaolvas\u00e1sa el\u0151tt.
\n[shell gutter=”false” toolbar=”false”]# \/usr\/local\/etc\/rc.d\/mysql-server restart[\/shell]<\/p>\nEzt\u00e1n m\u00e1r csak a kor\u00e1bbi felhaszn\u00e1l\u00f3kkal \u00e9s a hozz\u00e1tartoz\u00f3 jelszavakkal lehet bel\u00e9pni.<\/li>\n
- Ezut\u00e1n j\u00f6het a t\u00f6bbi adatb\u00e1zisok vissza\u00e1ll\u00edt\u00e1sa a ment\u00e9sb\u0151l<\/a>. Hajtsa v\u00e9gre az adatb\u00e1zisok visszaolvas\u00e1s\u00e1t egyes\u00e9vel.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
A MySQL 5.0 akt\u00edv t\u00e1mogat\u00e1sa 2009. december 31-\u00e9n befejez\u0151d\u00f6tt \u00e9s beker\u00fclt a kiterjesztett t\u00e1mogat\u00e1si f\u00e1zisba, majd 2012. janu\u00e1r 9-\u00e9n \u00e1tker\u00fclt a fenntart\u00e1si t\u00e1mogat\u00e1s al\u00e1. Ezt azt jelenti, hogy nem lesznek \u00faj kiad\u00e1sok, nem k\u00e9sz\u00fclnek hozz\u00e1 \u00faj jav\u00edt\u00e1sok \u00e9s \u00faj friss\u00edt\u00e9sek, csak a m\u00e1r l\u00e9tez\u0151 friss\u00edt\u00e9sek, jav\u00edt\u00e1sok \u00e9s riaszt\u00e1sok lesznek el\u00e9rhet\u0151k.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,11],"tags":[27,38,119,6,36,5,122,120,121,37,39],"_links":{"self":[{"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/posts\/2976"}],"collection":[{"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/comments?post=2976"}],"version-history":[{"count":5,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/posts\/2976\/revisions"}],"predecessor-version":[{"id":5555,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/posts\/2976\/revisions\/5555"}],"wp:attachment":[{"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/media?parent=2976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/categories?post=2976"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/tags?post=2976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Sajnos a szem\u00e9lyes tapasztalok azt mutatj\u00e1k, hogy a MySQL 5.0 verzi\u00f3r\u00f3l az 5.1-es verzi\u00f3ra val\u00f3 bin\u00e1ris m\u00f3dszer nem igaz\u00e1n megy z\u00f6kken\u0151mentesen, ez\u00e9rt itt a m\u00e1sodik m\u00f3dszer ker\u00fcl bemutat\u00e1sra.<\/p>\n
A bin\u00e1ris m\u00f3dszert a MySQL 5.1 verzi\u00f3r\u00f3l az 5.5 verzi\u00f3ra val\u00f3 \u00e1tt\u00e9r\u00e9sn\u00e9l tal\u00e1lhat\u00f3 meg.<\/a><\/p>\n Itt minden fontos l\u00e9p\u00e9st megtal\u00e1lhat az \u00e1tt\u00e9r\u00e9s megfelel\u0151 v\u00e9grehajt\u00e1s\u00e1hoz.<\/p>\n Ez a parancs megpr\u00f3b\u00e1lja \u00fajraford\u00edtani az \u00f6sszes olyan portot, amely f\u00fcgg a mysql-client<\/em> portt\u00f3l, mivel azonban az -n<\/em> kapcsol\u00f3 is meg lett adva, ez\u00e9rt nem lesz v\u00e9grehajtva semmi (csak egy teszt fut le). A parancs eredm\u00e9nyek\u00e9nt egy r\u00f6videbb-hosszabb list\u00e1t fog kapni azokr\u00f3l a portokr\u00f3l, amelyekhez sz\u00fcks\u00e9ges, hogy a mysql-client<\/em> port helyesen m\u0171k\u00f6dj\u00f6n.<\/p>\n [shell gutter=”false” toolbar=”false”]… Sz\u00fcks\u00e9g eset\u00e9n telep\u00edtse a mysql51-scripts<\/em> portot is.<\/p>\n [shell gutter=”false” toolbar=”false”]# cd \/usr\/ports\/databases\/mysql51-scripts Automatikusan l\u00e9trej\u00f6nnek az alap\u00e9rtelmezett adatb\u00e1zisok (mysql<\/em>, performance_schema<\/em>, test<\/em>) a \/var\/db\/mysql<\/em> \u00fatvonalon, valamint InnoDB<\/strong> eset\u00e9n a napl\u00f3f\u00e1jlok.<\/li>\n A portok friss\u00edt\u00e9se ut\u00e1n ellen\u0151rizze le a portok adatb\u00e1zis\u00e1t a k\u00f6vetkez\u0151 paranccsal, hogy minden rendben van-e.<\/p>\n [shell gutter=”false” toolbar=”false”]# pkgdb -F[\/shell]<\/li>\n Ezt\u00e1n m\u00e1r csak a kor\u00e1bbi felhaszn\u00e1l\u00f3kkal \u00e9s a hozz\u00e1tartoz\u00f3 jelszavakkal lehet bel\u00e9pni.<\/li>\n A MySQL 5.0 akt\u00edv t\u00e1mogat\u00e1sa 2009. december 31-\u00e9n befejez\u0151d\u00f6tt \u00e9s beker\u00fclt a kiterjesztett t\u00e1mogat\u00e1si f\u00e1zisba, majd 2012. janu\u00e1r 9-\u00e9n \u00e1tker\u00fclt a fenntart\u00e1si t\u00e1mogat\u00e1s al\u00e1. Ezt azt jelenti, hogy nem lesznek \u00faj kiad\u00e1sok, nem k\u00e9sz\u00fclnek hozz\u00e1 \u00faj jav\u00edt\u00e1sok \u00e9s \u00faj friss\u00edt\u00e9sek, csak a m\u00e1r l\u00e9tez\u0151 friss\u00edt\u00e9sek, jav\u00edt\u00e1sok \u00e9s riaszt\u00e1sok lesznek el\u00e9rhet\u0151k.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,11],"tags":[27,38,119,6,36,5,122,120,121,37,39],"_links":{"self":[{"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/posts\/2976"}],"collection":[{"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/comments?post=2976"}],"version-history":[{"count":5,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/posts\/2976\/revisions"}],"predecessor-version":[{"id":5555,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/posts\/2976\/revisions\/5555"}],"wp:attachment":[{"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/media?parent=2976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/categories?post=2976"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/tags?post=2976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Elj\u00e1r\u00e1s (dump\/restore)<\/h2>\n
\n
\nFontos, hogy lementse a mysql<\/strong> adatb\u00e1zist, mert ebben vannak a felhaszn\u00e1l\u00f3k \u00e9s az enged\u00e9lyek!
\nAz adatment\u00e9s el\u0151tt \u00e1ll\u00edtsa le az \u00f6sszes alkalmaz\u00e1st, amely haszn\u00e1lja MySQL adatb\u00e1zist.<\/li>\n
\n[shell]# portupgrade -frn mysql-client[\/shell]<\/p>\n
\n + databases\/mysql50-client (mysql-client-5.0.95 ->; mysql-client-5.0.95)
\n + databases\/mysql50-server (mysql-server-5.0.95 ->; mysql-server-5.0.95)
\n + mail\/dovecot (dovecot-1.2.17 ->; dovecot-1.2.17)
\n + security\/cyrus-sasl2 (cyrus-sasl-2.1.26_2 ->; cyrus-sasl-2.1.26_2)
\n + mail\/postfix28 (postfix-2.8.12_2,1 ->; postfix-2.8.12_2,1)
\n + databases\/p5-DBD-mysql (p5-DBD-mysql-4.021 ->; p5-DBD-mysql-4.021)
\n + security\/amavisd-new (amavisd-new-2.8.0_2,1 ->; amavisd-new-2.8.0_2,1)
\n + mail\/dovecot-sieve (dovecot-sieve-1.2+0.1.19 ->; dovecot-sieve-1.2+0.1.19)
\n + databases\/mysql50-scripts (mysql-scripts-5.0.95 ->; mysql-scripts-5.0.95)
\n + mail\/dovecot-managesieve (dovecot-managesieve-0.11.13 ->; dovecot-managesieve-0.11.13)
\n + security\/maia (maia-1.0.3.r1575_3 ->; maia-1.0.3.r1575_3)
\n…[\/shell]<\/li>\n
\n[shell gutter=”false” toolbar=”false”]# cd \/usr\/ports\/databases\/mysql50-client
\n# make deinstall
\n# cd \/usr\/ports\/databases\/mysql50-server
\n# make deinstall
\n# cd \/usr\/ports\/databases\/mysql50-scripts
\n# make deinstall[\/shell]<\/li>\n
\nFontos, hogy a MySQL konfigur\u00e1ci\u00f3s f\u00e1jlj\u00e1r\u00f3l (\/usr\/local\/etcl\/my.cnf<\/em>) is k\u00e9sz\u00edtsen biztons\u00e1gi ment\u00e9st, mert a be\u00e1ll\u00edt\u00e1sokat \u00e1t kell vinni majd az \u00faj verzi\u00f3 konfigur\u00e1ci\u00f3s f\u00e1jlj\u00e1ba.<\/li>\n
\n[shell gutter=”false” toolbar=”false”]# cd \/usr\/ports\/databases\/mysql51-server
\n# make install clean[\/shell]<\/p>\n
\n# make install clean[\/shell]<\/li>\n
\n\u00c1ll\u00edtsa be a \/usr\/local\/etc\/my.cnf<\/em> f\u00e1jl megfelel\u0151en:
\n[shell gutter=”false” toolbar=”false”]# chown mysql:mysql \/usr\/local\/etc\/my.cnf
\n# chmod 644 \/usr\/local\/etc\/my.cnf[\/shell]<\/li>\n
\n[shell gutter=”false” toolbar=”false”]# \/usr\/local\/etc\/rc.d\/mysql-server start[\/shell]<\/p>\n
\nKezdje pl. a postfix<\/strong> \u00e9s hozz\u00e1 sz\u00fcks\u00e9ges portokkal:
\n[shell gutter=”false” toolbar=”false”]# portupgrade -fO postfix
\n# portupgrade -fO p5-DBD-mysql
\n…[\/shell]<\/p>\n
\n[shell gutter=”false” toolbar=”false”]# mysql -uroot mysql < mysql.sql
\n# mysql_upgrade -uroot
\nLooking for ‘mysql’ as: mysql
\nLooking for ‘mysqlcheck’ as: mysqlcheck
\nRunning ‘mysqlcheck’ with connection arguments: ‘–port=3306’ ‘–socket=\/tmp\/mysql.sock’
\nRunning ‘mysqlcheck’ with connection arguments: ‘–port=3306’ ‘–socket=\/tmp\/mysql.sock’
\nmysql.columns_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.db\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.event\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.func\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.general_log\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.help_category\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.help_keyword\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.help_relation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.help_topic\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.host\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.ndb_binlog_index\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.plugin\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.proc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.procs_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.proxies_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.servers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.slow_log\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.tables_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.time_zone\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.time_zone_leap_second\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.time_zone_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.time_zone_transition\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.time_zone_transition_type\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.user\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nmysql.user_info\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OK
\nRunning ‘mysql_fix_privilege_tables’…
\nOK[\/shell]<\/li>\n
\n[shell gutter=”false” toolbar=”false”]# \/usr\/local\/etc\/rc.d\/mysql-server restart[\/shell]<\/p>\n