function _backup_migrate_get_tables in Backup and Migrate 5

Same name and namespace in other branches

1. 5.2 includes/db.inc \_backup_migrate_get_tables()
2. 6 backup_migrate.module \_backup_migrate_get_tables()

Get a list of tables in the db. Works with MySQL, Postgres not tested.

2 calls to _backup_migrate_get_tables()

BackupMigrateUnitTest::testGetTables in tests/BackupMigrateUnitTest.test

_backup_migrate_get_dump_sql in ./backup_migrate.module

Get the sql dump file. Returns a list of sql commands, one command per line. That makes it easier to import without loading the whole file into memory. The files are a little harder to read, but human-readability is not a priority

File

./backup_migrate.module, line 691

Create (manually or scheduled) and restore backups of your Drupal MySQL database with an option to exclude table data (f.e. cache_*)

Code

function _backup_migrate_get_tables() {
  $out = "";

  // get auto_increment values and names of all tables
  $tables = db_query("show table status");
  while ($table = db_fetch_array($tables)) {
    $out[$table['Name']] = $table;
  }
  return $out;
}