Migrating from live site to localhost
Last updated by gnyma Comments (6)
1. install same copy of Elgg in your localhost
2. Export live site MySQL.
3. Run install on localhost
4. Copy live site folder to localhost (replace everything).
5. Drop localhost mySQL and import live MySQL.
6. Change engine/settings.php to localhost DB, Username, Password
7. Make sure .htaccess is original from Elgg install.
8. Rewrite paths in MySQL. Go to DB, select sites_entity, hit "browse" and edit the URLS.
9.
list of websites that are helpful:
http://docs.elgg.org/wiki/Duplicate_Installation
http://community.elgg.org/pg/forum/topic/17373/the-requested-action-register-was-not-defined-in-the-system/
http://docs.elgg.org/wiki/No_images
http://community.elgg.org/pg/forum/topic/677375/tidypics-photos-missing/
http://community.elgg.org/pg/forum/topic/762913/moving-elgg-to-a-different-url/
http://nickhardeman.com/308/export-import-large-database-using-mamp-with-terminal/
Change PHP time to
date_default_timezone_set('America/Los_Angeles');
http://community.elgg.org/mod/groups/topicposts.php?topic=216296&group_guid=19
VERY IMPORTANT:
Make sure to run these in phpmyadmin. on the SQL tab on main DB (pikacamplive)
UPDATE metastrings set string = '/Applications/MAMP/htdocs/data2/' WHERE id = (SELECT value_id from metadata where name_id = (SELECT * FROM (SELECT id FROM metastrings WHERE string = 'filestore::dir_root') as ms2) LIMIT 1)
UPDATE datalists SET value = "/Applications/MAMP/htdocs/data2/" WHERE name = "dataroot"
See here:
http://docs.elgg.org/wiki/Duplicate_Installation
CHECK ALL THE commas, semicolons, ETC!!
Updating string of links of old images embedded in HTML (updating file location) see this post:
http://community.elgg.org/pg/forum/topic/835814/server-migration-issues-with-blogforum-images-still-linking-to-original-server/
And it is done! :D