I am using sqlite(default db) as a db engine for hue in my production environment. I would prefer mysql db for storing all hue events. How can I dump the entire database from sqlite and restore it in my mysql db.
I tried it in my staging environment and I am getting the following error.
[root@ip-172-31-56-223 ~]# mysql -u root -p hue1 < hue1.sql
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRAGMA foreign_keys=OFF' at line 1
I followed several blogs to fix this problem. But it failed.
Can anyone help me to fix this issue.
Thanks and regards,