Mysql upgrade の変更点

• 追加された行はこの色です。
• 削除された行はこの色です。
• Mysql upgrade へ行く。
• Mysql upgrade の差分を削除

CONTENTS
#contents
----
Lastmodified　&lastmod;
----

* MySQL 起動スクリプト [#v5582d57]

 # /usr/local/etc/rc.d/mysql-server start ←デーモンを起動します
 # /usr/local/etc/rc.d/mysql-server restart ←デーモンを再起動します
 # /usr/local/etc/rc.d/mysql-server stop ←デーモンを停止します


* # mysql_upgrade -u root -p [#mbc69987]


 ************************************************************************
 
 Remember to run mysql_upgrade the first time you start the MySQL server
 after an upgrade from an earlier version.
 
 ************************************************************************




 # mysql_upgrade -u root -p
 Enter password:
 Looking for 'mysql' as: mysql
 Looking for 'mysqlcheck' as: mysqlcheck
 Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
 Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
 BB3.phpbb_acl_groups                               OK
 BB3.phpbb_acl_options                              OK
 BB3.phpbb_acl_roles                                OK
 BB3.phpbb_acl_roles_data                           OK
 BB3.phpbb_acl_users                                OK
 BB3.phpbb_attachments                              OK
 BB3.phpbb_banlist                                  OK
 BB3.phpbb_bbcodes                                  OK
 BB3.phpbb_bookmarks                                OK
 BB3.phpbb_bots                                     OK
 BB3.phpbb_config                                   OK
     :          :                                   :
 phpmyadmin.pma_designer_coords                     OK
 phpmyadmin.pma_history                             OK
 phpmyadmin.pma_pdf_pages                           OK
 phpmyadmin.pma_relation                            OK
 phpmyadmin.pma_table_coords                        OK
 phpmyadmin.pma_table_info                          OK
 phpmyadmin.pma_tracking                            OK
 phpmyadmin.pma_userconfig                          OK
 Running 'mysql_fix_privilege_tables'...
 OK
 root@piano2nd:/var/db/mysql_dist #
 
http://syamanaka.com/mysql-data-backup-mysqldump/

 #/bin/sh!
 setenv PAGER cat && \
 /usr/sbin/freebsd-update fetch && \
 /usr/sbin/freebsd-update install ; \
 /usr/sbin/portsnap fetch update && \
 /usr/local/sbin/portversion -vl'<' && \
 /usr/sbin/pkg audit -F
 /usr/local/bin/mysql_upgrade -u root -pPASSWORD   ←半角開けないで詰めて記述

----
Total access &counter(total);：本日 &counter(today);：昨日 &counter(yesterday);
#counter([total|today|yesterday]);