[schapplm]

[...]
I would like to use .sql but in the config there is no export setting for that.
Do I first need to convert it .db to .sql?
Or how to open it in phpMyAdmin?

@alexxxx
ok I installed the extra database program and it reads the .db file.

@watchlist @schapplm
Maybe someone should edit the wiki, as phpMyAdmin can not be used as suggested here:
http://kodi.wiki/view/Add-on:WatchedList#MySQL_Database

To clarify again:

• .db is the file extension for SQLite databases, .sql is the default extension for mySQL-data, that is exported via phpmyadmin.
  
• whether the addon uses SQLite or mySQL depends on the addon settings described in the wiki
  
• if you want to use mySQL, you have to follow the instructions in the wiki, i.e. create the according database and make sure a server is running (only for advanced users)
  
• You can convert your database from SQLite to mySQL like described in the wiki, but mySQL should not be needed any more if you sync watchedlist between different devices via Dropbox
  

I get this message:
"0 movies and 0 episodes read from Kodi-DB"
there must be a fair number in there.

What am I overlooking?

@all
My .db does not have any data. Structure is there, but no rows. When I run the script manually it says it can not read the kodi-DB.

if your watchedlist.db only contains the structure, there was no data written into it by the addon, probably due to the error reading the Kodi-DB (which is a different error probably unrelated to the mySQL/SQlite thing and which we will have to look into). The empty structure is automatically created when starting the WatchedList addon with SQLite setting activated.
All watched movies and episodes in your db should be imported. Check if the JSON queries from #88 return something.