diff options
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/private/repair.php | 1 | ||||
| -rw-r--r-- | lib/repair/innodb.php | 51 |
2 files changed, 52 insertions, 0 deletions
diff --git a/lib/private/repair.php b/lib/private/repair.php index 14a917be32c..89886dd9316 100644 --- a/lib/private/repair.php +++ b/lib/private/repair.php @@ -81,6 +81,7 @@ class Repair extends BasicEmitter { */ public static function getBeforeUpgradeRepairSteps() { return array( + new \OC\Repair\InnoDB() ); } diff --git a/lib/repair/innodb.php b/lib/repair/innodb.php new file mode 100644 index 00000000000..4d58bf64a9e --- /dev/null +++ b/lib/repair/innodb.php @@ -0,0 +1,51 @@ +<?php +/** + * Copyright (c) 2014 Thomas Müller <deepdiver@owncloud.com> + * This file is licensed under the Affero General Public License version 3 or + * later. + * See the COPYING-README file. + */ + +namespace OC\Repair; + +use Doctrine\DBAL\Platforms\MySqlPlatform; +use OC\Hooks\BasicEmitter; + +class InnoDB extends BasicEmitter implements \OC\RepairStep { + + public function getName() { + return 'Repair MySQL database engine'; + } + + /** + * Fix mime types + */ + public function run() { + $connection = \OC_DB::getConnection(); + if (!$connection->getDatabasePlatform() instanceof MySqlPlatform) { + $this->emit('\OC\Repair', 'info', array('Not a mysql database -> nothing to no')); + return; + } + + $tables = $this->getAllMyIsamTables($connection); + foreach ($tables as $table) { + $connection->exec("ALTER TABLE $table ENGINE=InnoDB;"); + $this->emit('\OC\Repair', 'info', array("Fixed $table")); + } + } + + /** + * @param \Doctrine\DBAL\Connection $connection + * @return string[] + */ + private function getAllMyIsamTables($connection) { + $dbName = \OC::$server->getConfig()->getSystemValue("dbname"); + $result = $connection->fetchArray( + "SELECT table_name FROM information_schema.tables WHERE table_schema = ? AND engine = 'MyISAM'", + array($dbName) + ); + + return $result; + } +} + |