- 🇺🇸United States bogdog400
I was hoping to backup the SQLite database but maybe it would be easier to just copy the entire file.
I did a vanilla install with Drupal 7.x.dev (Nov 17 2010) under Windows on a SQLite database, installed backup_migrate-7.x-2.x-dev (Nov 17 2010) and clicked on "Add Profile". This is what I got:
PDOException: SQLSTATE[HY000]: General error: 1 near "show": syntax error: show table status; Array ( ) in backup_migrate_destination_db_mysql->query() (line 273 of C:\htdocs\d7test\sites\all\modules\backup_migrate\includes\destinations.db.mysql.inc).
I think this is caused by the function _get_tables() in destinations.db.mysql.inc which issues the query show table status which isn't understood by SQLite.
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
I was hoping to backup the SQLite database but maybe it would be easier to just copy the entire file.