MySQL Forums
Forum List  »  Newbie

Can't import db in phpmyadmin
Posted by: jasmin pav
Date: January 05, 2013 06:36AM

I'm trying to import existing mysql database into new db by using phpmyadmin. The following statement:

CREATE TABLE IF NOT EXISTS `conferences_topics` (
`conferenceId` INT( 11 ) NOT NULL ,
`topicId` INT( 11 ) NOT NULL ,
PRIMARY KEY ( `conferenceId` , `topicId` ) ,
KEY `conferences_topics_ibfk_2` ( `topicId` )
) ENGINE = INNODB DEFAULT CHARSET = latin1;

causes this error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `conferences_topics` (
`conferenceId` int(11) NOT N' at line 33.

I'm stuck. After importing, only 3 of overall 11 tables are successfully imported. What should I do?

Options: ReplyQuote


Subject
Written By
Posted
Can't import db in phpmyadmin
January 05, 2013 06:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.