, (*1)
Search Replace DB - v4.1.3
This script was made to aid the process of migrating PHP and MySQL
based websites. Works with most common CMSes., (*2)
If you find a problem let us know in the issues area and if you can
improve the code then please fork the repository and send us a pull
request :), (*3)
What's New
- Support for continuous integration through Travis CI
- Ability to do multiple search-replaces
- Ability to exclude tables
- Remove specific loaders for WP
- No longer automatically populate DB fields, this was causing security issues for users leaving the script on their site
- Script now checks whether the correct version of PHP is used
- Script checks if necessary modules are installed
- Script checks if the connection is secure and gives a warning otherwise
- Bug fixes
- UI Tweaks
- Password is not mandatory in CLI
- Ability to connect using SSL, command line only feature
Warnings & Limitations
We can't test every possible case, though we do our best. Backups and
verifications are important., (*4)
You use this script at your own risk and we have no responsibility for
any problems it may cause., (*5)
There are many edge cases and WordPress plugins that likes to mess
your database, we don't have a silver bullet., (*6)
The license for this software is GPL v3, please bear this in mind if
contributing or branching., (*7)
Do backups, also do backups and finally do backups!, (*8)
Usage
- Do backups.
- Migrate all your website files.
- Upload the script folder to your web root or higher.
- Browse to the script folder URL in your web browser.
- Fill in the fields as needed.
- Choose the
Do a safe test run button to do a dry run without searching/replacing.
Installation
To install the script, please place the files inside your sites public folder and head to yoursiteURL/Search-Replace-DB, (*9)
CLI script
To invoke the script, navigate in your shell to the directory to where
you installed Search Replace DB., (*10)
Type php srdb.cli.php to run the program. Type php srdb.cli.php
--help for usage information:, (*11)
-h, --host
Required. The hostname of the database server.
-n, --name
Required. Database name.
-u, --user
Required. Database user.
-p, --pass
Database user's password.
-P, --port
Optional. Port on database server to connect to. The default is
3306. (MySQL default port).
-s, --search
String to search for or `preg_replace()` style regular
expression.
-r, --replace
None empty string to replace search with or `preg_replace()`
style replacement.
-t, --tables
If set only runs the script on the specified table, comma
separate for multiple values.
-w, --exclude-tables
If set excluded the specified tables, comma separate for multuple
values.
-i, --include-cols
If set only runs the script on the specified columns, comma
separate for multiple values.
-x, --exclude-cols
If set excludes the specified columns, comma separate for
multiple values.
-g, --regex [no value]
Treats value for -s or --search as a regular expression and -r or
--replace as a regular expression replacement.
-l, --pagesize
How rows to fetch at a time from a table.
-z, --dry-run [no value]
Prevents any updates happening so you can preview the number of
changes to be made
-e, --alter-engine
Changes the database table to the specified database engine eg.
InnoDB or MyISAM. If specified search/replace arguments are
ignored. They will not be run simultaneously.
-a, --alter-collation
Changes the database table to the specified collation eg.
utf8_unicode_ci. If specified search/replace arguments are
ignored. They will not be run simultaneously.
-v, --verbose [true|false]
Defaults to true, can be set to false to run script silently.
--debug [true|false]
Defaults to false, prints more verbose errors.
--ssl-key
Define the path to the SSL KEY file.
--ssl-cert
Define the path to the SSL certificate file.
--ssl-ca
Define the path to the certificate authority file.
--ssl-ca-dir
Define the path to a directory that contains trusted SSL CA
certificates in PEM format.
--ssl-cipher
Define the cipher to use for SSL.
--ssl-check [true|false]
Check the SSL certificate, default to True.
--allow-old-php [true|false]
Suppress the check for PHP version, use it at your own risk!
--help
Displays this help message ;)
Example cli commmands:
php srdb.cli.php -h dbhost -n dbname -u root -p "" -s "http://www.yourdomain.com" -r "http://newdomain.com"
php srdb.cli.php -h dbhost -n dbname -u root -p "password" -s "http://www.yourdomain.com" -r "http://newdomain.com"
php srdb.cli.php -h dbhost -n dbname -u root -p "password" -s "search" -r "replace"
Troubleshooting
Nothing works after the search/replace operation!
It's time to use your backups!, (*12)
This happens occasionally and could be for a couple of reasons:, (*13)
-
When the script starts, it attempts to start your WordPress or
Drupal installation to auto-detect your username and password
settings. If this fails, you will see a message informing you that
auto-detection failed. You will have to enter your details
manually., (*14)
-
Script was unable to set the timeout so PHP closed the connection
before the table could be processed, this can happen on some server
configurations., (*15)
Contributing
You can view the source code and submit a pull request using GitHub,
the project's page is located at:, (*16)
https://github.com/interconnectit/Search-Replace-DB/, (*17)
We appreciate a small unittest among the code, please explain what
you are is trying to solve., (*18)
License
This file is part of Search-Replace-DB., (*19)
Search-Replace-DB is free software: you can redistribute it and/or
modify it under the terms of the GNU General Public License as
published by the Free Software Foundation, either version 3 of the
License, or any later version., (*20)
Search-Replace-DB is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
General Public License for more details., (*21)
You should have received a copy of the GNU General Public License
along with Search-Replace-DB.
If not, see https://www.gnu.org/licenses/., (*22)
Wallogit.com
