Magento change database table prefix

Question

I accidentally have an Magento installation without an underscore for the table prefix. Is there an option to change this automatically? I don't like to alter 337 tables by hand :-)

I tried this solution but that doesn't seem to work.

Michael

Answer 1

You can create the sql to rename all tables with this select:

SELECT 'rename table '||table_name||' to '||'newprefix'||table_name||';'
FROM information_schema.tables