Hi guys, i have file exported from mysql "db.sql" and i would like to improt it to Qtsql "data.db".
i tried to create the db with:
Qt Code:
  1. import sys, os
  2. from PyQt4 import QtCore, QtSql
  3. filename = "data.db"
  4. create = not QtCore.QFile.exists(filename)
  5. db = QtSql.QSqlDatabase.addDatabase("QSQLITE")
  6. db.setDatabaseName(filename)
  7. db.open()
  8. query = QtSql.QSqlQuery()
  9. query.exec_("opencoffe.db < opencoffe.sql")
To copy to clipboard, switch view to plain text mode 

only create the file "data.db" but don't export anything.