18 Feb
2020
18 Feb
'20
1:31 a.m.
Hello,
I know there's a few WordPress experts here. Can I pick your brains?
Say I have a WP site at https://dev.example.com/ and I now want to
copy it and put it live at https://example.com/. Having read:
https://wordpress.org/support/article/changing-the-site-url/
do I just…
- Copy the filesystem structure from one document root to another
- Dump the database and re-insert it into a new database
- Install wp-cli and run
$ wp search-replace 'dev.example.com' 'example.com' --skip-columns=guid
and then it's all switched?
Cheers,
Andy
18 Feb
18 Feb
8:02 a.m.
On Tue, 18 Feb 2020 at 01:31, Andy Smith <andy(a)bitfolk.com> wrote:
Hello,
I know there's a few WordPress experts here. Can I pick your brains?
Say I have a WP site at https://dev.example.com/ and I now want to
copy it and put it live at https://example.com/. Having read:
https://wordpress.org/support/article/changing-the-site-url/
do I just…
- Copy the filesystem structure from one document root to another
Yup.
- Dump the database and re-insert it into a new database
Yup, then edit wp-config.php with your new database settings.
- Install wp-cli and run
$ wp search-replace 'dev.example.com' 'example.com' --skip-columns=guid
and then it's all switched?
Don’t do that last part unnecessarily - you should just be able to follow
the section titled “Changing the URL directly in the database” (editing the
‘home’ and ‘siteurl’ values in the wp_options table) and give the site a go.
If you have any plugins installed that for some reason store the site
address in their tables and/or config, then you may need to go down that
search and replace route, but most sane plugins should use those values in
the wp_options table.
-n
12:15 p.m.
That wp-cli stuff is too high tech for me
I just dump the SQL and sed it for the hostname then reload - or just do
it manually, it's usually two rows in wp-options table
For plugins I find + grep the files
Been working up to now.
Usual suspects are slideshow plugins and post uploads that contain full
URLs. The sql sed gets them.
--GM
19 Feb
19 Feb
1:07 p.m.
On 18/02/2020 12:15, G. Miliotis via users wrote:
That wp-cli stuff is too high tech for me
I just dump the SQL and sed it for the hostname then reload - or just do
it manually, it's usually two rows in wp-options table
The problem is that some plugins serialize their data [1] and it will
get broken. I use this:
https://interconnectit.com/products/search-and-replace-for-wordpress-databa…
but find that it generally works best from the command line.
[1] because Wordpress.
1766
days inactive
1768
days old
4 comments
4 participants
participants (4)
-
Andy Smith -
Dom Latter -
G. Miliotis -
William Anderson