TOPIC: Error importing wp- DB into Joomla DB

Hi.
i thought i must have done something wrong but all the dics i have read seem simple enough:
1. export wp db
2. import it into Joomla 2.5 db

i am getting an error when i import. it take a minute or so and then i get this :

Error
SQL query:

-- -- Dumping data for table `jos_acymailing_config` -- INSERT INTO `jos_acymailing_config` (`namekey`, `value`) VALUES ('level', 'Starter'), ('version', '4.0.0'), ('from_name', 'admin'), ('from_email', 'This email address is being protected from spambots. You need JavaScript enabled to view it.'), ('reply_name', 'admin'), ('reply_email', 'This email address is being protected from spambots. You need JavaScript enabled to view it.'), ('bounce_email', ''), ('add_names', '1'), ('mailer_method', 'mail'), ('encoding_format', '8bit'), ('charset', 'UTF-8'), ('word_wrapping', '150'), ('hostname', ''), ('embed_images', '0'), ('embed_files', '1'), ('editor', '0'), ('multiple_part', '1'), ('sendmail_path', '/usr/sbin/sendmail'), ('smtp_host', 'localhost'), ('smtp_port', ''), ('smtp_secured', ''), ('smtp_auth', '0'), ('smtp_username', ''), ('smtp_password', ''), ('smtp_keepalive', '1'), ('queue_nbmail', '40'), ('queue_nbmail_auto', '70'), ('queue_type', 'auto'), ('queue_delay', '3600'), ('queue_try', '3'), ('queue_pause', '120'), ('allow_visitor', '1'), ('require_confirmation', '0'), ('priority_newsletter', '3'), ('allowedfiles', 'zip,doc[...]

MySQL said:

#1062 - Duplicate entry 'level' for key 'PRIMARY'

Any ideas what i am doing wrong please ?
I do have a new Joomla template with a "quick start" type site up and running, i want to be able to import the articles from the wordpress site and then sort them out but not even getting to that part yet

thanks in hope of saving weeks of work here !!
Rich

Well, it seems that you've dumped a joomla site and you are trying to import it into another joomla site

jos_acymailing_config is not a wordpress table -> it is a joomla table.

Export only the wordpress tables and import them in your joomla site (normally wordpress tables start with the prefix wp_ or in some cases they are without prefix)

Regards,
Daniel

Ok thanks - i promise i wasnt though !!
I have tried again this morning and it did the same thing, then i tried unticking the box:

"Allow the interruption of an import in case the script detects it is close to the PHP timeout limit. (This might be a good way to import large files, however it can break transactions.)"

and it worked !!

so i am currently importing my wp_ tables into new site and have everything crossed !!
thanks

related problem on import from wp db to joom db (3.2)
any idea what to do?
thanks in advance!

Hey Juergen,
Does the import stops executing or do you just get a warning during the import? You can always try to export the wp database with different settings.

solved! help yourself, so good will help you.. or something like this literally traduced from german "hilf dir selbst, dann hilft dir gott..."

the import was not starting at all, I deleted the first line of code "Warning : USING UNIQUE OPTION ..." then the import was possible