How to deploy database from development to production


Can anyone give me some ref link how deploy mysql database from development phase to production phase automatically

There are really only three differences between a development setup and a production setup, and none of them have anything to do with the database. To convert to production, you need to:

  1. setup nginx
  2. setup supervisor
  3. make sure that developer_mode has value 0 in your site_config.json file.

You can find more info on the first two steps at the bench documentation: GitHub - frappe/bench: CLI to manage Multi-tenant deployments for Frappe apps

Do you want to migrate the DB to another host/bench or remain on the same bench?

In latter case go with Peters version. In the former case, that’s more tricky, because depending on your customizations you’ll need to export these as well (doctypes, fixtures).