I have a problem, I nedd to restore a sql file, but when I try to do this with `mysql -u user -p --database test < file.sql` I get this error `ERROR 1062 (23000) at line 50: Duplicate entry '0' for key 'PRIMARY'` 
My first attribut is `AUTO_INCREMENT` and `NOT NULL` and `PRIMARY`
I have searched and the probem is in my sql file for my primary key I don't have value I have just simple quote. For example `INSERT INTO log VALUES ('','app1','name','hello')` as you can see my first value is only simple quote, how can I import this sql file without value beacause I have lot of lines in my file...

Definition of the table

```
CREATE TABLE `log` (
  `id_log` int(11) NOT NULL AUTO_INCREMENT,
  `application` varchar(20) NOT NULL,
  `module` text NOT NULL,
  `action` text NOT NULL,    
  PRIMARY KEY (`id_log`),
) ENGINE=InnoDB AUTO_INCREMENT=646 DEFAULT CHARSET=latin1;

```