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

[justinotherguy]

Here's what I did:

• git clone https://github.com/andig/dbcopy.git
• dbcopy.json angepasst:
  "source": {
  // source database connection
  "driver": "pdo_mysql",
  "host": "localhost",
  "user": „vz",
  "password": „<sssh!>",
  "dbname": "volkszaehler"
  },
  "target": {
  // target database connection
  "driver": "pdo_sqlite",
  "path": "sqlite.db3", // path is only used if driver = pdo_sqlite
  "host": "localhost",
  "user": "travis",
  "password": ""
  // "dbname": „backup“
  […] remainder: default
• installed composer ("curl -s http://getcomposer.org/installer | php“, "php composer.phar install")
• installed sqlite driver: apt-get install sqlite libsqlite0 php5-sqlite
• generate target db:
  php /opt/dbcopy/dbcopy.php create -c /opt/dbcopy/dbcopy.json
  Creating target schema
  renaming assets for target platform: sqlite
  table: data
  table: entities
  table: entities_in_aggregator
  table: properties
  -> doesn't seem to create a sqlite db
  s. https://demo.volkszaehler.org/pipermail/volkszaehler-users/2014-November/004887.html

[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.