Hello, I want to move my site from one server to the other. So i imported the database ie in sql format from one server and, tried to export it in the other server by going to phpmyadmin. Now the problem is while it is inserting it finds some errors and stops exporting. Is there a way by which the exporting process can be continued with any intervention or any such errors occuring in the middle. I mean even if errors are there, it should not bother about it - it should just export the database. Below is the error message :- Error SQL query: -- -- Dumping data for table `phpbb_categories` -- INSERT INTO `phpbb_categories` ( `cat_id` , `cat_title` , `cat_order` ) VALUES ( 4, 'Information for Jason''s and James'' CUK students', 40 ) , ( 2, 'Introductions', 20 ) , ( 3, 'Learn English vocabulary', 30 ) ; MySQL said: Documentation #1062 - Duplicate entry '4' for key 1 Yes that was the error . Please help me friends. I always got answers from you guys. Please help this time also. Thanks in advance.
Are you on a cPanel server going to another cPanel server? Let me ask you this too, is the MySQL versions different between servers?