Wordpress Site Redesign

Posted on 2011-02-19
Last Modified: 2012-05-12
I have an existing Wordpress site with a fairly large database.  I want to redesign with new theme, categories etc.  I have created a sub domain to do redeisign, should I use same database as existing site or create new database?  Then I am not sure how to make the new sub domain become old domain but with new look.

Not sure how best do this with little downtime to live site. Advice? Thank you
Question by:kerre
  • 2
  • 2
  • 2
  • +1

Assisted Solution

andreizz earned 250 total points
ID: 34934624
You don't need your old database, just use a fresh install one, that has 1 comment and 1 article to test your css and design, or you could use a empty one and create 1 element from each category so you can view how to customize everyting.
LVL 18

Accepted Solution

Sudaraka Wijesinghe earned 250 total points
ID: 34934711
It's not a good practice to point your test/development web site and the production web site to the same database in general.

Like andreizz mentioned you can use a simple DB or a separate copy of your production DB for your development site.

When you are finally ready to go live with the new web site, you can simply change the the site is using on the wp-config.php file (and change the DNS of cause), Or copy your new theme directory to the production site and activate it there.

However, If you install any new plugins or updates that changes the DB structure you will need to install them again in the production site.

Author Comment

ID: 34935192
@Wizard, I've got my sub domain, installed new DB and WP, but then can I import DB from existing site so I can really alter categories, look & feel?    The existing site's database is huge so I would only import a small part of it via Php My Admin.  Get the sub site looking right.  Then add that new theme to existing site.  But not clear on how to get the existing site to look like the test sub domain site.

I'm not making any sense am I?  Sorry :(
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

LVL 18

Expert Comment

by:Sudaraka Wijesinghe
ID: 34935721
You can copy table between two databases as explained in here

Expert Comment

ID: 34936150
Well when you work on the subsite, make a new theme(copy an old one and rename) and when you are done and all is good on the subsite, just copy that new theme in your existing's site theme directory and activate it from admin panel, it's that easy.

You did the part with the database perfectly.

Author Comment

ID: 34963652
Ok, almost there.  When I upload new theme from sub domain to existing site, do I also import via Php Myadmin the new database?  I don't understand how all the redesign I've done in sub domain would make it onto the existing site, unless I changed the WP-config, but then that would reflect an almost empty database and not the existing big one I want to keep?

LVL 70

Expert Comment

by:Jason C. Levine
ID: 36508817
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

WordPress has made it easy to create scalable sites based on their powerful CMS, but as great as WordPress is, there are some SEO issues that haven’t been addressed out of the box.  Fortunately these problems can be solved with a few plugins.  The f…
How to install BuddyPress on your self-hosted WordPress site It’s been called everything from “social networking in a box” to “Facebook without the terms of service,” but until Feb. 16, BuddyPress was a relatively unknown outside the WordPress MU…
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: : Open Page or Post…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now