Support Questions

Find answers, ask questions, and share your expertise

hue db migration from sqlite to mysql

avatar
Contributor

Hello Everyone,

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 Enter password: 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,

Radhakrishnan.R

1 ACCEPTED SOLUTION

avatar
2 REPLIES 2

avatar

@Radhakrishnan Rk Refer to below article I had posted earlier to migrate Hue from SQLite to MySQL.

https://community.hortonworks.com/questions/399/how-to-move-hue-database-from-default-sqlite-datab.h...

avatar
Contributor

Thank you somuch for your rapid response. I try with the information provided by you and get back to you.