Import database connection error

The solution is to copy the Joomla database on the WordPress database:
– export the Joomla database to a SQL file (with phpMyAdmin for example)
– import this SQL file on the same database as WordPress
– run the migration by using the WordPress database credentials (host, user, password, database) instead of the Joomla ones in the plugin settings. You can find the WordPress credentials in the wp-config.php file.

Hi. I have the same problem. I did not understand your answer (run the migration by using the WordPress database …..). Can you be more specific? How specifically should I make a Joomla database migration into a WordPress database? Thanks a lot for your time, Kerfred.

Here is a detailed procedure if Joomla and WordPress are not on the same host.

1. With phpMyAdmin, export the Joomla database into a SQL file.

2. Still with phpMyAdmin but on the WordPress host, import this SQL file. So you will have both the Joomla and the WordPress databases on the same host.

3. Then on the plugin screen, you must fill in the database settings: Hostname, Port, Database, Username, Password, Joomla Table Prefix. You can find them in the WordPress file wp-config.php, except the table prefix that stays the Joomla one.

Hi. Thanks a lot for the explanation. Now it really works. Because I use Zoo in Joomla, I had to buy FG Joomla To WordPress Premium + Zoo module. I have migrated the content, but unfortunately the content in WordPress is not. Could you give me an advice please? I also attach a log. Do I still have to buy wp-types?

=== START import 2018-03-08 12:48:39 ===
Connected with success to the Joomla database
Joomla data found:
1 category
3 articles
1 user
31 Zoo categories
196 Zoo items
151 Zoo comments

Importing categories…
0 categories imported
Importing posts…
0 posts imported
0 medias imported
0 Zoo categories imported
Importing Zoo items…
1 Zoo item imported
0 Zoo tags imported
2 Zoo media imported
Importing menus…
18 menu items imported
0 tags imported
0 Zoo comments imported
Don’t forget to modify internal links.
IMPORT COMPLETED
=== END import 2018-03-08 12:48:45 ===

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

I am having the same problem except both of my sites (Joomla) and (WordPress) are hosted by the same server. I have verified the the password and username in the configuration.php file. I have turned on the remote SQL. I have even allowed_url_fopen directive in php.ini I am not sure what else I can do. Any suggestions?

@catherinemabongor
This FAQ will help you: https://www.fredericgilles.net/support/kb/faq.php?id=1

Which exact error message do you get in the log?

Confused. I imported the Joomla SQL into the WordPress SQL but now I have one database with two prefixes. I’m taking the suggestion to run import with the WordPress information, but which prefix should I use?

@gledger Please don’t overload an existing thread with another topic.
To answer to your question, you must use the Joomla prefix.

Hello, good morning, I have the following problem. I need to transfer the information from a database in Joomla to WordPress, but it is in different servers. I get the following error:

=== START test_database 2018-10-11 14:55:13 ===
[ERROR] Could not connect to the Joomla database. Please check your parameters and make sure that the WordPress server can access the Joomla database.

SQLSTATE [HY000] [2003] Can not connect to MySQL server on ’10 .130.1.9 ‘(111)

Should both databases be on the same server? Thank you!

This FAQ describes the solution: https://www.fredericgilles.net/support/kb/faq.php?id=1

It works! Thank u!!

I have the same problem but with a Drupal site, should I do the same process? When I import the drupal database to the one in wordpress I have to delete something, or I simply add it next to the tables that are from wordpress ?

Yes, same process.
You don’t have to delete anything.