MySQL Error 1050 While Importing Database

  • Resolved AskFred

    (@askfred)


    15 years, 1 month ago

    I am migrating my wordpress blog from one server to another. From my old server I exported the SQL database, but when I try to import it into the database on the new server, I get the following error message

    Error

    SQL query:

    — — Database: sci0907907063968 — — ——————————————————– — — Table structure for table wp_comments — CREATE TABLE wp_comments ( comment_ID bigint(20) unsigned NOT NULL auto_increment, comment_post_ID int(11) 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) NOT NULL default ‘0’, user_id bigint(20) NOT NULL default ‘0’,[…]

    MySQL said: Documentation
    #1050 – Table ‘wp_comments’ already exists

    Kindly help me in sorting this issue out.

    Thanks in advance!

Viewing 2 replies - 1 through 2 (of 2 total)

  • the problem looks like you have a create table command without a drop table if exists command in the .sql saved file.
    can you still export your database and check mark both options? then do the import again?

    Either that or check the database on the new server and drop the tables that you want to import.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘MySQL Error 1050 While Importing Database’ is closed to new replies.