SQL Export Broken in

neik's profile image neik posted 1 month ago in General Permalink

I am trying to export the schema of my SQLite database. There are two errors:

  1. Triggers are not exported at all
  2. Views are exported as tables, in my case with "ENGINE=MyISAM" (This is SQLite!)

Is this a known problem?

ansgar's profile image ansgar posted 1 month ago Permalink

Yes, the SQL export of DDL queries is mostly compatible to MySQL and MariaDB only. SQLite exports should only be used for data, not structure.

Please login to leave a reply, or register at first.