WB 2.08.x

		return $this->importSql($sSqlDump, $sTablePrefix, $bPreserve, $sEngine, $sCollation);

/**

 * Import an SQl-Dumpfile witch can include unlimited placeholders for values

 * @param mixed  $mSqlDump      can be string with filename or array with additional vars

 * @param string $sTablePrefix  can be used to override settings from WbDatabase object

 * @param string $sAction       'install', 'uninstall', 'upgrade', 'repair

 * @param string $sEngine       kind of table engine: MyIsam(default)

 * @param string $sCollation    utf8_unicode_ci(default)

 * @return bool  false on error

 */

	public function importSql(

        $mSqlDump,

        $sTablePrefix = '',               // can override settings from WbDatabase object

        $sAction      = 'install',        // skip 'DROP TABLE' statements

        $sEngine      = 'MyISAM',         // the default table engine

        $sCollation   = 'utf8_unicode_ci' // the default collation to use

    )

    {

		$retval = true;

		$this->error = '';

        // sanitize arguments

        if (! is_string($sAction)) {

            $sAction = $sAction ? 'repair' : 'install';

        }

        $aAllowedActions = array('install', 'uninstall', 'upgrade', 'repair');

        $sAction = strtolower(preg_replace('/^.*?('.implode('|', $aAllowedActions).')(\.php)?$/iU', '$1', $sAction));

        $sAction = (in_array($sAction, $aAllowedActions) ? $sAction : 'install');

        $sTablePrefix = trim($sTablePrefix);

        $aEngineTypes = array(

            'csv'        => 'CSV',

            'blackhole'  => 'BLACKHOLE',

            'memory'     => 'MEMORY',

            'myisam'     => 'MyISAM',

            'innodb'     => 'InnoDB',

            'archive'    => 'ARCHIVE',

            'mrg_myisam' => 'MRG_MYISAM'

        );

        if (isset($aEngineTypes[strtolower($sEngine)])) {

            $sEngine = $aEngineTypes[strtolower($sEngine)];

        } else {

            $sEngine = 'MyISAM';

        }

        // test if selected collation is available. Otherwise select 'utf8_unicode_ci'

        $sql = 'SELECT COUNT(*) FROM `COLLATIONS` '

             . 'WHERE `COLLATION_NAME`=\''.$sCollation.'\'';

        $sCollation = ($this->get_one($sql) ? $sCollation : 'utf8_unicode_ci');

        $aTmp = preg_split('/_/', $sCollation, null, PREG_SPLIT_NO_EMPTY);

        $sCharset = $aTmp[0];

        // define array of searches

        $aSearch  = array(

            '/\{TABLE_PREFIX\}/',

            '/\{TABLE_COLLATION\}/', // deprecated from 2.8.4

            '/\{FIELD_COLLATION\}/', // deprecated from 2.8.4

            '/\{TABLE_ENGINE\}/',

            '/\{TABLE_ENGINE=([a-zA-Z_0-9]*)\}/',

            '/\{CHARSET\}/',

            '/\{COLLATION\}/'

        );

        // define array of replacements

        $aReplace = array(

            $sTablePrefix,

            ' COLLATE {COLLATION}', // deprecated from 2.8.4

            ' COLLATE {COLLATION}', // deprecated from 2.8.4

            ' {ENGINE='.$sEngine.'}',

            ' ENGINE=$1 DEFAULT CHARSET={CHARSET} COLLATION={COLLATION}',

            $sCharset,

            $sCollation

        );

        if (is_array($mSqlDump)) {

            // try to get dumpfile name

            if (!isset($mSqlDump['sSqlDump'])) {

                $this->error = 'missing index \'sSqlDump\' in $mSqlDump';

                return false;

            } else {

            // get dumpfile name from array and then remove entry

                $sDumpFile = (string)$mSqlDump['sSqlDump'];

                unset($mSqlDump['sSqlDump']);

                // import all vars and it's values from array

                foreach ($mSqlDump as $sIndex => $sValue) {

                    // transform varname into placeholder name ('sPageTitle' => 'PAGE_TITLE')

                    $sIndex = strtoupper(preg_replace('/([a-z0-9])([A-Z])/', '\1_\2', ltrim($sIndex, 'a..z')));

                    // fill search/replace arrays

                    $aSearch[]  = '/\{'.$sIndex.'\}/';

                    $aReplace[] = $sValue ;

                }

            }

        } elseif (is_string($mSqlDump)) {

            $sDumpFile = (string)$mSqlDump;

        } else {

            $this->error = 'invalid argument $mSqlDump';

            return false;

        }

        if (!is_readable($sDumpFile)) {

            $this->Error = 'unable to open \''.$sDumpFile.'\'';

            return false;

        }

		$sql = '';

		$aSql = file($sDumpFile, FILE_SKIP_EMPTY_LINES);

        //	remove possible ByteOrderMark

		$aSql[0] = preg_replace('/^[\xAA-\xFF]{3}/', '', $aSql[0]);

		while (sizeof($aSql) > 0) {

			$sSqlLine = trim(array_shift($aSql));

			if (!preg_match('/^[-\/]+.*/', $sSqlLine)) {

				$sql = $sql.' '.$sSqlLine;

				if ((substr($sql,-1,1) == ';')) {

					$sql = trim(preg_replace($aSearch, $aReplace, $sql));

                    $sAvailSqlObjects = 'TABLE|VIEW|INDEX|PROCEDURE|FUNCTION|TRIGGER|EVENT';

                    switch ($sAction) {

                        case 'uninstall': // skip CREATE; execute DROP

                            if (preg_match('/^\s*CREATE ('.$sAvailSqlObjects.') /siU', $sql)) {

                                $sql = '';

                                continue; // read next statement

                            }

                            break;

                        case 'upgrade': // skip DROP; execute CREATE

                        case 'repair':  // skip DROP; execute CREATE

                            if (preg_match('/^\s*DROP ('.$sAvailSqlObjects.') /siU', $sql)) {

                                $sql = '';

                                continue; // read next statement

                            }

                            break;

                        default: // install:  execute DROP; execute CREATE

                            break;

                    }

                    if (!$this->doQuery($sql)) {

                        $retval = false;

                        $this->error = $this->getError();

                        unset($aSql);

                        break;

                    }

					$sql = '';

				}

			}

		}

		return $retval;

    } // end of function importSql()