query( 'SHOW TABLES' );
foreach ( $tables as $table ) {
//echo $table[0] . ' ... ';
flush();
$sql = '-- TABLE: ' . $table[0] . PHP_EOL;
$create = $DB_con->query( 'SHOW CREATE TABLE `' . $table[0] . '`' )->fetch();
$sql .= $create['Create Table'] . ';' . PHP_EOL;
fwrite( $f, $sql );
$rows = $DB_con->query( 'SELECT * FROM `' . $table[0] . '`' );
$rows->setFetchMode( PDO::FETCH_ASSOC );
foreach ( $rows as $row ) {
$row = array_map( array( $DB_con, 'quote' ), $row );
$sql = 'INSERT INTO `' . $table[0] . '` (`' . implode( '`, `', array_keys( $row ) ) . '`) VALUES (' . implode( ', ', $row ) . ');' . PHP_EOL;
fwrite( $f, $sql );
}
$sql = PHP_EOL;
$result = fwrite( $f, $sql );
if ( $result !== FALSE ) {
echo '';
} else {
// echo 'ERROR!!' . PHP_EOL;
}
flush();
}
fclose( $f );
} catch (Exception $e) {
echo 'Damn it! ' . $e->getMessage() . PHP_EOL;
}
?>
download>