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.