Author Topic: SQL Import Prob On Moving Installation  (Read 2060 times)

sroberts556

  • Newbie
  • *
  • Posts: 2
    • View Profile
SQL Import Prob On Moving Installation
« on: 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

sroberts556

  • Newbie
  • *
  • Posts: 2
    • View Profile
Re: SQL Import Prob On Moving Installation
« Reply #1 on: 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