Good to know that the error is in the database. If all good, command
SHOW TABLES; should have returned MainTable. An empty-set return clearly shows that the tables and fields were not imported.
SELECT USER FROM MYSQL.USER; to confirm whether playout user
NANDAKUMAR was indeed created by dbimporter.
In my computer, it’s
MySQL ver 8.0.15 for Win64 on x86_64. All the applications including MySQL and connector c++ are 64 bit, but I am not sure about your version i.e 8.0.11. Please confirm by issuing command
Let me also check if I can reproduce here. Need a day or two. If the matter persists, I will modify dbimporter or resort to manual import. Thanks for reporting.
Edited- Redownload DbImporter.exe from shared drive. I have included logging feature to help diagnose faults. Log files available under
\ddplayout\tools\log. A typical log should look like this. You can share you log file:
Mysql server detected at C:\Program Files\MySQL\MySQL Server 8.0\bin\
Playout user created.
Privilages granted to Playout user .
Connected to Playout user.
Main database created.
Configuration database created.
Transmission database created.