I've just exported a mysql database with drop-create script, to import to another mysql instance. I'm getting error on import:
ERROR 1347 (HY000) at line 4034: 'mydb.mytable' is not VIEW which is true, because its't not a view, but a table.
Looking at the script, i see, all tables and views have both drop table and drop view if exists.
I think it's quite retarded that mysql evaluates this as a blocking error, and not just a warning "hey you can't drop a view if it's a table, vice-versa", and continues with the next query, but that's how it works.
I don't see an option to change this behavior. How can i fix this, except of dropping database manually, and import just create script?