0
votes

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

1

1 Answers

1
votes

I would create a new empty DB on the host, import your dev db, then change the db name in the settings.php file to point to the new DB.