Support » Plugin: Prime Mover » Not able to export database

  • Resolved Luke Cavanagh

    (@lukefiretoss)


    Error generated during export of the database only is.
    Connection to mysql failed with message: SQLSTATE[HY000] [2002] Connection refused

    Total database size is 46.70MB.

Viewing 15 replies - 1 through 15 (of 15 total)
  • I am seeing that same error “Connection to mysql failed with message: SQLSTATE[HY000] [2002] Connection refused”. Can this plugin export a database with the database hostname as localhost?

    I am assuming no. I have used this plugin with a database that does not have localhost as the hostname and it worked. I used this plugin with a database that has localhost as the hostname and it did not work.

    Plugin Author Codexonics

    (@codexonics)

    @je2walsh / @lukefiretoss Thanks for reporting this issue. I’m now reproducing this specific problem. I will let you know if I need more information. I’ll add the fix as soon as the issue is reproduced on my end.

    Plugin Author Codexonics

    (@codexonics)

    @lukefiretoss / @je2walsh I manage to reproduce a specific issue on my end that will prevent it from exporting a database. I fixed this in version 1.0.1. Can you try the following:

    • Update to version Prime Mover 1.0.1
    • Clear your browser cache
    • Re-test the export
    • The expected is that the database should be exported

    In case, you still see the problem. The issue might be isolated in your own server. In this case, I need to see some debugging data or possibly access your site for further troubleshooting. Please refer this guide on submitting debug data to our support.

    If version 1.0.1 fixed the issue, that’s great. Please let me know if it works and we can mark this ticket as resolved. Thank you again.

    • This reply was modified 4 months, 2 weeks ago by Codexonics. Reason: Fixed typo
    Plugin Author Codexonics

    (@codexonics)

    @je2walsh I tested this with localhost as database hostname in my test server and it works. The plugin should be able to handle any database hostname even localhost. The issue found in my local debug is related to some port number thing in database connection credentials. It’s why there is a connection issue error. I made some adjustments in 1.0.1 to make this more flexible.

    Let me know if you still need more help. Thanks.

    @codexonics

    Same issue when using version 1.0.1 of the plugin.
    Connection to mysql failed with message: SQLSTATE[HY000] [2002] Connection refused

    Plugin Author Codexonics

    (@codexonics)

    Thanks @lukefiretoss , If you can provide debug details and access to your test site it would be great (follow the link above to add this info). I need more details on why this can be happening.

    Plugin Author Codexonics

    (@codexonics)

    Hi Luke,
    I read about this error and I found these possible solutions having this exact error:

    https://support.plesk.com/hc/en-us/articles/115002983385-Unable-to-connect-remotely-to-MySQL-on-a-Plesk-server-Connection-refused

    https://stackoverflow.com/questions/29395452/php-connection-failed-sqlstatehy000-2002-connection-refused

    If you are using using Maria DB:
    https://mariadb.com/kb/en/troubleshooting-connection-issues/

    Looks like this is a possible issue with MySQL configuration in your own server.

    If you can also provide details on your server configuration/ host or the migration log, it would be helpful. Thanks.

    Hello, Thanks for the information. I found out that our hosting provider has mysql only listening on localhost:3306, but not for external connections. This could be the reason it is not working.

    I submitted a log file to the contacts page.

    Plugin Author Codexonics

    (@codexonics)

    Thank you @je2walsh . I got your log file and is now analyzing it. Yes it’s true that if MySQL localhost server is not set up to listen for external connections, this error will be returned.

    I’ll hopefully create a patch later for you to test in your server. I’ll update.

    Plugin Author Codexonics

    (@codexonics)

    @lukefiretoss / @je2walsh I pushed version 1.0.2 today based on the fixes added on related to this issue. It adds more flexibility in MySQL/PDO connections especially in customized servers.

    I can confirm this is specific error is now gone using version 1.0.2 on a test server I’ve used. Please confirm that this is also fixed in your end, then we can mark this ticket as resolved.

    Make sure you are using version 1.0.2 Thanks!

    Thank you for working on the issue. It works perfectly now. Great job!!

    @codexonics

    The update fixed the issue.

    • This reply was modified 4 months, 2 weeks ago by Luke Cavanagh. Reason: clarify wording
    • This reply was modified 4 months, 2 weeks ago by Luke Cavanagh. Reason: clarify wording
    Moderator Steve Stern

    (@sterndata)

    Support Team Volunteer

    @codexonics

    >> If you can provide debug details and access<<

    I’m am 100% sure you mean well but please never ask for credentials on these forums, even for a test server.

    https://wordpress.org/support/guidelines/#the-bad-stuff

    Now for the why: The internet is a wonderful place full of very nice people and a few very bad ones. I’m sure everyone here is very nice however, by giving some ones keys to your house you are trusting they wont steal anything. Likewise the person who takes the keys is now responsible for the house FOREVER.

    If something was to go wrong, then you the author may well legally become liable for damages, which they would not normally have been as their software is provided without warranty.

    Please be aware that repeatedly asking for credentials will result in us asking you to repeatedly stop before escalating up to the plugins team.

    It’s never necessary to do that. Here’s why.

    There are many ways to get information you need and accessing the user’s site is not one of them. That’s going too far.

    You get the idea.

    Volunteer support is not easy. But these forums need to a safe place for all users, experienced or new. Accessing their system that way is a short cut that will get you into real trouble in these forums.

    Plugin Author Codexonics

    (@codexonics)

    Hi Steve, thanks for the warning. I’m sorry its a mistake to ask for user site access. But the user here didn’t provide access to the site though (only log details) and I never have the access the site.

    Rest assured that I will never repeat asking this information. I will review our procedures and add your input as well.

    Again, thanks for the note. This makes us more vigilant in doing things the right way in WordPress support.

Viewing 15 replies - 1 through 15 (of 15 total)
  • You must be logged in to reply to this topic.