ITGuy

Hi,

Just as a follow up and to close this topic.
My issue was with data serialization. I moved everything, but by replacing the links in the sql database, it created issues on the pages appearance once moved. I used the tool provided by:

https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

The only thing is that doing it in the production environments is too risky.

I basically followed these steps and worked great:

1.- Create New Database for WordPress (Copy original and assign new user and password).
2.- Install PHP tool available in link above (intereconectit). I used the 2.1.0 version (stable).
3.- Run tool and replace previous Link typing full link : “https://www.xxxx.com/wp” with “https://www.xxxx.com”.
4- Copy all “/wp” files to root directory.
5.- Edit .htaccess (RewriteBase “/”, RewriteRule “/index”, RewriteCond “/sandbox”).
6.- Edit wp-config.php (DB_NAME, DB_USER, DB_PASSWORD, WPCACHEHOME)
7.- Log into old WordPress /wp/wp-admin and in Settings>General> change
WordPress Address (URL) and Site Address (URL) removing “/wp”
8.- Log into WordPress https://www.xxxxxxxx/wp-admin (No more xxxx/wp/wp-admin).
9.- Remove PHP tool from intereconectit (important).
10.- Test your new site before you remove the “/wp” directory and DB.

Hope this helps others to avoid all the pain I went through.

Yes, I know.
I was testing the new “Sandbox” plugin before I moved to the root directory and I created a Sandbox called development and that is why WordPress adds a new table in the database with “wp_<sanbox>_options” which has a column “siteurl” that also needs to be updated.

I guess my main problem right now is that all the customization done to the theme I used seems to be lost. I am looking for the steps to also move the customization. I thought they were moved with all the files I copied to the root directory. <Step 2> above.

Thanks esmi. I was following those steps, but right after I reached number 6, I had to look for other blogs since it was a bit confusing. I think the blog is missing some steps I outlined above. Probably 14 is not for everyone since the “sandbox” option is fairly new.

Any other suggestion?
Thanks,

Thanks for your comment barteled.

It seems to be working now. While backing up through FTP before using this plugin, I moved a folder to the wrong position. Nothing to do with the plugin. Thanks for your help. Issue close.

I am developing a portal having wordpress as the frontend and java as the backend through Tomcat 6. It was working great and was able to have pages on wordpress and redirect to jsp pages on Tomcat.

I have to remove the”/wp” directory from tomcat to make PHP work, but today I installed the “sandbox” plugin and for some reason I have no more access to my wordpress directories. I see the files are still there and a new “/wp/sandbox” directory was created.

Would this plugin be the reason why PHP stopped working?
Are wordpress settings or requirements changed after installing the new plugin?

The site(frontend) went down completely and my hosting provider has not come back to me giving me a status. I was just wondering if I might have created this problem when installing this plugin and need to have them configure wordpress in a different way.
Thanks for your help.