Throughout a web site transfer the wp-config.php file was changed (by the host) to hook up with the brand new database, and a directive I had in my outdated model (that specified a root folder for all photographs as a substitute of the WP default ‘uploads’ folder) didn’t make it into the brand new wp-config.php file.
By the point I observed it, we had loads of content material added with the photographs now within the /uploads folder.
I copied all the photographs now in /wp-content/uploads to /photographs, however I would like a SQL question to cull through all the content material and discover&exchange any picture URLs that time to the /wp-content/uploads folder.
I get more adept with PHP on daily basis however nonetheless very weak with SQL, hoping somebody may help me – I do not thoughts including a short lived plugin to do search & exchange, but it surely looks like it must be easy to perform with no plugin. I do have entry to phpMyAdmin and am all the time super-careful after I use it, backing up my database all the time earlier than making modifications.
