Local / Remote Development with C5

Permalink
Hi,
To say the least, I have had a horrible time with this.
I have successfully setup a local development environment and have been designing a few sites without issue. Connecting the developing sites with sql databases and such. However, migrating databases to and from my remote server (Bluehost) has plain and simply not worked.
If I can ask anyone here with experience just to guide me on the correct workflow please.
Do install a base site remotely and locally first. Do I install only on the remote side then copy over the site files and database to my local environment. Do I do it the other way around?
I'm really not sure anymore. Please if anyone can guide me in plain english on the basic workflow for local/remote development and C5 that would be much appreciated.
Cheers and thanks,
Bjorn

binomonkey
 
Cahueya replied on at Permalink Reply
I can contribute my workflow:
I build everything locally as far as possible, as it is faster and allows the use of more tools (xdebug).

I use valet+ for local development and set the properties of my local installation as close as possible to what will be at the remote target server. (php version, mysql version....)

Once everything is done locally, I clear the caches, zip up everything except the /concrete folder, push it to the live server with SCP.

I pull the correct concrete5 versions /concrete folder from concere5.org, set everything in /application/config/database.php ... and others to the correct values, upload the database (command line or however) and that's it.

AFAIK, if you watch for everything being the same versions, there shouldn't be much traps to step into.
binomonkey replied on at Permalink Reply
binomonkey
Thanks for the post.
I'm having issues with this right now. Preventing my from disabling maintenance mode:
/application/config/generated_overrides/concrete.php): failed to open stream: Permission denied

Any ideas?

Thanks,

Bjorn
Cahueya replied on at Permalink Reply
It means that the permissions on that file are not se correctly. Everything in the /application/config and the /application/file folder needs to be writable by the webserver to being able to make changes to the config files.

How do you access the files? SSH? FTP? some Control Panel?
binomonkey replied on at Permalink Reply
binomonkey
I have setup FTP through Panic Coda. It gives me access to view/edit local and remote. I use phpMyAdmin locally to export the databases then use phpMyAdmin on the Bluehost side to import that database and visa versa. Uploading everything beside the Concrete file has been taking a lot of time so I should probably compress the files for transfer first. Changing the permissions has fixed some issues so thanks a million for that info.
So, at the end of the day, is this pipeline/method a good one? I have only found success first creating the site from the remote/Bluehost side first then transferring to the local setup. Doing it the other way has produced errors I cant seem to resolve. The only unfortunate side to this is that I have to immediately set the site to maintenance mode otherwise a live unworked template is shown by the given domain.
Any workarounds or further advise on my methods are very welcome and appreciated.
Cheers,
Bjorn