I imported database backup through terminal . in terminal it gave error
ERROR 1062 (23000) at line 1016624: Duplicate entry '0' for key 'PRIMARY'
then I used the below commands to resolve this -
TRUNCATE log_customer; TRUNCATE log_quote; TRUNCATE log_summary; TRUNCATE log_summary_type; TRUNCATE log_url; TRUNCATE log_url_info; TRUNCATE log_visitor; TRUNCATE log_visitor_info; TRUNCATE log_visitor_online; But still in admin panel I am getting error-
SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY', query was: INSERT INTO
url) VALUES (?, ?, ?, ?, ?).