Hello, For updating the inventory of my Virtuuenart online store I'm using CSVImproved on my local pc where I'm runnning a duplicate of the live website (for improvements or further development purpose without taking the risk of shooting up the live site). It takes about 40mins to update the database. So there is no chance of doing that through CSVImproved on the web host server (server time out) and I don't have any skills how to run the whole action as a cron job. Anyway, I updated everything on my local pc and exported the entire database. Then I went to my cpanel on the server, to phpmyadmin and used the import function to import the .sql file. But I received the following error message... Error SQL query: -- -- Dumping data for table `jos_categories` -- INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `alias`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (1, 0, 'Terms and Conditions', '', 'privacy-notice', '', '1', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 4, 0, 0, ''), (4, 0, 'Welcome to Clean Star Home and Garden World', '', 'welcome-at-clean-star-home-and-garden-world', '', '1', 'left', ' Welcome Page ', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, ''), (12, 0, 'Frequently Asked Questions', '', 'frequently-asked-questions', '', '1', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 8, 0, 0, ''), (7, 0, 'About us', '', 'about-us', '', '1', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 7, 0, 0, ''), (11, 0, 'Contacts General', '', 'contacts-general', '', 'com_contact_details', 'left', ' Contact Info for Email contact ', 1, 0, '0000-00-00 00:0[...] MySQL said: #1062 - Duplicate entry '1' for key 'PRIMARY' What am I doing wrong or what can I do to avoid this error of getting an duplicate primary key? Thank you so much for your help Verdecove
your db is setup to manage the id column itself - ie fill in that record your dump is dumping out that value you are then trying to overwrite that managed value with the one from your dump