Setup MySQL as Datasource for OFBiz

Standard

Derby is the default database of ofbiz. Now we migrate our database to MySQL from derby.
1. Before you start migrating check your installed MySQL version & download the supported version of mysql-connector.jar
2. Place the mysql-connector.jar to <ofbiz-dir>/framework/entity/lib/jdbc
MysqlConnector
3. Create 3 database [Ex. ofbiz, ofbizolap, ofbiztenant]
4. Open entityengine.xml file from <ofbiz-dir>/framework/entity/config/
5. Edit as follows,

Advertisements