Problem going from Live to Dev
Permalink
I built a site on my local machine uploaded it to live server. I made some changes to the live site online adding a couple of addons and some extra content. When I downloaded the database back up to my dev site, I installed the add ons and then ran the database restore I got no error messages but the addons were removed from the dashboard and it kills the installed theme as the the front gives an error message on the theme as not existing on a path with //theme etc in it which does not exist. I have tried doing the move from Live to dev in various ways and always get the same result. I have never had this problem before.
Anyone have any ideas?
Phil,
Anyone have any ideas?
Phil,
pop open <site_root>/config/site.php on your dev site and check that BASE_URL is correct and does NOT have a trailing slash (sohttp://example.com, NOThttp://example.com/).
It sounds like you may have missed some files when you copied things down from Live to dev. Also make sure you clear your site cache and re-run the indexing job.
I know this won't help your current situation, but for reasons like this I always stick to a "one-way only" workflow and make all changes locally and copy them up to the live server.
If you're totally stuck, you should probably just back up your local copy (back up its database and then delete the database, then change the name of its directory on your local machine), then copy *everything* down from the live server and set that up locally.
I know this won't help your current situation, but for reasons like this I always stick to a "one-way only" workflow and make all changes locally and copy them up to the live server.
If you're totally stuck, you should probably just back up your local copy (back up its database and then delete the database, then change the name of its directory on your local machine), then copy *everything* down from the live server and set that up locally.
Hi,
i finally tracked the issue down to the fact the live database has 207 tables in it and when I back it up locally I end up with 165. The problem on the live site is that it has some tables duplicated in upper case and lower case but when i back it up using phpmyadmin i get endless errors. I am using wamp and experimenting with apache rewrite module and the 0,1,2 case settings in my.ini but no luck so far..sigh
i finally tracked the issue down to the fact the live database has 207 tables in it and when I back it up locally I end up with 165. The problem on the live site is that it has some tables duplicated in upper case and lower case but when i back it up using phpmyadmin i get endless errors. I am using wamp and experimenting with apache rewrite module and the 0,1,2 case settings in my.ini but no luck so far..sigh
Finally got it resolved, after reading your other posts on the case issue etc. I upgraded my wamp to latest version. Used mysql 5.1.36 and php 5.35 and apache 2.2.17
Then using phpmyadmin on live server I did a selective export of the 165 camel case tables and imported then using local phpmyadmin. Finally, it worked a treat.
I have no idea where the lower case tables came from on the live site as they are not there in the original upload. Strange.
Thanks for your input.
Phil
Then using phpmyadmin on live server I did a selective export of the 165 camel case tables and imported then using local phpmyadmin. Finally, it worked a treat.
I have no idea where the lower case tables came from on the live site as they are not there in the original upload. Strange.
Thanks for your input.
Phil
