Support » Fixing WordPress » Using the same database of another blog

  • Resolved AnnBaxter


    Hi –

    I am in the process of developing a new theme and contents for a blog (let’s call it “1st”) that is active at 1st domain.

    Right now the development takes place on a 2nd domain with a 2nd WP database set up just for this purpose.

    Is there a way to link the 2nd theme under development to the 1st WP database without disrupting the the 1st theme and contents?

    I did try this, but when the visitor of the 1st blog goes beyond the index.php page (single.php or Page) it takes you to the 2nd theme under development.


Viewing 10 replies - 1 through 10 (of 10 total)
  • The url of your blog is stored in the database and all links were build by using this stored url.

    You could change the code (after asking for url manually override it with the second url).

    Moderator Samuel Wood (Otto)

    (@otto42) Admin

    Is there a way to link the 2nd theme under development to the 1st WP database without disrupting the the 1st theme and contents?

    No. Not without a large rewrite of all of WordPress.

    it sounds like you wrote a theme, now you want it on a different database. wouldn’t you just copy the theme like getting any other theme for WordPress? or am I just being dense today? it happens

    Thanks for the replies. The new 2nd theme I am working on will replace the 1st theme. It would be nice, in the meantime, to have real content to work with,rather than a near empty database.

    What if I made a backup of the 1st database, rename it, and link it to the theme under development? When done, I simply upload the new theme to the original blog and switch the old one with it. Would that work?


    There is an easier way to go about this:

    Though it says it “allows your readers to switch among installed themes,” there’s nothing stopping you from *not* providing a method to readers, and just switching the theme manually in your url:


    you could always do a second WordPress install in a different directory and point it to the tables for the first blog. Then use the second install for you sandbox. Just know that any test entries in teh sandbox will end up in your actual blog.

    Starkmann – read the 2nd and 3rd responses in this thread again!

    I did, but it didn’t mean anything to me, sorry, slow learner. I’ll try a test case with my own, maybe that’ll get it through my head.

    Thanks, all.

    well, I’d still like to know how to do this… because nothing above explains the differences between what I read and see in tutorials for moving the db of a wp install to another wp install…

    When I go to pma, the SQL screen shows the first part (where you can copy and paste the content in the sql, assuming you’ve figured out a way to open the db backup and not see garbage…

    but the bottom part, where you browse to a file, isn’t displayed… I see something similar in a tab named IMPORT (so not in SQL) but when I browse to the file (which downloaded from updater as a .gz file) and click go, it always comes back with a lengthy error…

    Granted, the imported wp db was in v2.0.4 and the new wp install is 2.0.5

    How to do this? The tutorials don’t match what I see…
    using: phpMyAdmin v2.9.0.2 with MySQL client version 4.1.10

    basic steps is what I need. Here’s what I’ve done, so far:

    1) backed up db and files for install#1, installed on
    2) created subdomain
    3) installed WP, v2.0.5 (no other option)

    Now I want to move the saved db from install#1 to the new wp db at install#2… I know how to move the files (theme, others…) via FTP, but getting the db data and matching up the logins, pwords, etc is what I’m missing – or, my version of the db admin doesn’t match the tutorial’s


Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Using the same database of another blog’ is closed to new replies.