I found out that if you have tables that have foreign keys you must restore manually the parent table first, then the child table. If you try to do a complete restore the restore will stop and your tables will have no records. I would have expected more from navicat. At least this is my experience with v10. very very scary.....