Thread tagged as: Question

Creating local installation from hosted site


As the subject states, I would like to create a locally hosted website from an existing Perch installation but I am getting the following error when I attempt to import a .sql file:

1062 - Duplicate entry '10105' for key 'PRIMARY' 

I simply copied the latest Perch to my local web server, along with the site files, created a database and used Perch setup to create tables so I don't really know what to do.

Thanks again

Garth Holmes

Garth Holmes 0 points

  • 4 years ago

Garth, normally you would do a sql dump on the site, then import this as a query into your local site. Also make sure the settings in your config match your local environment. Do not run perch setup as all this will already have been created when you import the sql dump.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Drop the tables in your local database and then import the SQL file again.