mamchenkov/mysql-find-and-replace
Composer 安装命令：
composer require mamchenkov/mysql-find-and-replace
包简介
Find and replace tool for MySQL
README 文档
README
NOTE There is a better way now - use interconnectit/Search-Replace-DB. It has verbosity control, collation converter and works both with command line and web interface. It's just better.
This script performs a find and replace operation across all fields, of all tables in a specified MySQL database. On top of regular fields, it also processes serialized values.
This code is heavily based on MySQL search and replace script written by David Coveney, and he deserves all the credit. The original script is here:
http://davidcoveney.com/782/mysql-database-search-replace-with-serialized-php/
My changes so far are:
- CLI, not web based. In the future, it will support both environments.
- Fail on any MySQL error. Original code was just printing out the message.
- Run-time configuration through CLI options
- Lots of coding style changes (work in progress).
- Composer installer
Install
Install with composer like so:
{
"require": {
"mamchenkov/mysql-find-and-replace": "1.0.*"
}
}
Usage
Always, always, always backup your database before usage:
$ mysqldump test_db > test_db.backup.sql
Run the script like so:
$ ./bin/mysql-replace.php database=test_db find=foo replace=bar
mamchenkov/mysql-find-and-replace 适用场景与选型建议
mamchenkov/mysql-find-and-replace 是一款 基于 PHP 开发的 Composer 扩展包，目前已累计 92 次下载、GitHub Stars 达 3， 最近一次更新时间为 2014 年 10 月 10 日， 在 PHP 生态内属于活跃度较高的组件。
它主要适用于以下技术方向： 「database」 「mysql」 「strings」 「find-replace」 等业务场景。在实际项目中，围绕这些方向常见需要落地的问题包括：接口对接、性能调优、并发安全、与既有框架（Laravel / ThinkPHP / Yii / Webman 等）的兼容适配，以及生产环境的日志埋点与稳定性保障。
我们在过去多个企业项目中使用过 mamchenkov/mysql-find-and-replace 或与其功能相近的方案，如果你在选型或落地过程中遇到问题，例如 版本兼容、二次改造、私有化封装、与内部系统对接、生产 BUG 排查，欢迎联系我们协助评估。
基于 mamchenkov/mysql-find-and-replace 在你已有业务上做功能扩展、字段裁剪、UI 适配、与内部账号 / 权限 / 日志系统的深度对接。
线上偶发问题、内存泄漏、慢查询、并发异常等排查修复；针对高流量场景做缓存、队列、索引层面的调优。
承接完整的项目从需求 → 设计 → 开发 → 上线 → 长期运维；也可按月提供技术保姆服务。
与 mamchenkov/mysql-find-and-replace 相关的其它包
同方向 / 同关键字的高下载量 PHP Composer 包推荐，方便对比选型：
Dibi is Database Abstraction Library for PHP
Store your language lines in the database, yaml or other sources
A package for automatically encrypting and decrypting Eloquent attributes in Laravel 5.5+, based on configuration settings.
Generate pseudo locale string for unicode testing and marking missing strings
A PSR-7 compatible library for making CRUD API endpoints
Strings Component provide a fluent, object-oriented interface for working with multibyte string, allowing you to chain multiple string operations together using a more readable syntax compared to traditional PHP strings functions.
统计信息
- 总下载量： 92
- 月度下载量： 0
- 日度下载量： 0
- 收藏数： 3
- 点击次数： 1
- 依赖项目数： 0
- 推荐数： 0
其他信息
- 授权协议： GPL-2.0
- 更新时间： 2014-10-10