"dbcopy.php create -c <config>" won't create sqlite db

[volkszaehler]

"dbcopy.php create -c " won't create sqlite db

from volkszaehler.org.

[andig]

I've pushed an update andig/dbcopy@b850d5b. Run composer update to fetch these changes.

To perform a backup to sqlite follow there steps:

1. create local.json

   {
       "source": {
           "driver": "pdo_mysql",
           "host": "localhost",
           "user": "travis",
           "password": "",
           "dbname": "volkszaehler"
       },
       "target": {
           "driver": "pdo_sqlite",
           "host": "localhost",
           "user": "travis",
           "password": "",
           "dbname": "volkszaehler_backup",
           "path": "sqlite.db3"        // path is only used if driver = pdo_sqlite
       },
       "tables": [
           // TABLE DEFINITION
           // ----------------
           // table name
           //      tables will be processed in the order they are mentioned:
           //      - foreign keys on target will be dropped
           //      - if a table is not listed here, it will not be touched
           // transfer mode
           //      skip:       table will not be copied
           //      copy:       entire table will be truncated on target and copied from source
           //      pk:         selective copy by primary key. only data not present on target
           //                      will be copied from source.
           {
               "name": "entities",
               "mode": "copy"
           }, {
               "name": "properties",
               "mode": "copy"
           }, {
               "name": "entities_in_aggregator",
               "mode": "copy"
           }, {
               "name": "data",
               "mode": "pk"
           }, {
               "name": "aggregate",
               "mode": "skip"
           }
       ]
   }
   

2. create the sqlite schema

   php dbcopy.php create -c local.json
   

3. run the backup

   php dbcopy.php backup -c local.json
   

[andig]

Just did a clean install as my pc died. WFM.