MySQL Forums
Forum List  »  Data Recovery

mysqldump .sql file will not import.
Posted by: B W
Date: April 17, 2013 10:42AM

mysqldump v 5.10
Dumped entire database into a single .sql file.
Completely removed mysql installation, and reinstalled fresh.
Import Data > dumpedfile.sql
Fails with syntax error every time at same line.

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `AddDate` BEFORE INSERT ON interviewlist FOR EACH ROW
SET NEW.InterviewListDateCreated = CURDATE(); */;;

Always fails when it tries to create the trigger/event/ or procedure. I have multiple triggers defined for most tables. So having to recreate them one by one would be a bit annoying. Did mysqldum put in the wrong syntax?
I am trying to import as root user through MySql Workbench > import data

Options: ReplyQuote

Written By
mysqldump .sql file will not import.
April 17, 2013 10:42AM

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.