Open adampatterson opened 5 years ago
I came across the scenario of moving my S3 bucket and while doing that also changed the path.
I upload an image, It is sent to Kraken.io, and Uploaded to S3 using Media Offload.
I made a copy locally of the database and ran wp search-replace 'old-bucket 'new-bucket. To my joy, the serialized string was also updated.
wp search-replace 'old-bucket 'new-bucket
My next task was to update the media path. Previously it would have been old-bucket/year/month
old-bucket/year/month
Now it would be new-bucket/media/year/month
new-bucket/media/year/month
If I were to search and replace based off of /2015 I am going to affect the _wp_attached_file and _wp_attachment_metadata
_wp_attached_file
_wp_attachment_metadata
Is it possible to search inside of two columns where one column value is equal to something else?
Like look in meta_value where meta_key == amazonS3_info?
meta_value
meta_key
amazonS3_info
I came across the scenario of moving my S3 bucket and while doing that also changed the path.
I upload an image, It is sent to Kraken.io, and Uploaded to S3 using Media Offload.
I made a copy locally of the database and ran
wp search-replace 'old-bucket 'new-bucket. To my joy, the serialized string was also updated.My next task was to update the media path. Previously it would have been
old-bucket/year/monthNow it would be
new-bucket/media/year/monthIf I were to search and replace based off of /2015 I am going to affect the
_wp_attached_fileand_wp_attachment_metadataIs it possible to search inside of two columns where one column value is equal to something else?
Like look in
meta_valuewheremeta_key==amazonS3_info?