All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Backing up binary log files with mysqlbinlog
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
mysqldump ã®çµæžœã‚’ãã®ã¾ã¾åœ§ç¸®ã—ãŸã‚Šè»¢é€ã—ãŸã‚Šã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ä¾‹ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
ã¡ã‚‡ã£ã¨é…ã‚ã®å¤ä¼‘ã¿ã‚’もらã£ã¦å…«ä¸ˆå³¶ã«è¡Œã£ã¦ãã¾ã—㟠nakamura ã§ã™ï¼ã„ã„所ã™ãŽã¦å±ã†ããã®ã¾ã¾ç§»ä½ã™ã‚‹ã¨ã“ã‚ã§ã—ãŸã€‚ データベースã®ç§»è¡Œã‚’ã™ã‚‹éš›ã¿ãªã•ã‚“ã©ã‚“ãªæµã‚Œã§ä½œæ¥ã—ã¦ã„ã‚‹ã§ã—ょã†ã‹ã€‚コマンドラインã§ãƒ€ãƒ³ãƒ—ã‚’å–ã£ã¦ã€ã‚µã‚¤ã‚ºãŒå¤§ãã‹ã£ãŸã‚‰ gzip ã§åœ§ç¸®ã—ã¦ã€WinSCP ã§ãれをãƒãƒ¼ã‚«ãƒ«ã«è½ã¨ã—ã¦ãã¦ã€ãれをã¾ãŸåˆ¥ã®ã‚µãƒ¼ãƒã«ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦ãƒ»ãƒ»ãƒ»ãƒ»ãªã‚“ã¦äº‹ã—ã¦ãŸã‚Šã—ã¾ã›ã‚“ã‹ï¼Ÿ シェルã®ãƒ‘イプやリダイレクトをã†ã¾ã使ã£ã¦ã‚ã’ã‚Œã°ã€ã“ã®è¾ºã‚Šã¯ã‚³ãƒžãƒ³ãƒ‰ä¸€ç™ºã§ã„ã‘ã¡ã‚ƒã£ãŸã‚Šã™ã‚‹ã®ã§ã™ã€‚今日ã¯ãã‚“ãªã‚³ãƒžãƒ³ãƒ‰ä¾‹ã®ã”紹介ã§ã™ã€‚ 実際ã«ã‚ˆã使ã†ã‚³ãƒžãƒ³ãƒ‰ã®ä¾‹ã‚’箇æ¡æ›¸ãã§ã€‚ ã¨ã‚Šã‚ãˆãšãƒ€ãƒ³ãƒ—ã®çµæžœã‚’ãã®ã¾ã¾åœ§ç¸®ã™ã‚‹ã€‚ mysqldump -udb_user db_name -pdb_pass | gzip > db_name.dump.sql.gz 特定ã®æ–‡å—列を置æ›ã—ãŸä¸Šã§åœ§ç¸®ã™ã‚‹ã€‚ MT
MySQL Backup: Table By Table Backup With Auto Rotation, For Easy Restoration Of Partial/Full Database
MySQL Backup: Table By Table Backup With Auto Rotation, For Easy Restoration Of Partial/Full DatabaseHere is a MySQL backup script which can take table by table backups (individual backup files of each table of each database) in a compressed format. It also provides an automatic rotation of old backup files.  The backup script handles innodb and myisam tables separately. You have to set the follow
MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é ‚ä¸Šæ±ºæˆ¦ï¼ï¼ LVMスナップショット vs InnoDB Hot Backup
スナップショットを使ãˆã°ã¨ã‚る瞬間ã®ãƒ‡ã‚£ã‚¹ã‚¯ã‚„ファイルシステムã®ãƒ‡ãƒ¼ã‚¿ã‚’ã„ã¤ã§ã‚‚後ã‹ã‚‰å‚ç…§ã™ã‚‹ã“ã¨ãŒã§ãる。ã—ã‹ã‚‚スナップショットã®ä½œæˆã¯ä¸€çž¬ã 。スナップショット機能を活用ã™ã‚Œã°æœ€å¼·ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ソリューションãŒå‡ºæ¥ã‚‹ã ã‚ã†ã€‚ ã—ã‹ã—ã€ã‚¹ãƒŠãƒƒãƒ—ショットã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹ãªã‚“ã¦å±é™ºãªæ“作ã˜ã‚ƒãªã„ã®ã‹ï¼Ÿï¼ã¨ä¸å®‰ã«æ€ã‚れる方もã„らã£ã—ゃるã‹ã‚‚知れãªã„。MySQL ServerãŒç¨¼åƒä¸ã«ã„ããªã‚Šãƒ‡ãƒ¼ã‚¿ã ã‘ã‚’ã¨ã£ã¦ãã‚‹ã®ã ã‹ã‚‰ã€ãã®ã‚ˆã†ãªç–‘å•ã‚’æŒãŸã‚Œã‚‹ã®ã¯é ·ã‘る。ã—ã‹ã—仕組ã¿ã•ãˆåˆ†ã‹ã‚Œã°ã‚¹ãƒŠãƒƒãƒ—ショットã«ã‚ˆã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯æ€–ããªã„ã¨ã„ã†ã“ã¨ãŒåˆ†ã‹ã‚‹ã¯ãšã 。ãã“ã§ã€ã¾ãšã¯ã‚¹ãƒŠãƒƒãƒ—ショットã«ã‚ˆã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ä»•çµ„ã¿ã«ã¤ã„ã¦èª¬æ˜Žã™ã‚‹ã€‚スナップショットをå–ã‚‹éš›ã®è¦ä»¶ã¯æ¬¡ã®é€šã‚Šã§ã‚る。 å…¨ã¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’å˜ä¸€ã®ãƒœãƒªãƒ¥ãƒ¼ãƒ ã«ç½®ãã“ã¨ã€‚ã¤ã¾ã‚Šã€ä¸€å›žã®ã‚¹ãƒŠãƒƒãƒ—ショットæ“作ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒå–れるã“ã¨ã 。 ディ
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Percona Xtrabackup 1.6.2 released!
{{#tags}}- {{label}}
{{/tags}}