CiviCRM Community Forums (archive)

Via shell or FTP, did you edit the file civicrm.settings.php in <drupal_root>/sites/default ? It seems like this is what you need to do.

In the file, search for '$civicrm_root', and change it to reflect your new server. Also change the line under it to reflect the new server.

Then search for 'Content Management System (CMS) Datasource' and change the drupal db settings. Then search for 'CiviCRM Database Settings' and change that db to reflect your civicrm db (if these changes need to be made).

unfortunately i have only ftp access no shellCiviCRM can be tough to manage without shell access, but hopefully we can get this worked out. What webhost are you on?

1) which use should i use ? The new database user name or the unix/ftp user that i use to log on ?In civicrm.settings.php, for both the CMS datasource and CiviCRM database Settings you need to use your MYSQL username/password database.

For the CMS (drupal) datasource, you need to follow this protocol (as mentioned in the file):
define( 'CIVICRM_DSN'         , 'mysql://drupal:YOUR_PASSWORD@localhost/drupal?new_link=true' );
So if your mysql drupal database is called "drupaldb", your username is called "user" and your password is "12345", this is what you would put:

define( 'CIVICRM_DSN'         , 'mysql://user:12345@localhost/drupaldb?new_link=true' );

Then for the CiviCRM database Settings you will put the same thing IF your CiviCRM and Drupal databases are the SAME. If CIviCRM is in its own database, you will need to put that database info in the CiviCRM database settings line.

2) I do not know the absolute path of my unix user....

OK, then in your FTP client, browse to the folder that CiviCRM is in (sites/all/modules). Then look at the path you took to get there. I don't know what FTP client you use, so I can't give you the information exactly. It is probably going to be somewhat similar to the old path (depending on who your webhost is). So probably something like:
/home/$yourUser/public_html/sites/all/modules/civicrm/

So when looking at the path you took to get to the folder in your FTP client, you should see folders that mimic that. Does this make sense to you?

Or, if you can only get as far back as your webroot folder (for example, you only see as far back as the "public_html" or "htdocs" folder), you can try using this path(assuming your drupal install is directly in the public_html folder):
~/public_html/sites/all/modules/civicrm/

If none of these work, email your webhost and ask them what the server path is to your web directory.

Let me know how it goes.

Hi Guys,

Just got my Joomla & CiviCRM migrated from one host to another using the given instructions. Here is what I did:

• Migrate all files from one host to another.
• Change configuration.php to reflect new database/host/user settings
• Change civicrm.settings.php to reflect new database and new path information
• Go to the URL http://yourjoomlaroot/admin/index.php?q=civicrm/admin/setting/updateConfigBackend&reset=1

That's it done. I don't know what changes were done by the above URL but my installation did work.

Thanks Emily.