can you give some example of portal-ext.properties entiries for DB configuration?

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost:3306/portaldb?useUnicode=true&characterEncoding=UTF8&useFastDateParsing=false
jdbc.default.username=portaluser
jdbc.default.password=portaluser123


when Server started we can see the Dialect name

 

Afer copying portal-ext.properties and restart the server first time you see following statements

01:35:29,405 ERROR [JDBCExceptionReporter:101] Table 'lportaldb.lock_' doesn't e
xist
01:35:30,099 WARN  [ReleaseLocalServiceImpl:143] Table 'lportaldb.release_' does
n't exist
01:35:30,101 INFO  [ReleaseLocalServiceImpl:84] Create tables and populate with
default data

 

So if you want to recreated all tables you can just delete data from  lock and release tables in the database. when we start server it will create all required tables once again