Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Reply #52 –
Please let me answer myself: success again - apparently; the database is not the smallest as the site has been established 12 years ago. I searched the web, and the following approach worked for me. In this case the databse is named tgf_db and the table prefix is tgf_
Maybe an optional cleanup step in openimporter?
use [b]tgf_db[/b];
SET GROUP_CONCAT_MAX_LEN=10000;
SET @del = (
SELECT CONCAT('DROP TABLE ', GROUP_CONCAT(TABLE_NAME), ';')
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'tgf_db'
AND TABLE_NAME LIKE 'tgf_%'
);
PREPARE stmt FROM @del;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;