WordPress.org

Ready to get started?Download WordPress

Forums

Transferring between tables within databases... (3 posts)

  1. thefictionalme
    Member
    Posted 9 years ago #

    So, is there a way to move wordpress entries from one set of tables in a database to another? The reason I ask is because I installed a new version of wordpress for my new domain and I now have this brand new version but all my old wordpress entries are in the other tables. Please tell me there's a neat little sql statement that will let me do it.. I finally have the new version of WordPress working for my new domain. I want to remove the blog altogether from thefictionalme.com since I'll have the blog on my new domain. But I don't want to lose all those entries (almost 500) dating back to 2002. Please help..

    *draws a picture*

    original blog from thefictionalme.com is sitting in the database thefict_wordpress in tables:
    wp_categories
    wp_comments
    wp_linkcategories
    wp_links
    wp_optiongroup_options
    wp_optiongroups
    wp_options
    wp_optiontypes
    wp_optionvalues
    wp_post2cat
    wp_postmeta
    wp_posts
    wp_users

    new blog from new domain is sitting in the database thefict_wordpress in tables:
    secret_categories
    secret_comments
    secret_linkcategories
    secret_links
    secret_options
    secret_post2cat
    secret_postmeta
    secret_posts
    secret_users

    Is it possible people?

  2. moshu
    Member
    Posted 9 years ago #

    Just thinking aloud...
    I assume the "old" blog uses an older version of WP. I also assume the new blog is still empty (maybe except some test posts).
    What I'd try: drop the tables from the new DB; export/backup the old DB; import the old db into the new database; modify accordingly the new config file to find an proper prefix; run an upgrade.php on the new blog.
    With proper backup there is nothing to lose.

  3. Mark (podz)
    Support Maven
    Posted 9 years ago #

    That first blog is not 1.5, the second one is.
    You have upgrading to do.

    Backup everything.

    Upgrade first blog to 1.5.1.1
    Using phpmyadmin, rename the tables
    Export
    Import to new
    run upgrade.php again.

    Like moshu says though - proper backup

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags