I have a local testing setup where I can create drupal sites easily, all running with a sqlite DB.
I want to (firstly) publish the site to a remote server using a script that calls
drush sql-sync @blah.livesite.local @blah.livesite.com --create-db
The problem i ran into is that
drush sql-sync does not like to migrate a sqlite DB to a mysql DB as some structural deficites block the transfer. The error message is:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRAGMA foreign_keys=OFF' at line 1
I know I maybe can do a sql-dump first, edit some of the lines manually and import that filt into the remote db then. But I need this procedure quite often and have an automation script for the transfer - it should work fast with no manual editing involved.
Is it not possible to sql-sync from sqlite to mysql generally?
All I want is a simple way to sync my local sqlite drupal install to a remote mysql one.