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?
SET @del = (
SELECT CONCAT('DROP TABLE ', GROUP_CONCAT(TABLE_NAME), ';')
WHERE TABLE_SCHEMA = 'tgf_db'
AND TABLE_NAME LIKE 'tgf_%'
PREPARE stmt FROM @del;
DEALLOCATE PREPARE stmt;