function backup_migrate_source_db_mysql::_get_table_structure_sql in Backup and Migrate 6.3

Same name and namespace in other branches

1. 8.3 includes/sources.db.mysql.inc \backup_migrate_source_db_mysql::_get_table_structure_sql()
2. 7.3 includes/sources.db.mysql.inc \backup_migrate_source_db_mysql::_get_table_structure_sql()

Get the sql for the structure of the given table.

1 call to backup_migrate_source_db_mysql::_get_table_structure_sql()

backup_migrate_source_db_mysql::_backup_db_to_file in includes/sources.db.mysql.inc

Backup the databases to a file.

File

includes/sources.db.mysql.inc, line 268

Functions to handle the direct to database source.

Class

backup_migrate_source_db_mysql

A source type for backing up from database server.

Code

function _get_table_structure_sql($table) {
  $out = "";
  $result = db_query("SHOW CREATE TABLE `" . $table['Name'] . "`");
  if ($create = db_fetch_array($result)) {
    $out .= "DROP TABLE IF EXISTS `" . $table['Name'] . "`;\n";
    $out .= strtr($create['Create Table'], "\n", " ");
    if ($table['Auto_increment']) {
      $out .= " AUTO_INCREMENT=" . $table['Auto_increment'];
    }
    $out .= ";\n";
  }
  return $out;
}