Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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.