SitePush on GoDaddy shared hosting

I should remove the reference to GoDaddy hosting as those particular issues were resolved. As far as I am aware, SitePush does now work fine on GoDaddy shared hosting – if you have any problems though, let me know.

I am trying to get this working on GoDaddy Deluxe hosting and it seems to be getting stuck on the database.

[3] RUN: /usr/bin/mysqldump --opt --verbose -u ****** -p'*****' ****** --tables wp_rg_form wp_rg_form_meta wp_rg_form_view wp_rg_lead wp_rg_lead_detail wp_rg_lead_detail_long wp_rg_lead_meta wp_rg_lead_notes | /usr/bin/mysql -D ****** -u ****** -p'*****'
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Note that I’ve hidden the db connection info.

The two sites are sitting in their own subdirectories, /live and /staging, each installed using GoDaddy’s installer script so they have autogenerated connection details and running WP 3.6

Does the DB in your setup run on the same server as the web server?

If not and if you haven’t already done so, can you try defining the database host(s) in you dbs conf file. For example:-

[live]
name = live_database
host = dbhost.example.com
user = db_user
pw = live_db_password

If that doesn’t work, could you post the contents of your wp-config files for each site (with usernames/passwords removed of course), that may give me some clues.

That was it, I was assuming the DB host would be the same so I hadn’t defined them but they incorporated the username/siteid string into them which meant they were different. After defining those properly it seems to have pushed just fine.

Thanks for the help and for the great plugin! This will save a ton of work.

Great – glad you got it working.