import content types from sql dump I recently had a db crash on the site I am currently working on.  I was running sqlite, and the crash locked the db.  No matter what I tried, I couldn't get drupal to access the database again (killed the process, exported into a new db, reinstalled drupal).  So I decided to just migrate it to MySQL.  I converted the sql dump from the old database to MySQL syntax without too many problems.  I can import my nodes just fine, I cannot however get my content types, panels and views to import.

I have tried dbtng migrate, it recognizes both databases, however it keeps giving me schema errors that I can't get around.  ie. destination database does not contain table variable_store -> import variable store from sql dump -> destination database contains table varaible_store dbtng migrate cannot overwrite table.  That is an issue in and of itself, but I digress.

The original site is completely dead, there is no way I can backup from the Drupal UI.

TLDR
cannot import content types, panels or views from sql dump.
Assuming your SQLite dump is complete, your best bet is probably to try and properly convert it to MySQL format and then restore to an empty database.

There's a good thread over at stackoverflow with information on SQLite to MySQL conversion: https://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql

I would paste a solution from there here, but as it's a sibling site, probably ok to just pop over and try some of those solutions.

Good luck