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?
Yes, and I tried dbtng-migrate as well, with help of there. It did not work, I ran into all kind of errors, and I don't want to create another mysql db locally and sync then.
All I want is a simple way to sync my local sqlite drupal install to a remote mysql one.
sql-sync
?The Drupal 7 Database API provides a standard, vendor-agnostic abstraction layer for accessing database servers. The API is designed to preserve the syntax and power of SQL as much as possible, but also...