感謝你的寶貴建議!
加上 --lock-all-tables,完全沒用!
再加上 --add-drop-table,同樣完全沒用!不知道 -- 參數有沒有使用順序?
自動備份的檔案大小都是 7.5MB,但是用 MySQL Administrator 手動備份卻有 8.4MB,將近 1MB 的差距對 7.5MB 來說是滿大的!
我不知道這兩有有啥差別?總之自動備份功能是到了 MySQL Administrator 1.2 版才能使用,1.0 與 1.1 根本就一點用也沒有~
不幸的是 1.2 版自動備份出來的全是亂碼,等於白做了~
[教學]MySql 資料快速備份[定時]
版主: 版主管理群
版面規則
本區是討論關於 phpBB 2.0.X 架設安裝上的問題,只要有安裝任何外掛,請到外掛討論相關版面按照公告格式發表。
(發表文章請按照公告格式發表,違者砍文)
本區是討論關於 phpBB 2.0.X 架設安裝上的問題,只要有安裝任何外掛,請到外掛討論相關版面按照公告格式發表。
(發表文章請按照公告格式發表,違者砍文)
※架設伺服器主機:Mac mini G4-1.5GHz, 1GB RAM 三台
※架設主機作業系統:Mac OS X Server 10.4.2 Tiger
※我的上網方式:固定制 ADSL 4M/1M、3 IP
※安裝的伺服器:Apache 1.3.33 + php 4.3.11 + MySQL 5.0.19-max
※我的 phpBB2 版本:phpBB 2.0.21 UTF-8 版
※我的會議室網址: http://bbs.bnw.com.tw/conference/
※架設主機作業系統:Mac OS X Server 10.4.2 Tiger
※我的上網方式:固定制 ADSL 4M/1M、3 IP
※安裝的伺服器:Apache 1.3.33 + php 4.3.11 + MySQL 5.0.19-max
※我的 phpBB2 版本:phpBB 2.0.21 UTF-8 版
※我的會議室網址: http://bbs.bnw.com.tw/conference/
說明檔?那是啥??能吃嗎??
MySQL Bug 要我把 phpBB.mbp 檔案內容貼出來,不過我看貼這個大概沒什麼用~搜尋整個竹貓根本找不到 .mbp 這玩意~ Orz
MySQL Bug 要我把 phpBB.mbp 檔案內容貼出來,不過我看貼這個大概沒什麼用~搜尋整個竹貓根本找不到 .mbp 這玩意~ Orz
代碼: 選擇全部
<?xml version="1.0"?>
<backup_profile>
<version>1.2</version>
<profile_name>phpBB</profile_name>
<last_used/>
<options>2304</options>
<backup_type>0</backup_type>
<entities>
<entity>
<name>phpbb_auth_access</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_banlist</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_categories</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_config</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_confirm</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_disallow</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_forum_prune</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_forums</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_groups</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_posts</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_posts_text</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_privmsgs</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_privmsgs_text</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_ranks</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_search_results</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_search_wordlist</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_search_wordmatch</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_sessions</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_sessions_keys</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_smilies</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_themes</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_themes_name</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_topics</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_topics_watch</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_user_group</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_users</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_vote_desc</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_vote_results</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_vote_voters</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
<entity>
<name>phpbb_words</name>
<schema>phpbb</schema>
<catalog>def</catalog>
<entity_type>table</entity_type>
</entity>
</entities>
</backup_profile>
※架設伺服器主機:Mac mini G4-1.5GHz, 1GB RAM 三台
※架設主機作業系統:Mac OS X Server 10.4.2 Tiger
※我的上網方式:固定制 ADSL 4M/1M、3 IP
※安裝的伺服器:Apache 1.3.33 + php 4.3.11 + MySQL 5.0.19-max
※我的 phpBB2 版本:phpBB 2.0.21 UTF-8 版
※我的會議室網址: http://bbs.bnw.com.tw/conference/
※架設主機作業系統:Mac OS X Server 10.4.2 Tiger
※我的上網方式:固定制 ADSL 4M/1M、3 IP
※安裝的伺服器:Apache 1.3.33 + php 4.3.11 + MySQL 5.0.19-max
※我的 phpBB2 版本:phpBB 2.0.21 UTF-8 版
※我的會議室網址: http://bbs.bnw.com.tw/conference/