{ "info": { "author": "Bill Guo", "author_email": "billguo.feather@outlook.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "License :: OSI Approved :: GNU General Public License v3 (GPLv3)", "Operating System :: OS Independent", "Programming Language :: Python :: 3" ], "description": "# Aliyun RDS Backup Tool\n\n\u8fd9\u662f\u4e00\u4e2a\u6309\u7167\u81ea\u5b9a\u4e49\u914d\u7f6e\uff0c\u4ece\u963f\u91cc\u4e91RDS(***\u76ee\u524d\u53ea\u652f\u6301MySQL***)\u4e0b\u8f7d\u6570\u636e\u5e93\u5907\u4efd(\u5305\u62ec\u5168\u5907\u548cbinlog\u5907\u4efd)\u5230\u672c\u5730\u7684\u5de5\u5177\uff0c\u5e76\u652f\u6301\u5b9a\u65f6\u6e05\u7406\u8fc7\u671f\u5907\u4efd\u6587\u4ef6\u3002\n\n## \u5b89\u88c5\n\n```python\npip install aliyun-rds-bkp\n```\n\n## \u914d\u7f6e\n\n\u914d\u7f6e\u6587\u4ef6\u4e3ajson\u683c\u5f0f\u3002\n\n```json\n{\n \"AccessKeyId\": \"AccessKeyID Provided by Aliyun RDS\",\n \"AccessKeySecret\": \"AccessKeySecret Provided by Aliyun RDS\",\n \"Regions\": [\n {\n \"RegionID\": \"cn-hangzhou\",\n \"DBInstances\": [\n {\n \"DBInstanceId\": \"rm-XXXXXXXXXXXXXXXXXX\",\n \"LastFullBackup\": {\n \"BackupEndTime\": \"2019-03-16 05:30:00\"\n },\n \"LastBinlogBackup\": {\n \"BackupEndTime\": \"2019-03-16 05:30:00\"\n },\n \"BackupRetentionDays\": 21,\n \"Schedule\": {\n \"FullBackup\": {\n \"Plan\": \"* * * * 2,4,6\"\n },\n \"BinlogBackup\": {\n \"Plan\": \"* * * * *\"\n }\n }\n }\n ]\n }\n ],\n \"BackupHome\": \"Path/to/Backup/Directory\",\n \"ErrorLog\": \"Path/to/Error/Log\",\n \"MailConfig\": {\n \"SMTPServer\": \"Your SMTP Server\",\n \"SMTPLogin\": \"Account to Login SMTP Server\",\n \"SMTPPassword\": \"Password to login SMTP Server\",\n \"SMTPPort\": 25,\n \"TTLS\": false,\n \"From\": \"email_from\",\n \"To\": [\n \"email_1\",\n \"email_2\"\n ],\n \"Cc\": [\n \"email_cc\"\n ],\n \"Subject\": \"E-Mail Subject\"\n }\n}\n```\n\n#### \u53c2\u6570\u8bf4\u660e\n\n- AccessKeyId: \u963f\u91cc\u4e91\u63d0\u4f9b\u7684AccessKeyId\n- AccessKeySecret: \u963f\u91cc\u4e91\u63d0\u4f9b\u7684AccessKeySecret\n- RegionID: \u53c2\u8003https://help.aliyun.com/document_detail/40654.html\n- DBInstanceId: RDS\u5b9e\u4f8bID\n- BackupEndTime: \u4e0a\u6b21\u5907\u4efd\u7684\u7ed3\u675f\u7684UTC\u65f6\u95f4\uff0c\u7528\u4e8e\u589e\u91cf\uff0c\u683c\u5f0f\u4e3aYYYY-MM-DD HH:MI:SS\n- BackupRetentionDays: \u5907\u4efd\u4fdd\u7559\u5929\u6570\n- Plan: \u5907\u4efd\u8ba1\u5212(***\u672c\u5730\u65f6\u95f4***)\u30025\u4e2a\u53c2\u6570\u4ee5\u7a7a\u683c\u5206\u9694\uff0c\u5206\u522b\u4ee3\u8868\u89e6\u53d1\u5907\u4efd\u7684\n - \u5206\u949f\n - \u5c0f\u65f6\n - \u4e00\u4e2a\u6708\u4e2d\u7684\u7b2c\u51e0\u5929\n - \u6708\u4efd\n - \u4e00\u4e2a\u661f\u671f\u4e2d\u7684\u7b2c\u51e0\u5929\u30021\u8868\u793a\u661f\u671f\u4e00\uff0c7\u8868\u793a\u661f\u671f\u65e5\u3002\n- BackupHome: \u653e\u7f6e\u5907\u4efd\u6587\u4ef6\u7684\u603b\u76ee\u5f55\u3002\u5728\u603b\u76ee\u5f55\u4e0b\u4f1a\u81ea\u52a8\u6309\u7167RegionID->InstanceID->Year->Month->Day\u521b\u5efa\u76ee\u5f55\n- ErrorLog: \u6307\u5b9a\u9519\u8bef\u65e5\u5fd7\u5b58\u653e\u6587\u4ef6\n- SMTPServer: \u90ae\u4ef6\u670d\u52a1\u5668\u5730\u5740\uff0c\u7528\u4e8e\u53d1\u9001\u5907\u4efd\u6210\u529f\u6216\u5931\u8d25\u7684\u901a\u77e5\u90ae\u4ef6\n- SMTPLogin: \u90ae\u4ef6\u670d\u52a1\u5668\u767b\u5f55\u8d26\u53f7\n- SMTPPassword: \u90ae\u4ef6\u670d\u52a1\u5668\u767b\u5f55\u5bc6\u7801\n- SMTPPort: \u90ae\u4ef6\u670d\u52a1\u5668\u7aef\u53e3\n- TTLS: \u90ae\u4ef6\u670d\u52a1\u5668\u662f\u5426\u4f7f\u7528TTLS\uff0ctrue\u6216false\n- From: \u90ae\u4ef6\u53d1\u9001\u8d26\u6237\n- To: \u90ae\u4ef6\u63a5\u6536\u8d26\u6237\u5217\u8868\n- Cc: \u90ae\u4ef6\u6284\u9001\u8d26\u6237\u5217\u8868\n- Subject: \u901a\u77e5\u90ae\u4ef6\u7684\u4e3b\u9898\n\n## \u4f7f\u7528\n\n1. \u7f16\u5199\u8c03\u7528\u811a\u672c\n\n```python\nimport os\n\nfrom aliyunrdsbkp.mysql_backup import MySQLBackup\n\nif __name__ == '__main__':\n dir_path = os.path.dirname(os.path.realpath(__file__))\n config_file = os.path.join(\n dir_path,\n 'config/settings.json'\n ) # \u914d\u7f6e\u6587\u4ef6\u8def\u5f84\n mysql_backup = MySQLBackup(config_file)\n mysql_backup.backup()\n\n```\n\n2. \u5728Linux\u4e0b\u7684crontab\u6216Windows\u4e0b\u7684Task Scheduler\u914d\u7f6e\u5b9a\u65f6\u6267\u884c\u4ee5\u4e0a\u8c03\u7528\u811a\u672c\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/life-game-player/aliyun-rds-bkp", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "aliyun-rds-bkp", "package_url": "https://pypi.org/project/aliyun-rds-bkp/", "platform": "", "project_url": "https://pypi.org/project/aliyun-rds-bkp/", "project_urls": { "Homepage": "https://github.com/life-game-player/aliyun-rds-bkp" }, "release_url": "https://pypi.org/project/aliyun-rds-bkp/0.1.6/", "requires_dist": [ "aliyun-python-sdk-rds (>=2.3.2)" ], "requires_python": "", "summary": "A small tool to download db files from Aliyun RDS per schedule", "version": "0.1.6" }, "last_serial": 5001518, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "8e9caaa1433d41eac371b0af51ee0249", "sha256": "79e699acea7f2f79e88956d933d16204dfa6e890e2e4ee1209f81a92c33f9b87" }, "downloads": -1, "filename": "aliyun_rds_bkp-0.1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "8e9caaa1433d41eac371b0af51ee0249", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 20890, "upload_time": "2019-03-22T03:02:35", "url": "https://files.pythonhosted.org/packages/c7/23/da5a870e15935734b75fe63282b7dd57e1eac14ebd997f13dc469642c82e/aliyun_rds_bkp-0.1.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "8be598f47557227e0ce9359057c96b02", "sha256": "4f975db5f4b941732f33b93de8008957d134b4598416b82a925d169a77e29ef9" }, "downloads": -1, "filename": "aliyun-rds-bkp-0.1.0.tar.gz", "has_sig": false, "md5_digest": "8be598f47557227e0ce9359057c96b02", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6149, "upload_time": "2019-03-22T03:02:37", "url": "https://files.pythonhosted.org/packages/7d/d6/d508abae1736e7d5e6ae7f2a65693adac3dbc7e9efbfbc59f913d27c40e0/aliyun-rds-bkp-0.1.0.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "e8cf93149fb4d9d3b0a3a2e2b592e4f7", "sha256": "acdf1be74bca2d2ac9795449e182caa0822e925340bbd0b7df3aeed9d6c4c0cc" }, "downloads": -1, "filename": "aliyun_rds_bkp-0.1.1-py3-none-any.whl", "has_sig": false, "md5_digest": "e8cf93149fb4d9d3b0a3a2e2b592e4f7", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 20892, "upload_time": "2019-03-22T03:16:39", "url": "https://files.pythonhosted.org/packages/ef/63/47e8b6a419167f7b42370db3139048ab3197e1fe1232c9febe63dd4cf788/aliyun_rds_bkp-0.1.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "ebc359f12bf7546ae31944c63186f3ce", "sha256": "d80ca43ef8844447c761c7e1fa2440debb10d2700445232b13acc8be891ebc1b" }, "downloads": -1, "filename": "aliyun-rds-bkp-0.1.1.tar.gz", "has_sig": false, "md5_digest": "ebc359f12bf7546ae31944c63186f3ce", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6145, "upload_time": "2019-03-22T03:16:41", "url": "https://files.pythonhosted.org/packages/8f/20/eec89829202f439cdd584d737f0aa62a91fdb38ea818b0c574a1f16fb0e7/aliyun-rds-bkp-0.1.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "cfce9ee01e858f36e5f1a447b65403d3", "sha256": "714fea91ca5305c969375ef13d12dc4fa6c8e971fe6ba2b69e9f4fd460eaa6ec" }, "downloads": -1, "filename": "aliyun_rds_bkp-0.1.2-py3-none-any.whl", "has_sig": false, "md5_digest": "cfce9ee01e858f36e5f1a447b65403d3", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 20892, "upload_time": "2019-03-22T03:18:04", "url": "https://files.pythonhosted.org/packages/8b/0c/eebb58431ebfb1609b9500254aa48ecc264f0214fe4c1e1265f9bb3427ec/aliyun_rds_bkp-0.1.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "acb31da643ef9cb88da86557b617f012", "sha256": "aa019db8211d99e06dbea531a6b3d4f68502b51b7aba78626c8de0ab9b13f384" }, "downloads": -1, "filename": "aliyun-rds-bkp-0.1.2.tar.gz", "has_sig": false, "md5_digest": "acb31da643ef9cb88da86557b617f012", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6142, "upload_time": "2019-03-22T03:18:05", "url": "https://files.pythonhosted.org/packages/57/16/a03c418cb0141c3ea92df79e7c60056a06796bf7d5b8c27d5718492b63a4/aliyun-rds-bkp-0.1.2.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "ab8488124d4459fde841b66d4d19d7ed", "sha256": "f60e049631039db74a1dd58becbd9e11d0f10f9315c3f8e3032509e84d60ef13" }, "downloads": -1, "filename": "aliyun_rds_bkp-0.1.3-py3-none-any.whl", "has_sig": false, "md5_digest": "ab8488124d4459fde841b66d4d19d7ed", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 20931, "upload_time": "2019-03-22T06:56:25", "url": "https://files.pythonhosted.org/packages/40/bc/fe2fb878e3cbc80b5dfd747526546d6956d95b7d3a918af57142570a3f07/aliyun_rds_bkp-0.1.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d721f01fa7450e56456099fa6ee3be5a", "sha256": "79182eb1331d9d56dfc36d29b4de02252b9e8496eba27f5e50da171bc3774953" }, "downloads": -1, "filename": "aliyun-rds-bkp-0.1.3.tar.gz", "has_sig": false, "md5_digest": "d721f01fa7450e56456099fa6ee3be5a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6185, "upload_time": "2019-03-22T06:56:27", "url": "https://files.pythonhosted.org/packages/f9/bc/064147e681baf2f9835dfa63e6d2503528dd18636f4f9ff1afa864a8878c/aliyun-rds-bkp-0.1.3.tar.gz" } ], "0.1.4": [ { "comment_text": "", "digests": { "md5": "9050ec43169b41a2ee07e20c2dfc3c48", "sha256": "6bc8d8b546fda9771104595e1a1f7842ddc58cfe937c8122dfce8de4740c5fbd" }, "downloads": -1, "filename": "aliyun_rds_bkp-0.1.4-py3-none-any.whl", "has_sig": false, "md5_digest": "9050ec43169b41a2ee07e20c2dfc3c48", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 22459, "upload_time": "2019-03-27T07:54:41", "url": "https://files.pythonhosted.org/packages/3e/bd/a66f5f8b6ed2d6b7369f5193f275db9caa400681e58135bca013820a046b/aliyun_rds_bkp-0.1.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "42dabd5137cda8e04495825f2ef263b5", "sha256": "e922a35684d7f12ea1794d394ac68f862903b7ed687967e35620a7a7980087cf" }, "downloads": -1, "filename": "aliyun-rds-bkp-0.1.4.tar.gz", "has_sig": false, "md5_digest": "42dabd5137cda8e04495825f2ef263b5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8012, "upload_time": "2019-03-27T07:54:43", "url": "https://files.pythonhosted.org/packages/51/7f/61cef0751e2995667aff42d20024ba6446cd363477901a036837042a55d5/aliyun-rds-bkp-0.1.4.tar.gz" } ], "0.1.5": [ { "comment_text": "", "digests": { "md5": "d7fa795d77c7e317661a048c430dbcbf", "sha256": "926d286dba3de7a2d90b0c36a57eaa2a9b396baafcd7d63f4184e9c27d044566" }, "downloads": -1, "filename": "aliyun_rds_bkp-0.1.5-py3-none-any.whl", "has_sig": false, "md5_digest": "d7fa795d77c7e317661a048c430dbcbf", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 22548, "upload_time": "2019-03-29T02:54:15", "url": "https://files.pythonhosted.org/packages/7c/e7/a3739187ba69474e370b0f6796d2958b09da5efa645ae3693f8c2a18037c/aliyun_rds_bkp-0.1.5-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "8d9231a72a10605aefcd97f893f944ab", "sha256": "6934885bfb1e6fdfbaa1438da5966128b38206e6e985b2b63b5a6b6961edaa88" }, "downloads": -1, "filename": "aliyun-rds-bkp-0.1.5.tar.gz", "has_sig": false, "md5_digest": "8d9231a72a10605aefcd97f893f944ab", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8106, "upload_time": "2019-03-29T02:54:16", "url": "https://files.pythonhosted.org/packages/12/46/7a3d62f02d25a1357d5c44b9a38db91861e305d1f07839a908dd0145dead/aliyun-rds-bkp-0.1.5.tar.gz" } ], "0.1.6": [ { "comment_text": "", "digests": { "md5": "7d64cdff981958dd45b4828df296800f", "sha256": "f11ac26e84d863a68c2a8782b53609eb1b5f0da4b9c48f7ee9e7c5669e926d71" }, "downloads": -1, "filename": "aliyun_rds_bkp-0.1.6-py3-none-any.whl", "has_sig": false, "md5_digest": "7d64cdff981958dd45b4828df296800f", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 22589, "upload_time": "2019-03-29T03:47:42", "url": "https://files.pythonhosted.org/packages/07/d1/530baf3c56fa6445fcc140830283225e16cdf94312cc61ca3b5ecdcf61b5/aliyun_rds_bkp-0.1.6-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "671ff4a1285dabbb7e37b11da01d2ef5", "sha256": "7e01974e8c432617aa95f4d989630285f12110aac0c1514ccc06bbf0b8f8ac32" }, "downloads": -1, "filename": "aliyun-rds-bkp-0.1.6.tar.gz", "has_sig": false, "md5_digest": "671ff4a1285dabbb7e37b11da01d2ef5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8158, "upload_time": "2019-03-29T03:47:44", "url": "https://files.pythonhosted.org/packages/e5/7c/bf20585ee1c78af4fb7a14a2b56c38bfdc7b364d21d08721b685bbe0bd46/aliyun-rds-bkp-0.1.6.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "7d64cdff981958dd45b4828df296800f", "sha256": "f11ac26e84d863a68c2a8782b53609eb1b5f0da4b9c48f7ee9e7c5669e926d71" }, "downloads": -1, "filename": "aliyun_rds_bkp-0.1.6-py3-none-any.whl", "has_sig": false, "md5_digest": "7d64cdff981958dd45b4828df296800f", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 22589, "upload_time": "2019-03-29T03:47:42", "url": "https://files.pythonhosted.org/packages/07/d1/530baf3c56fa6445fcc140830283225e16cdf94312cc61ca3b5ecdcf61b5/aliyun_rds_bkp-0.1.6-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "671ff4a1285dabbb7e37b11da01d2ef5", "sha256": "7e01974e8c432617aa95f4d989630285f12110aac0c1514ccc06bbf0b8f8ac32" }, "downloads": -1, "filename": "aliyun-rds-bkp-0.1.6.tar.gz", "has_sig": false, "md5_digest": "671ff4a1285dabbb7e37b11da01d2ef5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8158, "upload_time": "2019-03-29T03:47:44", "url": "https://files.pythonhosted.org/packages/e5/7c/bf20585ee1c78af4fb7a14a2b56c38bfdc7b364d21d08721b685bbe0bd46/aliyun-rds-bkp-0.1.6.tar.gz" } ] }