[教學]MySql 資料快速備份[定時]

文章由 **進藤光** » 2006-10-16 20:41

感謝你的寶貴建議！
加上 --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 版自動備份出來的全是亂碼，等於白做了～

文章由 **chiouss** » 2006-10-16 21:46

進藤光寫:自動備份的檔案大小都是 7.5MB，但是用 MySQL Administrator 手動備份卻有 8.4MB，將近 1MB 的差距對 7.5MB 來說是滿大的！

我不知道這兩有有啥差別？總之自動備份功能是到了 MySQL Administrator 1.2 版才能使用，1.0 與 1.1 根本就一點用也沒有～
不幸的是 1.2 版自動備份出來的全是亂碼，等於白做了～

你沒用 diff 去看過差哪裡？因為 MySQL Administrator 其實也是用 mysqldump 去做的，說明檔有寫 :Q

文章由 **進藤光** » 2006-10-17 00:25

說明檔？那是啥？？能吃嗎？？

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>

文章由 **chiouss** » 2006-10-17 00:49

進藤光寫:說明檔？那是啥？？能吃嗎？？

好像有 HTML 版...