Help with importing : )

also interested, thank you !

1. The “Empty WordPress content” action has two options:
– either you delete all the WordPress data including posts, pages, categories, medias, menus
– either you delete only the data that has already been imported with the plugin
To answer to your question, you don’t have to delete existing data before running the import

2. You can’t select which nodes to import. It will import all the “page” and “article” nodes.

3. You can’t select which categories to import. It will import all the categories and all the pages and articles in these categories.

In the settings i entered correct database name, username and password. i don’t know the port number and i don’t know drupal table prefix. I keep getting connection failed when i test the connection with following message. Could you please help me?

[ERROR] Couldn’t connect to the Drupal database. Please check your parameters. And be sure the WordPress server can access the Drupal database.
SQLSTATE[28000] [1045] Access denied for user ‘fpndrupal’@’localhost’ (using password: YES)

• This reply was modified 8 years, 6 months ago by ixinho.

Are port number and table prefix mandatory in order to connect?

The port is 3306 by default. This is the default MySQL port. If you don’t know, it should be 3306.
For the prefix, you can find it in phpMyAdmin. This is the prefix for every Drupal tables. It can be empty.

Is WordPress located on the same server as Drupal?
If this is not the case, you have to copy the Drupal tables to the WordPress database and use the WordPress credentials instead of the Drupal ones in the plugin settings.

Huh, drupal site is completely other hosting and server. There is no way to copy posts from drupal site which is on other server? If no, which tables i would have to copy?

I tried with 3306 and now i get SQLSTATE[HY000] [2003] Can’t connect to MySQL server on ‘fpn.bg.ac.rs’

so i guess it’s the problem that the drupal is on other site, but you should mention that in faq, that it cannot import from other location

Thank you.

You just have to do an export/import with phpMyAdmin to copy the Drupal tables to the WordPress database. Not all the tables are required but a lot. The easiest and safest way is to copy all the Drupal tables.
Once the Drupal tables are on the WordPress database, you can use the plugin to convert your data to WordPress.

I’ll create a FAQ with this issue.

I was able to import from localhost with the port field empty. If there’s no table prefix in your database, leave it empty. Table prefixes are generally used to separate data between multiple sites using the same CMS.

@ixinho Sounds like there’s a permissions issue with your SQL server. Since using WordPress is like using another computer (with Apache as its engine), a SQL server might not recognize calls from the plug-in as your computer. Hence exporting from the remote server and importing to a local one, aka your computer, might be a solution.

It would be great if the plug-in could import a .sql file instead of having to import from a database server.

• This reply was modified 8 years, 6 months ago by motorbaby.