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 t...
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=...
Running 'mysqlcheck' with connection arguments: '--port=...
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([total|today|yesterday]);
終了行:
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 t...
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=...
Running 'mysqlcheck' with connection arguments: '--port=...
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([total|today|yesterday]);
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
