Running migration of joomla db to wp db

  • Resolved sumanshr

    (@sumanshr)


    6 years, 2 months ago

    I get the message: “[fg-joomla-to-wordpress] Couldn’t connect to the Joomla database. Please check your parameters. And be sure the WordPress server can access the Joomla database. SQLSTATE[28000] [1045] Access denied for user ‘xxx’@’localhost’ (using password: YES)”

    First verify your login and password to the Joomla database.
    If Joomla and WordPress are not installed on the same host:
    If you use CPanel on the Joomla server, a solution is to allow a remote MySQL connection.
    go into the Cpanel of the Joomla server
    go down to Database section and click “Remote MySQL”
    There you can add an access host (WordPress host). Enter the access host as the SOME-WEBSITE-DOMAIN-OR-IP-ADDRESS and click add host.

    I have tried several time the above methods but didn’t worked out..

    Another 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 WordPress database credentials (host, user, password, database) instead of the Joomla ones in the plugin settings.

    Now I want to go with the another option that is with Joomla db by exporting it. Now I have Joomla db with me in sql format but don’t know how am I able to migrate it in WP db? I didn’t see any such features in your plugin by migrating joomla db to wp db.

    Please help me with this migration. I have messed up many days with this migration procedures.

    Thanks and best regards,
    Suman Shrestha

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Kerfred

    (@kerfred)

    6 years, 2 months ago

    You can import the DB by phpMyadmin (from the phpMyAdmin Import tab).
    Or import it in command line like this:
    mysql -u my_username -p my_database_name < my_file.sql

    Thread Starter sumanshr

    (@sumanshr)

    6 years, 2 months ago

    @kerfred
    Thanks for the quick reply!!

    I have already imported the db from the phpMyAdmin. I just want to know how can I able to link that db migration with your plugin so that all the joomla contents can be transferred to wp data tables.

    Regards..

    Plugin Author Kerfred

    (@kerfred)

    6 years, 2 months ago

    If you have imported the Joomla DB on the same server as WordPress, you must enter the hostname, user and password of WordPress in the database settings. You can find them in the wp-config.php file.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Running migration of joomla db to wp db’ is closed to new replies.