When you move Hue database to another server or from sqlite to mysql and just want to start over, with a fresh empty DB, do as follows:
configure Hue to use the right database credentials.
Without starting it on the host that Hue is configured to run on, do:
/opt/cloudera/parcels/CDH/lib/hue/build/env/bin/hue syncdb --noinput
This will create all the tables and let Hue run.
- Start Hue and login