Essentially what I want to do is move my site to a subdomain (test.mydomain.com) so I can test some things. After that I would then need to place it on the root of my site (mydomain.com). Possible without screwing things up?
One of the best features of Dreamweaver is its site manager. Even without it, its not too difficult to create a zip of your entire site, then move it to your testing server. If you set up a subversion server (or app), you can keep track of the changes you make.
I think I've used Dreamweaver for about a day. I have to say I'm not a fan of anything it offers. I use ST2. I'm not too skilled in development or if at all in the backend so I usually just read tutorials on these types of things. Appreciate the help from everyone.
I'm assuming from how you are writing that out you are simply moving sequentially: localhost > test domain > live.
If that's the case, you can pretty quickly do this with just changing 2 values in the mySQL database and then using something that TheDoc hooked me on called Velvet Blue's update URL's plugin.
Basically, you'll go on your test.domain and install a fresh copy of wordpress. Then go to your localhost and export the mySQL database. Then go into your test.domain and import it to your new fresh mySQL database that was put in place when you installed WP. Go into the mySQL manager and then navigate into the WP_Options table and change two values (home address and site admin) - you'll see them - they are the only two in there with a full URL. Just change that to your test.domain. Install Velvet Blue's Update URLs and then use it to change all your images, posts, excerpts, etc.
Then once are ready to go live and make all your changes and it's how you want it, go into the Wordpress dashboard and under "General" change the URL there to the new one you will move it to. Grab your files and move them to the root. You can then log into the WP dashboard again and then run Update URLs for the last time and you're pretty much golden.
Oh one thing to mention is that you'll need to make sure the info in your wp-config.php has the right info in it. It will most likely be different from the localhost version, so just change that file once you've imported the database to your test domain.
Hi. I am trying to make a test site on wordpress. I have a created a subdomain. I want to keep my current website live so that I can work on the new one without any problems. I want to move from WPEC to Woocommerce and also change my theme. There is an extension that I can use to export all my products from WPEC to Woocommerce so I need a replica of my website put onto my subdomain so that I can do this. I have imported my current sql database to the test domain and I have also uploaded all of my WP Content files to my subdomain. I followed the steps above set out by @joshwhite for changing the options tables etc... The problem is that none of my info has come into my test site. It's all as if it's a brand new installation still. None of my products are there or anything. The theme is like the original theme. Not my layout. Please can someone offer me any advice? I basically need a replica of my website to be put onto the subdomain. I have done all of the steps above. I'm confused....it just looks like a new installation. :-( I thank you all in advance and Happy New Year! :-)
Eek, I didn't realise anyone had replied. :-( Just changed my settings. Hi yes @chrisburton I imported the database. Someone told me that I should use the export/import tool in wordpress admin. I did that. Now all my products and everything are there but I had to change a lot of things. Why wasn't it a carbon copy? Also my theme still isn't the way I customised it to be. It's the original file that I purchased. :-( Does anyone have any suggestions? I am going to buy a new theme and use a different shopping cart anyway. Problem is that i don't want to do the all work on them on the test site/subdomain and then have all of these problems again when I try to put it back onto my main domain. That would seriously send me under so I rather find out what is wrong now instead. Then I will be good to go. :-) @andy_unleash I had left my comment a few ago so no worries! ;-)
The setting I had to change were in the WPEC...none of my Store settings etc are there. Currency, shipping, payment etc etc... All blank! Very strange
Since messaging you yesterday, I have discovered that you can import and export the actual Theme settings. So I have done that and sorted permalinks etc however...all is not well. My widgets are not there and I had to delete some pages and also there now appears to be two 'Home' Pages...one of which should come under 'Blog'. Half of my photos on the homepage are missing. :-(
This is putting me setting up the new test site if I am going to have to make loads of changes again once move it. Shouldn't I have been able to have an exact carbon copy of my website and settings once importing everything? Not even any of my plugins or theme were activated. :-(
As @TheDoc said, all your information should have been stored in the database from exporting to importing. When I moved Wordpress, I uploaded a fresh install, changed the config file to match my old database and then imported the database through PHPMyAdmin. From there I changed all the URL's which you can do via a plugin that Gray might be able to post here. I always forget the name.
Hi, I'm new to wp and have been building a site in localhost and now I'm trying to move it to a /dev site for user to upload content before the website goes live.
I've exported the mysql database as explained on this discussion from PHPMyAdmin and all went well. But when I went to the host and tried importing it from the application on that side, it threw an error. Can anyone help with this?
@euge So you exported your database from the local version, installed Wordpress on the live version, imported the database, changed all necessary URL's using the plugin above and you received that error?
Hi, I ended up solving this. Thanks for your help.
I was trying to import the database with a copy of wordpress already installed.
After a while I figured out I had to import it before I installed the wordpress files.
Thanks again
http://codex.wordpress.org/Moving_WordPress
http://interconnectit.com/124/search-and-replace-for-wordpress-databases/
If that's the case, you can pretty quickly do this with just changing 2 values in the mySQL database and then using something that TheDoc hooked me on called Velvet Blue's update URL's plugin.
Basically, you'll go on your test.domain and install a fresh copy of wordpress. Then go to your localhost and export the mySQL database. Then go into your test.domain and import it to your new fresh mySQL database that was put in place when you installed WP. Go into the mySQL manager and then navigate into the WP_Options table and change two values (home address and site admin) - you'll see them - they are the only two in there with a full URL. Just change that to your test.domain. Install Velvet Blue's Update URLs and then use it to change all your images, posts, excerpts, etc.
Then once are ready to go live and make all your changes and it's how you want it, go into the Wordpress dashboard and under "General" change the URL there to the new one you will move it to. Grab your files and move them to the root. You can then log into the WP dashboard again and then run Update URLs for the last time and you're pretty much golden.
Hi. I am trying to make a test site on wordpress. I have a created a subdomain. I want to keep my current website live so that I can work on the new one without any problems. I want to move from WPEC to Woocommerce and also change my theme. There is an extension that I can use to export all my products from WPEC to Woocommerce so I need a replica of my website put onto my subdomain so that I can do this. I have imported my current sql database to the test domain and I have also uploaded all of my WP Content files to my subdomain. I followed the steps above set out by @joshwhite for changing the options tables etc... The problem is that none of my info has come into my test site. It's all as if it's a brand new installation still. None of my products are there or anything. The theme is like the original theme. Not my layout. Please can someone offer me any advice? I basically need a replica of my website to be put onto the subdomain. I have done all of the steps above. I'm confused....it just looks like a new installation. :-( I thank you all in advance and Happy New Year! :-)
I may be wrong, but the way I handle Wordpress local, staging and live is adding to each placement's individual wp-config.php;
Works for me, then you don't have to mess about with the MySQL each time and can have a consistent SQL between all of them.
Note sure if anyone can point to a potential problem with this method though?
Did you export your database?
@Chrisburton No I just host the DB in a live location from the beginning, so sit it on one of our VPS servers or wherever it would be ending up.
@andy_unleash Ha. That question was towards the person above you (@loubou).
My bad! Just realised from August as well - nothing to see here folks, ignore me and move along!
Eek, I didn't realise anyone had replied. :-( Just changed my settings. Hi yes @chrisburton I imported the database. Someone told me that I should use the export/import tool in wordpress admin. I did that. Now all my products and everything are there but I had to change a lot of things. Why wasn't it a carbon copy? Also my theme still isn't the way I customised it to be. It's the original file that I purchased. :-( Does anyone have any suggestions? I am going to buy a new theme and use a different shopping cart anyway. Problem is that i don't want to do the all work on them on the test site/subdomain and then have all of these problems again when I try to put it back onto my main domain. That would seriously send me under so I rather find out what is wrong now instead. Then I will be good to go. :-) @andy_unleash I had left my comment a few ago so no worries! ;-)
@Loubou I would suggest contacting the theme owner if you've exhausted all your efforts.
@chrisburton I can't. He's really sick and been out of action since July. :-( Hopefully I can figure it out. :-)
@Loubou Would you be willing to give me access to your site so I can poke around? If not, perhaps we can troubleshoot further?
@chrisburton Thank you. I would be very grateful if we could do further troubleshooting. :-)
@Loubou. Great. When you say you had to change a lot of "things" when importing your content, what were those changes?
Thanks @chrisburton :-)
The setting I had to change were in the WPEC...none of my Store settings etc are there. Currency, shipping, payment etc etc... All blank! Very strange
Since messaging you yesterday, I have discovered that you can import and export the actual Theme settings. So I have done that and sorted permalinks etc however...all is not well. My widgets are not there and I had to delete some pages and also there now appears to be two 'Home' Pages...one of which should come under 'Blog'. Half of my photos on the homepage are missing. :-(
This is putting me setting up the new test site if I am going to have to make loads of changes again once move it. Shouldn't I have been able to have an exact carbon copy of my website and settings once importing everything? Not even any of my plugins or theme were activated. :-(
Definitely should have done the import/export through phpMyadmin, it's the only way to make sure that you get all of the content.
As @TheDoc said, all your information should have been stored in the database from exporting to importing. When I moved Wordpress, I uploaded a fresh install, changed the config file to match my old database and then imported the database through PHPMyAdmin. From there I changed all the URL's which you can do via a plugin that Gray might be able to post here. I always forget the name.
;) http://wordpress.org/extend/plugins/velvet-blues-update-urls/
And you'll need to modify two options in the DB in the wp_options table for the site root/url.
Hi, I'm new to wp and have been building a site in localhost and now I'm trying to move it to a /dev site for user to upload content before the website goes live. I've exported the mysql database as explained on this discussion from PHPMyAdmin and all went well. But when I went to the host and tried importing it from the application on that side, it threw an error. Can anyone help with this?
Error SQL query:
-- --------------------------------------------------------
-- Table structure for table
wp_commentmetaCREATE TABLE
wp_commentmeta(meta_idBIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,comment_idBIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0',meta_keyVARCHAR( 255 ) DEFAULT NULL ,meta_valueLONGTEXT, PRIMARY KEY (meta_id) , KEYcomment_id(comment_id) , KEYmeta_key(meta_key) ) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;MySQL said:
1050 - Table 'wp_commentmeta' already exists
@euge So you exported your database from the local version, installed Wordpress on the live version, imported the database, changed all necessary URL's using the plugin above and you received that error?
Hi, I ended up solving this. Thanks for your help. I was trying to import the database with a copy of wordpress already installed. After a while I figured out I had to import it before I installed the wordpress files. Thanks again
This plugin:
http://wordpress.org/extend/plugins/duplicator/
should do the trick.