Feng Forum

Support => Installation problems => : sroberts556 March 29, 2010, 06:23:06 PM

: SQL Import Prob On Moving Installation
: sroberts556 March 29, 2010, 06:23:06 PM

Hi
I'm getting this SQL error trying to import a copy of the db into a copy installation on a different server:
===========================
Error

SQL query:

--
-- Dumping data for table `og_administration_tools`
--
INSERT INTO `og_administration_tools` ( `id` , `name` , `controller` , `action` , `order` )
VALUES ( 1, 'test_mail_settings', 'administration', 'tool_test_email', 1 ) , ( 2, 'mass_mailer', 'administration', 'tool_mass_mailer', 2 ) ;

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1

======================================

Before this, I:

- copied the installation folders from old to new server via ftp
- updated the config file with new db host and root url etc
changed the cache, config, tmp, upload folders to chmod 777
- removed the cahce/autoloader.php

I get the same error whether using old or new config.php file...

newbie here - any help appreciated! :-)

Thanks

 - stewart

: Re: SQL Import Prob On Moving Installation
: sroberts556 March 29, 2010, 06:36:27 PM

Now resolved...I'd forgotten to delete all the tables inside the database first before importing in  :-[

Cheers,

 - Stewart