×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Error importing wp- DB into Joomla DB

Error importing wp- DB into Joomla DB 4 years 4 months ago #21257

  • Richard Hughes
  • Richard Hughes's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
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

Error importing wp- DB into Joomla DB 4 years 4 months ago #21259

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Online
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 154
  • Thank you received: 1081
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
The following user(s) said Thank You: Richard Hughes

Error importing wp- DB into Joomla DB 4 years 4 months ago #21269

  • Richard Hughes
  • Richard Hughes's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
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

Error importing wp- DB into Joomla DB 3 years 9 months ago #24032

  • juergen schiel
  • juergen schiel's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 0
related problem on import from wp db to joom db (3.2)
SQL-Befehl:
Warning : USING UNIQUE OPTION prefix pass instead of PASSWORD IS deprecated AND will be removed IN a future release.Please USE the FULL name instead.-- MySQL dump 10.13 Distrib 5.5.34, for Linux (x86_64)--
-- Server version 5.5.34-32.0
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Warning: Using unique option prefix pass instead of password is deprecated and w' at line 1

any idea what to do?
thanks in advance!

Error importing wp- DB into Joomla DB 3 years 9 months ago #24033

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Online
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 154
  • Thank you received: 1081
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.
The following user(s) said Thank You: juergen schiel

Error importing wp- DB into Joomla DB 3 years 9 months ago #24034

  • juergen schiel
  • juergen schiel's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 0
solved! :) help yourself, so good will help you.. or something like this ;) literally traduced from german "hilf dir selbst, dann hilft dir gott..."

Error importing wp- DB into Joomla DB 3 years 9 months ago #24036

  • juergen schiel
  • juergen schiel's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 0
the import was not starting at all, I deleted the first line of code "Warning : USING UNIQUE OPTION ..." then the import was possible
  • Page:
  • 1
Time to create page: 0.104 seconds