Jump to content

Error importing Data Base


Recommended Posts

Hi 

Need to install Presta Shop on new domain.

 

I get this error trying to import my Data base backup. into a new DB via PHP admin. Can anyone please tell me hov to solve it?

 

 

INSERT INTO `ps_address` VALUES

('1','21','0','0','1','0','0','manufacturer',NULL,'JOBS','STEVE','1 Infinite Loop',NULL,'95014','Cupertino',NULL,'(800) 275-2273',NULL,NULL,NULL,'2013-08-27 18:29:07','2013-08-27 18:29:07','1','0'),

('2','8','0','1','0','0','0','Mon adresse','My Company','DOE','John','16, Main street','2nd floor','75002','Paris ',NULL,'0102030405',NULL,NULL,NULL,'2013-08-27 18:29:07','2013-11-10 18:59:56','1','1'),

('3','21','32','0','0','1','0','supplier','Apple','supplier','supplier','767 Fifth Ave.',NULL,'10153','New York',NULL,'(212) 336-1440',NULL,NULL,NULL,'2013-08-27 18:29:07','2013-08-27 18:29:07','1','0'),

('4','21','13','0','0','2','0','supplier','Shure','supplier','supplier','5800 W. Touhy Ave',NULL,'60714','Niles',NULL,'800-434-3350',NULL,NULL,NULL,'2013-08-27 18:29:07','2013-08-27 18:29:07','1','0'),

('6','20','0','3','0','0','0','Min adresse','bfdfg','mig','mig','gggfg2',NULL,'3333','drhbergeg',NULL,'44444444',NULL,NULL,NULL,'2013-10-11 12:53:33','2013-10[...]

 

MySQL returnerede: Dokumentation

 

#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 'DROP TABLE IF EXISTS `ps_address_format`' at line 24 

 

 

Regards Carsten

Link to comment
Share on other sites

×
×
  • Create New...