Edit config.php for Server Migration

[jtrein]

Hello,

If my server A has a directory of /main/[ALL WEBSITE BAKER FILES] and I want to install [ALL WEBSITE BAKER FILES] on the root folder of server B, do I need to change my config.php file to reflect the right folder paths?

Below is a current copy of server A:

Code:

<?php

define('DB_TYPE', 'mysql');
define('DB_HOST', 'localhost');
define('DB_USERNAME', 'example');
define('DB_PASSWORD', 'example');
define('DB_NAME', 'example');
define('TABLE_PREFIX', '');

define('WB_PATH', dirname(__FILE__));
define('WB_URL', 'http://localhost/main');
define('ADMIN_PATH', WB_PATH.'/admin');
define('ADMIN_URL', 'http://localhost/main/admin');

require_once(WB_PATH.'/framework/initialize.php');

?>

Should I do the following for server B? :

Code:

<?php

define('DB_TYPE', 'mysql');
define('DB_HOST', 'localhost');
define('DB_USERNAME', 'example');
define('DB_PASSWORD', 'example');
define('DB_NAME', 'example');
define('TABLE_PREFIX', '');

define('WB_PATH', dirname(__FILE__));
define('WB_URL', 'http://somesite.com'); // removed 'main' & added domain name
define('ADMIN_PATH', WB_PATH.'/admin');
define('ADMIN_URL', 'http://somesite.com/admin');  // removed 'main' & added domain name

require_once(WB_PATH.'/framework/initialize.php');

?>

[YoJoe]

I hope you didn't forget to change also the domains for WB_URL and ADMIN_URL variables in config file ?
Otherwise when you enter yourdomain.tld, WB will load all data from your local lamp server

[jtrein]

@YoJoe

Right on, brother and thank you.  So, do I have the right idea here?  Is this what I need to be doing?

[YoJoe]

Hmm...is this your first migration attempt ?

You will need to provide also:
- database and username
- if dbase isn't hosted on the same machine ip/hostname of database machine (db_host)
- look if .htaccess file contains:
RewriteBase /main/   (leave only / )
any redirect or rewrite rules pointing to /main/ directory

If you forget to change some crucial info, turn on error reporting before you upload database to new location, and see if any errors in regard of paths to files appears.
Just a simple approach to debug any problems after migrating to new location

[jtrein]

@YoJoe

It sure is!  I'll make sure to get the database & username and insert those.

• I checked my .htaccess file and it doesn't contain anything to that effect - so I'm good there.
• I just turned on error reporting at level 'All'.

Also, I had better backup the config.php file.  Am I on the right track?


Kindest and thanks!,

jtrein

[YoJoe]

Just do it man ! 
If something bad happens, you still have files & dbase on your A location

[jtrein]

I like it.  I will do that.  I'll be back on here to give a thumbs up, or down! 

[jtrein]

@ YoJoe

Thanks, brother!  All is well!

I essentially followed your advice, and my original train of thought wasn't far off (which is odd).

Also, I trusted that I wasn't a special case and followed this Help article to a 'T': http://www.websitebaker2.org/topics/moving-from-server-a-to-b.php (thanks, Website Baker).


Kindest,

jtrein

[gordon_fern]

Another Gotcha to be aware of is that very often the content saved in the database contains absolute paths to graphics etc.  Perhaps the easiest way to fix it is going  to be to edit the mysql dump file before uploading to the new file server and replace such paths.

eg.  search and replace http://old_server/some_path/ to http://new_server/

If your mysql dump file isn't too huge for your text editors. Otherwise you'll have to update with SQL but that will be more fraught.

eg.

update <prefix>mod_wysiwyg
  set content =replace(content,'http://old_server/some_path/','http://new_server/'),
        text=replace(text,'http://old_server/some_path/','http://new_server/');

for starters and then depending on what other modules your site uses there may well be other tables as well.

[jtrein]

@ gordon_fern

Thanks!  That's awesome, I didn't know you could do that.

[Bramus]

jtrein dont forget to test all modules (like adding news and deleting items). It could be the chmodding if it isnt working. So make sure to test it, else chmod the folder AND all files

[jtrein]

Thank you!