HowTo - DUMP and EXTRACT data from the database


Dump whole database to SQL file

ecc-core\thirdparty\sqlite\sqlite.exe ecc-system\database\eccdb .dump >eccdb.sql


Create database from SQL file

ecc-core\thirdparty\sqlite\sqlite.exe ecc-system\database\eccdb <eccdb.sql


Dump data from database into CSV file

Here is an example to dump all CRC32 of the parsed Atari 5200 games (a5200)

ecc-core\thirdparty\sqlite\sqlite.exe ecc-system\database\eccdb <sql.inst

a5200;02931055

`a5200;02C9ABC6`

`a5200;02CDFC70`

`a5200;02D9B87A`

`a5200;04807705`

`a5200;04B299A4`

`a5200;0624E6E7`

`a5200;063EC2C4`

`...`