Snapshot seems to work. Attached zip file of snapshots that were taken. The error that shows is here:

Notice: Undefined index: create table in _demo_dump_table_schema() (line 135 of /Applications/MAMP/htdocs/dgd7/sites/all/modules/demo/database_mysql_dump.inc).

There is a page full of this. Then there is one line that indicates the snapshot was created at the end of the list of repeats of this error.
Drupal Environment is:
MAMP
Drupal 7.14
No code mods. This is setup for a learning site more than anything.

CommentFileSizeAuthor
demo.zip245.14 KBFreedomRoadPublishing
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Shawn DeArmond’s picture

I just got this too, and it didn't let me restore from the resulting snapshot either.

Shawn DeArmond’s picture

Upon further inspection, the sql file was corrupted. My site was hosed. Major bummer. There was no "CREATE TABLE" commands anywhere in it. eek!

inteja’s picture

Same here. XAMPP, Clean Drupal 7.14 install + demo module. Tried snapshot. Got above error. Tried reset and it zapped entire database (except watchdog table).

Rory’s picture

Status: Active » Fixed

I was getting this error too. See: http://drupal.org/node/1171866

It's been fixed in the 7.x-1.x-dev version. It would be nice to get this committed to stable. These are the lines which fix the problem, I've gathered so far:

demo/database_mysql_dump.inc ~ line 120

  // Capitalization of keys depends on PDO database connection options.
  // Convert them to lowercase.
  foreach ($data as $key => $value) {
    unset($data[$key]);
    $data[strtolower($key)] = $value;
  }
  foreach ($status as $key => $value) {
    unset($status[$key]);
    $status[strtolower($key)] = $value;
  }

demo/database_mysql_dump.inc ~ line 335

  // Capitalization of keys depends on PDO database connection options.
  $comment = (isset($status['Comment']) ? $status['Comment'] : $status['comment']);

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.