WordPress.org

Ready to get started?Download WordPress

Forums

error (1062) importing database, but no changes... (1 post)

  1. Skeary
    Member
    Posted 6 years ago #

    I'm trying to correct the character display problem on my old blog that I'm trying to move from an old backup on my hard drive to my new webspace (the original blog vanished cause my host evaporated). (new url is http://www.damonmuma.com/wp/)
    I tried exporting the database, opening in notepad, saving it in utf-8 and then importing it.. but i get an error:

    Error
    
    SQL query:
    
    --
    -- Dumping data for table <code>wp_categories</code>
    --
    INSERT INTO <code>wp_categories</code> ( <code>cat_ID</code> , <code>cat_name</code> , <code>category_nicename</code> , <code>category_description</code> , <code>category_parent</code> , <code>category_count</code> , <code>link_count</code> , <code>posts_private</code> , <code>links_private</code> )
    VALUES ( 1, 'general', 'general', '', 0, 0, 0, 0, 0 ) , ( 2, 'everythen', 'everythen', 'this is the big stuff', 1, 117, 0, 0, 0 ) , ( 3, 'music', 'music', 'that which beats and hums and sings and moves', 0, 0, 0, 0, 0 ) , ( 6, 'album review', 'album-review', '', 3, 12, 0, 0, 0 ) , ( 7, 'live review', 'live-review', '', 3, 13, 0, 0, 0 ) , ( 17, 'kreativ', 'kreativ', '', 0, 0, 0, 0, 0 ) , ( 10, 'writing', 'writing', '', 17, 25, 0, 0, 0 ) , ( 14, 'song of the day', 'song-of-the-day', '', 3, 231, 0, 0, 0 ) , ( 12, 'mix cd', 'mix-cd', '', 3, 13, 0, 0, 0 ) , ( 13, 'radio playlist', 'radio-playlist', '', 3, 65, 0, 0, 0 ) , ( 15, 'list', 'list', '', 3, 6, 0, 0, 0 ) , ( 16, 'art', 'art', '', 17, 10, 0, 0, 0 ) , ( 19, 'otherwheres', 'otherwheres', 'Little tidbits of goodness other places on the internet', 1, 2, 0, 0, 0 ) , ( 20, 'People', 'people', '', 0, 0, 19, 0, 0 ) , ( 21, 'Places', 'places', '', 0, 0, 6, 0, 0 ) , ( 22, 'Things', 'things', '', 0, 0, 7, 0, 0 ) ;
    
    MySQL said: Documentation
    #1062 - Duplicate entry '1' for key 1

    I don't know how it can be wrong since I didn't change any text at all in the file itself... any ideas??
    The only other thing that might be of note is that in my mysql control panel it says:

    Your PHP MySQL library version 5.0.16 differs from your MySQL server version 5.0.24a. This may cause unpredictable behavior.

    but I really don't know what that means..

Topic Closed

This topic has been closed to new replies.

About this Topic