Just completed setting up a development site (thanks to everyone's help) but now trying to find best practices/suggestions for synchronizing the live site and development site databases. Tried experimenting with the following work flows but have had problems due to some errors (stack overflow and SQL errors which I'm working thru) so haven't been able to fully test and to see what operations append versus replace/update.
1. In Administration panel use the Backup function to backup the Live database and then import into the Development database with the Restore function.
2. Using PHPMYADMIN delete the Development database and then copy Live database to create new Development database.
3. Using PHPMYADMIN copy data only from the Live database to the Development database.
Where I'm a bit confused is how to best deal with any schema/table structure changes may occur with a software update. Since I won't be moving data from the Development database to the Live database, how do you implement any schema/table structure in the Live database?
Any suggestions or guidance would be appreciated.