Toggle navigation
gienginali
:::
主選單
資訊安全
網路測速
線上書籍
登入
登入
帳號
密碼
登入
:::
新聞載入中,請稍後...
所有書籍
「Linux SFS3」目錄
MarkDown
3-5 資料庫格式升級轉換 5.0.x ---> 現在版本
1. 設定
1-1 小貓登入
1-1-1 小貓圖片登入 實作
2. Mysql
2-1 備份方式改變
2-1-1 InnoDB2.txt
2-1-2 InnoDB.txt
3-2
3-3 全面迎接 automysqlbackup 的備份方式
3-4 這樣資料庫用拷貝的..就一樣能用
3-5 資料庫格式升級轉換 5.0.x ---> 現在版本
3-6 txt
4. 其餘
4-1 重開機後還原學生設定
5. 更新
5-1 手動更新
5-2 手動更新-2
6. Linux
6-1 JDK
4-1 重開機後還原學生設定
Linux SFS3 ========== ~# 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
:::
展開
|
闔起
文章類別
書籍目錄
展開
|
闔起
線上使用者
19
人線上 (
18
人在瀏覽
線上書籍
)
會員: 0
訪客: 19
更多…