CommandError: Unable to serialize database: no such table: search_facet

[#1]

Trying to convert MySQl Lite DB to MySQL by following the steps from: (poorly written)

http://www.cloudera.com/documentation/cdh/5-1-x/CDH5-Installation-Guide/cdh5ig_hue_database.html

$ sudo -u hue <HUE_HOME>/build/env/bin/hue dumpdata > <some-temporary-file>.json

The steps says : 

But it should be like this below and when I run the command I am getting this error.

/opt/cloudera/parcels/CDH-5.5.2-1.cdh5.5.2.p0.4/lib/hue/build/env/bin/hue dumpdata >hue_dumpdata.2017-10-30.json CommandError: Unable to serialize database: no such table: search_facet

After searching in Google, I went to this link where it says this problem got solved but again the steps are not written in a way anyone can understand

http://community.cloudera.com/t5/Web-UI-Hue-Beeswax/Hue-dumpdata-returns-quot-CommandError-Unable-to...

So someone please help me.

Thanks

[#2]

If you're managing your Hue service via Cloudera Manager, you can do the dump and load via the UI.

Stop the Hue service with the SQLite configuration, then click 'Dump Database' under the Hue service page's Actions button. Next, reconfigure the stopped Hue service to use your new MySQL DB, and before starting it go back to the Actions button and click 'Load Database'.