Support » Plugin: Duplicator - WordPress Migration & Backup Plugin » If using GoDaddy & having issues, read this!

  • Resolved joshy0y0y0

    (@joshy0y0y0)


    If you have GoDaddy for hosting and are getting the following error when “Testing Connection”, than read on:
    —————————————-
    DATABASE CONNECTION FAILED!
    Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
    —————————————-

    You can not use “localhost” in the “Host” section.

    Steps to find your host on GoDaddy:

    • 1. Log in to GoDaddy Account
    • 2. Launch WebHosting
    • 3. Scroll down to “Databases” section and click on “MySQL”
    • 4. You will see a list of Databases on your site. If you don’t have one, click “Add” to make a new one.
    • 5. click on the Database you will be using
    • 6. a window pops up. You will see your “Hostname” towards the bottom. It should look something like this:

      abc1309365789209.db.16521398.hostedresource.com

    • 7. THAT is what you need to put into the “Host” section of the Deploy section of the plugin in order to get a “SUCCESSFUL” connection to your database.

    I HOPE THIS SAVES SOMEONE SOME GRAY HAIRS 🙂

    http://wordpress.org/extend/plugins/duplicator/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Cory Lamle

    (@corylamleorg)

    Hey Josh,

    Thanks for posting your solution!

    just used it and it worked thanks!

    Excellent piece of info, saved my bacon! Thank you for posting.

    Plugin Author Cory Lamle

    (@corylamleorg)

    Hey Chris,

    The developer version also has an improved interface for seeing your connection status… The very latest version (0.5.0) can be found by following these instructions:

    -> Browse to http://wordpress.org/extend/plugins/duplicator/developers/
    -> Look for the section “Other Versions”
    -> Click on “Development Version” and download the zip plugin file
    -> Uninstall your current version and install this one
    -> Note: This is a development line version so please test in your sandbox first to make sure you have no issues…

    Cheers~

    Almost but not quite – Godaddy’s new Cpanel control systems doesn’t seem to have the option to at step 5 to click on the database to see the host name. I’m trying to find somewhere else that lists the real host name. Their “www.previewmywebsitenow.com” doesn’t help, either!

    Plugin Author Cory Lamle

    (@corylamleorg)

    Hey Prenwan,

    I don’t have a GD account so I’m not sure, but I’m sure if you contacted the GD support they would be able to help…

    Cheers~

    hey prnewman,

    I ran into the same issue with the new GD cPanel. You can still get the hostname in the phpMyAdmin.
    I was able to get the ‘hostname’ by going into the database. you can run the following in the SQL:

    SHOW VARIABLES WHERE Variable_name = ‘hostname’

    Hope this helps you aswell!

    Plugin Author Cory Lamle

    (@corylamleorg)

    Thanks for the update @kstrassman.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘If using GoDaddy & having issues, read this!’ is closed to new replies.