3-5 資料庫格式升級轉換 5.0.x ---> 現在版本
3-6 txt
~# apt-get install automysqlbackup
正在讀取套件清單... 完成
正在重建相依關係
正在讀取狀態資料... 完成
下列【新】套件將會被安裝：
automysqlbackup
升級 0 個，新安裝 1 個，移除 0 個，有 0 個未被升級。
需要下載 14.9 kB 的套件檔。
此操作完成之後，會多佔用 100 kB 的磁碟空間。
下載:1 http://opensource.nchc.org.tw/debian/ wheezy/main automysqlbackup all 2.6+debian.3-1 [14.9 kB]
取得 14.9 kB 用了 0s (126 kB/s)
選取了原先未選的套件 automysqlbackup。
（讀取資料庫 ... 目前共安裝了 38659 個檔案和目錄。）
解開 automysqlbackup（從 .../automysqlbackup_2.6+debian.3-1_all.deb）...
執行 man-db 的觸發程式 ...
設定 automysqlbackup (2.6+debian.3-1) ...
ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
root@debian:~#
root@debian:~# service mysql stop
[FAIL] Stopping MySQL database server: mysqld failed!
root@debian:~# ps ax|grep mysql
2298 ? S 0:00 /bin/sh /usr/bin/mysqld_safe
2625 ? Sl 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
2626 ? S 0:00 logger -t mysqld -p daemon.error
3994 pts/0 S+ 0:00 grep mysql
root@debian:~#
root@debian:~#
root@debian:~# automysqlbackup
ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
root@debian:~#
~# cat /etc/mysql/debian.cnf
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = DokY3YMQlSewgKdB
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = DokY3YMQlSewgKdB
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
root@debian:~#
~# 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=/var/run/mysqld/mysqld.sock'
Failed to ALTER DATABASE `#mysql50#gallery2_ali.old` UPGRADE DATA DIRECTORY NAME
Error: Incorrect database name '#mysql50#gallery2_ali.old'
Failed to ALTER DATABASE `#mysql50#mysql.5.0.1` UPGRADE DATA DIRECTORY NAME
Error: Incorrect database name '#mysql50#mysql.5.0.1'
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock'
gallery2_100.g2_AccessMap OK
gallery2_100.g2_AccessSubscriberMap OK
gallery2_100.g2_AlbumItem OK
gallery2_100.g2_AnimationItem OK
gallery2_100.g2_CacheMap OK
gallery2_100.g2_ChildEntity OK
gallery2_100.g2_Comment OK
gallery2_100.g2_CustomFieldMap OK
gallery2_100.g2_DataItem OK
gallery2_100.g2_Derivative OK
gallery2_100.g2_DerivativeImage OK
gallery2_100.g2_DerivativePrefsMap OK
gallery2_100.g2_DescendentCountsMap OK
gallery2_100.g2_Entity OK
gallery2_100.g2_EventLogMap OK
gallery2_100.g2_ExifPropertiesMap OK
gallery2_100.g2_ExternalIdMap OK
gallery2_100.g2_FactoryMap OK
gallery2_100.g2_FailedLoginsMap OK
gallery2_100.g2_FileSystemEntity OK
gallery2_100.g2_G1MigrateMap OK
gallery2_100.g2_Getid3PropsMap OK
gallery2_100.g2_Group OK
gallery2_100.g2_ImageBlockCacheMap OK
gallery2_100.g2_ImageBlockDisabledMap OK
gallery2_100.g2_Item OK
gallery2_100.g2_ItemAttributesMap OK
gallery2_100.g2_ItemHiddenMap OK
gallery2_100.g2_LinkItem OK
gallery2_100.g2_Lock OK
gallery2_100.g2_MaintenanceMap OK
gallery2_100.g2_MimeTypeMap OK
gallery2_100.g2_MovieItem OK
gallery2_100.g2_MultiLangItemMap OK
gallery2_100.g2_PendingUser OK
gallery2_100.g2_PermalinksMap OK
gallery2_100.g2_PermissionSetMap OK
gallery2_100.g2_PhotoItem OK
gallery2_100.g2_PluginMap OK
gallery2_100.g2_PluginPackageMap OK
gallery2_100.g2_PluginParameterMap OK
gallery2_100.g2_QuotasMap OK
gallery2_100.g2_RatingCacheMap OK
gallery2_100.g2_RatingMap OK
gallery2_100.g2_RecoverPasswordMap OK
gallery2_100.g2_RssMap OK
gallery2_100.g2_Schema OK
gallery2_100.g2_SequenceEventLog OK
gallery2_100.g2_SequenceId OK
gallery2_100.g2_SequenceLock OK
gallery2_100.g2_SessionMap OK
gallery2_100.g2_SubscriptionMap OK
gallery2_100.g2_ThumbnailImage OK
gallery2_100.g2_TkOperatnMap OK
gallery2_100.g2_TkOperatnMimeTypeMap OK
gallery2_100.g2_TkOperatnParameterMap OK
gallery2_100.g2_TkPropertyMap OK
gallery2_100.g2_TkPropertyMimeTypeMap OK
gallery2_100.g2_UnknownItem OK
gallery2_100.g2_User OK
gallery2_100.g2_UserGroupMap OK
gallery2_100.g2_WatermarkImage OK
gallery2_100.g2_WebDavLockMap OK
gallery2_ali.g2_AccessMap OK
gallery2_ali.g2_AccessSubscriberMap OK
gallery2_ali.g2_AlbumItem OK
gallery2_ali.g2_AnimationItem OK
gallery2_ali.g2_CacheMap OK
gallery2_ali.g2_ChildEntity OK
gallery2_ali.g2_Comment OK
gallery2_ali.g2_CustomFieldMap OK
gallery2_ali.g2_DataItem OK
gallery2_ali.g2_Derivative OK
gallery2_ali.g2_DerivativeImage OK
gallery2_ali.g2_DerivativePrefsMap OK
mysqlcheck: Got error: 1102: Incorrect database name '#mysql50#gallery2_ali.old' when selecting the database
gallery2_ali.g2_DescendentCountsMap OK
gallery2_ali.g2_Entity OK
gallery2_ali.g2_EventLogMap OK
gallery2_ali.g2_ExifPropertiesMap OK
gallery2_ali.g2_ExternalIdMap OK
gallery2_ali.g2_FactoryMap OK
gallery2_ali.g2_FailedLoginsMap OK
gallery2_ali.g2_FileSystemEntity OK
gallery2_ali.g2_G1MigrateMap OK
gallery2_ali.g2_Getid3PropsMap OK
gallery2_ali.g2_Group OK
gallery2_ali.g2_ImageBlockCacheMap OK
gallery2_ali.g2_ImageBlockDisabledMap OK
gallery2_ali.g2_Item OK
gallery2_ali.g2_ItemAttributesMap OK
gallery2_ali.g2_ItemHiddenMap OK
gallery2_ali.g2_LinkItem OK
gallery2_ali.g2_Lock OK
gallery2_ali.g2_MaintenanceMap OK
gallery2_ali.g2_MimeTypeMap OK
gallery2_ali.g2_MovieItem OK
gallery2_ali.g2_MultiLangItemMap OK
gallery2_ali.g2_PendingUser OK
gallery2_ali.g2_PermalinksMap OK
gallery2_ali.g2_PermissionSetMap OK
gallery2_ali.g2_PhotoItem OK
gallery2_ali.g2_PluginMap OK
gallery2_ali.g2_PluginPackageMap OK
gallery2_ali.g2_PluginParameterMap OK
gallery2_ali.g2_QuotasMap OK
gallery2_ali.g2_RatingCacheMap OK
gallery2_ali.g2_RatingMap OK
gallery2_ali.g2_RecoverPasswordMap OK
gallery2_ali.g2_RssMap OK
gallery2_ali.g2_Schema OK
gallery2_ali.g2_SequenceEventLog OK
gallery2_ali.g2_SequenceId OK
gallery2_ali.g2_SequenceLock OK
gallery2_ali.g2_SessionMap OK
gallery2_ali.g2_SubscriptionMap OK
gallery2_ali.g2_ThumbnailImage OK
gallery2_ali.g2_TkOperatnMap OK
gallery2_ali.g2_TkOperatnMimeTypeMap OK
gallery2_ali.g2_TkOperatnParameterMap OK
gallery2_ali.g2_TkPropertyMap OK
gallery2_ali.g2_TkPropertyMimeTypeMap OK
gallery2_ali.g2_UnknownItem OK
gallery2_ali.g2_User OK
gallery2_ali.g2_UserGroupMap OK
gallery2_ali.g2_WatermarkImage OK
gallery2_ali.g2_WebDavLockMap OK
FATAL ERROR: Upgrade failed
root@debian:~#
root@debian:~# ll /var/lib/mysql
總計 413788
drwx------ 11 mysql mysql 4096 12月 2 10:29 ./
drwxr-xr-x 36 root root 4096 12月 2 10:30 ../
-rw-r--r-- 1 mysql mysql 0 3月 13 2012 debian-5.1.flag
-rw-r--r-- 1 mysql mysql 0 10月 21 14:45 debian-5.5.flag
drwx------ 2 mysql mysql 4096 11月 22 2013 gallery2_100/
drwx------ 2 mysql mysql 4096 1月 21 2014 gallery2_ali/
drwx------ 2 mysql mysql 4096 11月 15 2013 gallery2_ali.old/
drwx------ 2 mysql mysql 4096 9月 13 10:08 gallery3/
-rw-rw---- 1 mysql mysql 413138944 11月 30 20:26 ibdata1
-rw-rw---- 1 mysql mysql 5242880 12月 2 10:29 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 12月 2 10:29 ib_logfile1
drwx------ 2 mysql mysql 4096 10月 21 14:45 mysql/
drwx------ 2 mysql mysql 4096 6月 14 2010 mysql.5.0.1/
-rw-rw---- 1 mysql mysql 6 6月 14 2010 mysql_upgrade_info
drwx------ 2 mysql mysql 4096 10月 21 14:45 performance_schema/
drwx------ 2 mysql mysql 36864 10月 15 13:59 sfs3/
drwx------ 2 mysql mysql 4096 1月 2 2014 test/
-rw-rw---- 1 mysql mysql 5 11月 22 2013 www.pid
root@debian:~#
root@debian:~# rm /var/lib/mysql/gallery2_ali.old/ -rf
root@debian:~# rm /var/lib/mysql/mysql.5.0.1/ -rf
root@debian:~#
root@debian:~# mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
This installation of MySQL is already upgraded to 5.5.40, use --force if you still need to run mysql_upgrade
root@debian:~# mysql_upgrade -u root -p --force
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock'
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock'
gallery2_100.g2_AccessMap OK
gallery2_100.g2_AccessSubscriberMap OK
gallery2_100.g2_AlbumItem OK
gallery2_100.g2_AnimationItem OK
gallery2_100.g2_CacheMap OK
gallery2_100.g2_ChildEntity OK
gallery2_100.g2_Comment OK
gallery2_100.g2_CustomFieldMap OK
gallery2_100.g2_DataItem OK
gallery2_100.g2_Derivative OK
gallery2_100.g2_DerivativeImage OK
gallery2_100.g2_DerivativePrefsMap OK
gallery2_100.g2_DescendentCountsMap OK
gallery2_100.g2_Entity OK
gallery2_100.g2_EventLogMap OK
gallery2_100.g2_ExifPropertiesMap OK
gallery2_100.g2_ExternalIdMap OK
gallery2_100.g2_FactoryMap OK
gallery2_100.g2_FailedLoginsMap OK
gallery2_100.g2_FileSystemEntity OK
gallery2_100.g2_G1MigrateMap OK
gallery2_100.g2_Getid3PropsMap OK
gallery2_100.g2_Group OK
gallery2_100.g2_ImageBlockCacheMap OK
gallery2_100.g2_ImageBlockDisabledMap OK
gallery2_100.g2_Item OK
gallery2_100.g2_ItemAttributesMap OK
gallery2_100.g2_ItemHiddenMap OK
gallery2_100.g2_LinkItem OK
gallery2_100.g2_Lock OK
gallery2_100.g2_MaintenanceMap OK
gallery2_100.g2_MimeTypeMap OK
gallery2_100.g2_MovieItem OK
gallery2_100.g2_MultiLangItemMap OK
gallery2_100.g2_PendingUser OK
gallery2_100.g2_PermalinksMap OK
gallery2_100.g2_PermissionSetMap OK
gallery2_100.g2_PhotoItem OK
gallery2_100.g2_PluginMap OK
gallery2_100.g2_PluginPackageMap OK
gallery2_100.g2_PluginParameterMap OK
gallery2_100.g2_QuotasMap OK
gallery2_100.g2_RatingCacheMap OK
gallery2_100.g2_RatingMap OK
gallery2_100.g2_RecoverPasswordMap OK
gallery2_100.g2_RssMap OK
gallery2_100.g2_Schema OK
gallery2_100.g2_SequenceEventLog OK
gallery2_100.g2_SequenceId OK
gallery2_100.g2_SequenceLock OK
gallery2_100.g2_SessionMap OK
gallery2_100.g2_SubscriptionMap OK
gallery2_100.g2_ThumbnailImage OK
gallery2_100.g2_TkOperatnMap OK
gallery2_100.g2_TkOperatnMimeTypeMap OK
gallery2_100.g2_TkOperatnParameterMap OK
gallery2_100.g2_TkPropertyMap OK
gallery2_100.g2_TkPropertyMimeTypeMap OK
gallery2_100.g2_UnknownItem OK
gallery2_100.g2_User OK
gallery2_100.g2_UserGroupMap OK
gallery2_100.g2_WatermarkImage OK
gallery2_100.g2_WebDavLockMap OK
gallery2_ali.g2_AccessMap OK
gallery2_ali.g2_AccessSubscriberMap OK
gallery2_ali.g2_AlbumItem OK
gallery2_ali.g2_AnimationItem OK
gallery2_ali.g2_CacheMap OK
gallery2_ali.g2_ChildEntity OK
gallery2_ali.g2_Comment OK
gallery2_ali.g2_CustomFieldMap OK
gallery2_ali.g2_DataItem OK
gallery2_ali.g2_Derivative OK
gallery2_ali.g2_DerivativeImage OK
gallery2_ali.g2_DerivativePrefsMap OK
gallery2_ali.g2_DescendentCountsMap OK
gallery2_ali.g2_Entity OK
gallery2_ali.g2_EventLogMap OK
gallery2_ali.g2_ExifPropertiesMap OK
gallery2_ali.g2_ExternalIdMap OK
gallery2_ali.g2_FactoryMap OK
gallery2_ali.g2_FailedLoginsMap OK
gallery2_ali.g2_FileSystemEntity OK
gallery2_ali.g2_G1MigrateMap OK
gallery2_ali.g2_Getid3PropsMap OK
gallery2_ali.g2_Group OK
gallery2_ali.g2_ImageBlockCacheMap OK
gallery2_ali.g2_ImageBlockDisabledMap OK
gallery2_ali.g2_Item OK
gallery2_ali.g2_ItemAttributesMap OK
gallery2_ali.g2_ItemHiddenMap OK
gallery2_ali.g2_LinkItem OK
gallery2_ali.g2_Lock OK
gallery2_ali.g2_MaintenanceMap OK
gallery2_ali.g2_MimeTypeMap OK
gallery2_ali.g2_MovieItem OK
gallery2_ali.g2_MultiLangItemMap OK
gallery2_ali.g2_PendingUser OK
gallery2_ali.g2_PermalinksMap OK
gallery2_ali.g2_PermissionSetMap OK
gallery2_ali.g2_PhotoItem OK
gallery2_ali.g2_PluginMap OK
gallery2_ali.g2_PluginPackageMap OK
gallery2_ali.g2_PluginParameterMap OK
gallery2_ali.g2_QuotasMap OK
gallery2_ali.g2_RatingCacheMap OK
gallery2_ali.g2_RatingMap OK
gallery2_ali.g2_RecoverPasswordMap OK
gallery2_ali.g2_RssMap OK
gallery2_ali.g2_Schema OK
gallery2_ali.g2_SequenceEventLog OK
gallery2_ali.g2_SequenceId OK
gallery2_ali.g2_SequenceLock OK
gallery2_ali.g2_SessionMap OK
gallery2_ali.g2_SubscriptionMap OK
gallery2_ali.g2_ThumbnailImage OK
gallery2_ali.g2_TkOperatnMap OK
gallery2_ali.g2_TkOperatnMimeTypeMap OK
gallery2_ali.g2_TkOperatnParameterMap OK
gallery2_ali.g2_TkPropertyMap OK
gallery2_ali.g2_TkPropertyMimeTypeMap OK
gallery2_ali.g2_UnknownItem OK
gallery2_ali.g2_User OK
gallery2_ali.g2_UserGroupMap OK
gallery2_ali.g2_WatermarkImage OK
gallery2_ali.g2_WebDavLockMap OK
gallery3.school_photo_access_caches OK
gallery3.school_photo_access_intents OK
gallery3.school_photo_caches OK
gallery3.school_photo_comments OK
gallery3.school_photo_failed_auths OK
gallery3.school_photo_g2_maps OK
gallery3.school_photo_graphics_rules OK
gallery3.school_photo_groups OK
gallery3.school_photo_groups_users OK
gallery3.school_photo_incoming_translations OK
gallery3.school_photo_items OK
gallery3.school_photo_items_tags OK
gallery3.school_photo_logs OK
gallery3.school_photo_messages OK
gallery3.school_photo_modules OK
gallery3.school_photo_outgoing_translations OK
gallery3.school_photo_permissions OK
gallery3.school_photo_search_records OK
gallery3.school_photo_sessions OK
gallery3.school_photo_tags OK
gallery3.school_photo_tasks OK
gallery3.school_photo_themes OK
gallery3.school_photo_users OK
gallery3.school_photo_vars OK
gallery3.school_photo_watermarks OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
sfs3.BMI OK
sfs3.GHD OK
sfs3.artical
Error : Table 'sfs3.artical' doesn't exist
status : Operation failed
sfs3.artical_detail
Error : Table 'sfs3.artical_detail' doesn't exist
status : Operation failed
sfs3.artical_paramter OK
sfs3.association OK
sfs3.bad_login OK
sfs3.board_check OK
sfs3.board_files OK
sfs3.board_kind OK
sfs3.board_p OK
sfs3.book OK
sfs3.book_say OK
sfs3.bookch1 OK
sfs3.borrow OK
sfs3.cal_elps OK
sfs3.cal_elps_set OK
sfs3.calendar OK
sfs3.charge_decrease OK
sfs3.charge_detail OK
sfs3.charge_item OK
sfs3.charge_record OK
sfs3.cita_data OK
sfs3.cita_kind OK
sfs3.class_comment_admin OK
sfs3.comment OK
sfs3.comment_kind OK
sfs3.comment_level OK
sfs3.copy_log OK
sfs3.course_class_time OK
sfs3.course_room OK
sfs3.course_ss_num OK
sfs3.course_table &nbs
