WordPress.org

Ready to get started?Download WordPress

Forums

Categories and tags problem - moved from one host to another (4 posts)

  1. ashishagarwal74
    Member
    Posted 1 year ago #

    Hi,

    I was moving multiple blogs from one host to another, and one of them is giving an error I am unable to figure out. During the restore of the SQL script through phpMyAdmin, the following error shows up:

    SQL query:

    INSERT INTO wp_term_taxonomy
    VALUES ( 1301, 1096, 'category', '', 12, 1 ) ;

    MySQL said:
    #1062 - Duplicate entry '1301' for key 'PRIMARY'

    And all the posts have missing categories and tags.

    The 'wp_terms' table has only 2 entries. I tried reading up the Codex entry for database tables and also http://www.cumps.be/nl/blog/read/wordpress-26-upgrade-fix-missing-categories, but not sure whether these are the same problem.

    Thanks,
    Ashish

  2. vtxyzzy
    Member
    Posted 1 year ago #

    What method did you use to move the database? One database backup plugin that I used in the past (I forget which one) caused this error.

    Here is an article with the steps I use to migrate (copy) a site: http://wordpress.mcdspot.com/2012/08/22/migrating-a-wordpress-site-step-by-step/

  3. ashishagarwal74
    Member
    Posted 1 year ago #

    Thanks for the response. These are the steps that I followed:

    1. Exported SQL backup using WP-DB-Backup plugin and saved SQL to my local machine.
    2. Setup domain on new host
    3. Install WP on the new account with same admin and pwd
    4. Through phpMyAdmin, on the same DB, import SQL saved in step 1

    This worked for many of the domains, but failed in this specific case.

  4. vtxyzzy
    Member
    Posted 1 year ago #

    That will work as long as the domain name and path remain the same. However, the way paths are constructed varies among hosts.

    For example, a path on HostGator looks like this: /home/farful/public_html

    while a path on GoDaddy looks like this: /home/content/44/963572/html

    To move a site, you must use a method that will properly substitute the new path for the old one.

Topic Closed

This topic has been closed to new replies.

About this Topic