Drupal Gardens export to Godaddy

Posted by olender on June 2, 2012 at 1:52pm

I recently exported my website from DP onto my desktop. I am attempting to upload the site to Godaddy. The database and files were uploaded correctly (at least I believe this to be the case). DP gives you new credentials when you export and I used those to set up the database.

Everything I read tells me to go to my settings.php file to make the changes in the file at the line where it starts $db_url....etc... It says to replace it with something else. The problem is that DP does not appear to have that line where it starts $db_url. It has the following and I made the changes according to the MySQL database information. This is sample user and passwords but this is what it looks like.

* Database configuration format:
* @code
* $databases['default']['default'] = array(
* 'driver' => 'mysql',
* 'database' => 'bnusygp4y4',
* 'username' => 'bnusygp4y4',
* 'password' => 'yjJFUPv4iQ',
* 'host' => 'xyzwwwwwwwww@122fff ',
* 'prefix' => '',
* );

I made the changes with the proper information but I am getting the following error when I go to he domain. PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in lock_may_be_available() (line 167 of /home/content/68/9341868/html/includes/lock.inc).

Any suggestions as to what I am doing wrong?

Comments

First, you've pasted some

Posted by dman on June 2, 2012 at 3:12pm

First, you've pasted some code that implies you've been editing the commented instructions rather than the actual config array which is a little bit further down in the file.
If the lines you are changing start with "*" then they are not the lines you should be changing.

Second, even after obscuring things, you put a @ symbol in the 'host' field.
That cannot, just cannot be right. 'host' will be either 'localhost', an ip address, or a hostname like mysql.server.example.com. A 'host' does not include an @ sign.

The full database URL may include an @ in some documentation, or as shorthand. In such a case, it's the username and optionally the password that comes before the @. The hostname, (optionally the port) and the database name come after it.

Mentions of $db_url are for Drupal version 6. This has been replaced in Drupal 7 with a $databases array which does the same job, and you seem to have almost found. You just need to scroll down a little more, and fit the right fields to the right places.

_{.dan. is the New Zealand Drupal Developer working on Government Web Standards}

Drupal Gardens to GoDaddy

Posted by olender on June 2, 2012 at 3:43pm

Thank you! I could not find that documentation on the change anywhere on DG or GoDaddy. I used the local host provided by the PHP Admin area and not the IP on the hosting dashboard for what I just did.

I mad the fix and now I get the following message when I go to www.reitzworldwide.com.previewdns.com
It's a preview page from GoDaddy. I currently have my domain forward to another site until I get this resolved.

Warning: Unterminated comment starting line 348 in /home/content/68/9341868/html/sites/all/modules/date/date.theme on line 348

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /home/content/68/9341868/html/sites/all/modules/form_builder/form_builder.install on line 54

First guess would be that

Posted by dman on June 2, 2012 at 10:08pm

First guess would be that this is a corrupted file copy that didn't upload right. The syntax error implies you don't have all of the named file.
try a re-upload first

_{.dan. is the New Zealand Drupal Developer working on Government Web Standards}

Install

Posted by olender on June 5, 2012 at 4:28pm

Would it be possible to hire you to do the install up to Webenabled? I have an account there. That is really were I want the site. I have tried but just keep getting the bare bones so I would like to have a professional help.

Thanks for the offer. My

Posted by dman on June 5, 2012 at 8:11pm

Thanks for the offer.
My professional rates are a bit beyond standard install and configure sort of jobs. In short, you'd be better to pay the Acquia network directly for managed hosting on their system (not a bad idea) than pay me to set up a budget provider.

But I'm sure you could find any number of sensibly-priced helpers at http://drupal.org/paid-services that will be able to help you out directly. Try a post there.

_{.dan. is the New Zealand Drupal Developer working on Government Web Standards}

Thank you and will follow up with them

Posted by olender on June 6, 2012 at 12:34am

Thanks for your help and I will reach out to one of them.