I am new to phpMyAdmin, and cPanel, I have developed a site in my local box, and now I need to transfer the site into cpanel in the server where the site will be there in test mode.
I have installed drupal in cpanel successfully, and now I want to take my drupal database from my local box to the database in Cpanel .
so the export file I generated, includes all the insert statements for some of the tables that already have those data in cpanel, so obviously I get the duplicate primary key error.
how can I import drupal database data (my local box -development) into the new drupal database( set up when installed drupal in cpanel) without dealing with duplicate data which is for the default tables/data
I am using phpMyAdmin in both my local (dev) box and server side I appreciate any one 's help