question Re: hue db migration from sqlite to mysql in Support Questions

hue db migration from sqlite to mysql

radhakrishnan_r — Wed, 25 May 2016 22:34:30 GMT

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

Re: hue db migration from sqlite to mysql

pardeep_kumar — Wed, 25 May 2016 22:42:29 GMT

@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.html

Re: hue db migration from sqlite to mysql

radhakrishnan_r — Wed, 25 May 2016 22:44:50 GMT

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