X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=util%2Fconvert_innodb.sql;h=7f3d99a4da43f6932b493c0029e1db03fa58c3b8;hb=a61ffa92000234f76d9bcbd9f75340ac2862d81b;hp=bcc87222af75438d3c2ac400fa03c95a8026312d;hpb=f9b0beff8ddd1133271b7ded444e1fe010562eed;p=friendica.git diff --git a/util/convert_innodb.sql b/util/convert_innodb.sql index bcc87222af..7f3d99a4da 100644 --- a/util/convert_innodb.sql +++ b/util/convert_innodb.sql @@ -1,4 +1,6 @@ - +# script to convert tables from MyISAM to InnoDB +# change the %PLACEHOLDER% to the actual name of your Friendica DB + SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' engine=InnoDB;') FROM information_schema.tables -WHERE engine = 'MyISAM' AND `table_schema` = 'friendica'; +WHERE engine = 'MyISAM' AND `table_schema` = '%PLACEHOLDER%';