Skip to content

Instantly share code, notes, and snippets.

@02Tea

02Tea/search_replace_db_cli.md

Created June 6, 2019 16:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 02Tea/4fc81b76686dd3b517ec8ffc6ca4fdc9 to your computer and use it in GitHub Desktop.
Save 02Tea/4fc81b76686dd3b517ec8ffc6ca4fdc9 to your computer and use it in GitHub Desktop.
Download ZIP
[Search Replace DB CLI] #srdb #database #cli #mysql #mariadb
Raw
search_replace_db_cli.md

Dry run

php srdb.cli.php -h <172.21.0.4> -n <database_name> -u <database_user> -p <database_password> --port <database_port> -s <search_string> -r <replace_query> -z

Run

php srdb.cli.php -h <172.21.0.4> -n <database_name> -u <database_user> -p <database_password> --port <database_port> -s <search_string> -r <replace_query>

More commands

php srdb.cli.php --help
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment