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:

1. configure Hue to use the right database credentials, without starting it
2. 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.
3. start Hue and login