New backup source: SQLite (D7) [#974632]

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.

Comment	File	Size	Author
#1	974632_show_table_status_01.patch	717 bytes	linulo

Comments

Comment #1

linulo commented 17 November 2010 at 22:19

Title:	"Add Profile" generates a PDO exception	» "Add Profile" generates a PDO exception with SQLite
Issue tags:		+pdo, +sqlite, +Database abstraction layer

Status	File	Size
new	974632_show_table_status_01.patch	717 bytes

Ok, I found a hack that works for me but I do not know enough about Drupal's database abstraction to do this cleanly (this would break things for MySQL users).

Comment #2

linulo commented 17 November 2010 at 22:19

Status:

Active

» Needs work

Comment #3

gsotto commented 4 February 2011 at 19:53

I get the same error :

PDOException: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "table" LINE 1: show table status ^: show table status; Array ( ) in backup_migrate_destination_db_mysql->query() (line 273 of C:\htdocs\drupal7pg\sites\all\modules\backup_migrate\includes\destinations.db.mysql.inc).

when I click on "Advanced Backup" . I have a drupal 7 install with a postgres db. Also, I do not have a source database available to backup.

Comment #4

gsotto commented 4 February 2011 at 20:13

FYI. I found out the reason why I do not have a source db.
Here is an excerpt from the documentation:
"...This module only supports MySQL. If you have experiences with PostgreSQL or any
other dbms and are willing to help test and modify the module to work with it,
please contact the developer at ronan (at) gortonstudios (dot) com.
"

Comment #5

ronan commented 5 May 2013 at 01:55

Title:	"Add Profile" generates a PDO exception with SQLite	» Add support for SQLite databases
Category:	bug	» feature

Comment #6

couturier commented 28 September 2017 at 16:26

Version:	7.x-2.x-dev	» 8.x-4.x-dev
Issue summary:	View changes

I'm tentatively moving this to the 8.x branch since there has been discussion about focusing all feature request work on the D8 version going forward.