Error in importing backup files in godaddy please help

Discussion in 'Databases' started by smartwork121, Dec 22, 2009.

  1. #1
    When I am importing backup files following error is appearing in screen
    --------------------------------------------------------------------------

    Error

    SQL query:

    -- -- Database: `ste0934307481526` -- -- -------------------------------------------------------- -- -- Table structure for table `wp_comments` -- CREATE TABLE `wp_comments` ( `comment_ID` bigint(20) unsigned NOT NULL auto_increment, `comment_post_ID` bigint(20) unsigned NOT NULL default '0', `comment_author` tinytext NOT NULL, `comment_author_email` varchar(100) NOT NULL default '', `comment_author_url` varchar(200) NOT NULL default '', `comment_author_IP` varchar(100) NOT NULL default '', `comment_date` datetime NOT NULL default '0000-00-00 00:00:00', `comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00', `comment_content` text NOT NULL, `comment_karma` int(11) NOT NULL default '0', `comment_approved` varchar(20) NOT NULL default '1', `comment_agent` varchar(255) NOT NULL default '', `comment_type` varchar(20) NOT NULL default '', `comment_parent` bigint(20) unsigned NOT NULL default '0', `user_id` bigint(20) unsigned NOT NULL default '[...]

    MySQL said: Documentation
    #1050 - Table 'wp_comments' already exists

    -------------------------------------------------------------------------

    Please solve this problem
     
    smartwork121, Dec 22, 2009 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    This is because table wp_comments already exists in the database. Drop this table from the database where you are importing the data if you don't need this.
     
    mwasif, Dec 27, 2009 IP