I cannot find any official way to back up the CMS data or partially sync up the data from local to production environment.
Thanks
October CMS is primarily a file-based system, so publishing the files will update most of the application, and we call this developer data. The customer data is found in the database and the storage directory. It should not be necessary to continuously deploy it since it would involve a destructive process of completely replacing all customer data on the production site.
Regarding the backup manager, we have plans to introduce a simple backup and restore feature later down the track. In the meantime, some plugins can offer a similar feature set, such as the Backup Manager plugin found here: Backup Manager plugin - October CMS
MySQL also has built-in tools for automating a database’s backup and restoration process. Use this command to back up your MySQL database. For example, if the username is root and the database is called database_name. You will then be prompted to enter the password.
mysqldump -u root -p database_name > october_backup_20210317.sql
To restore the backup, you can use this command.
mysql -u root -p database_name < october_backup_20210317.sql
I hope this helps.