归档MYSQL表数据的好方法？
我最近继承了一个网站，他们有一个使用 phpmaker 创建的简单后端区域。后台显示各种MYSQL数据库表。
有两个表保存与公司在线举办的促销/竞赛相关的注册信息。客户希望开始每月归档注册数据，但仍然可以访问数据以供将来导出或审查。
那么，谁能告诉我实现这一目标的最佳方法是什么？我读过有关分区和 Maatkit 的内容，但我不确定哪一个 - 如果有的话 - 将是一个明智的选择。
我希望保持表名相同，因为在运行促销/竞赛应用程序的 PHP 代码中的多个实例中引用了表名。我还希望一切都是“自动”的，或者至少通过单击按钮来执行；尽管我意识到这可能并不完全现实。
我应该注意，我没有 phpmaker 项目文件并且无法获取它。
对此事的任何帮助都会有很大帮助。
I recently inherited a website and they have a simple back-end area which was created using phpmaker. The back-end displays various MYSQL database tables.
There are two tables which hold registration information related to promotions/contests the company runs online. The client wants to begin archiving the registration data monthly, but still have the data accessible for future export or review.
So, can anyone tell me what the best approach would be to achieve this? I read about partitioning and Maatkit, but I'm not sure which - if either - would be a smart choice.
I would prefer to keep the table names the same because the table name is referenced in several instances within the PHP code running the promo/contest applications. I would also like for everything to be 'automatic' or at least executed at the click of a button; though I realize that might not be completely realistic.
I should note that I do not have the phpmaker project file and have been unable to obtain it.
Any help on this matter would be a great help.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
MK-Archiver 这是归档实时 mysql 数据库表的好方法
MK-Archiver 的作用是归档来自一个表到另一个表和/或一个文件
MK-Archiver This is a good way to archive live mysql database tables
What MK- Archiver does is to archive rows from a table to another table and/or a file