Using MySQL

Introduction

Here are some solutions that will hopefully save you time.

Here's the magic command:

mysqldump --add-drop-table -uroot -p "DB_name" | replace CHARSET=latin1 CHARSET=utf8 | iconv -f latin1 -t utf8 | mysql -uroot -p "DB_name"

Here's how to add a prefix to all tables in a database:

SELECT Concat('ALTER TABLE ', TABLE_NAME, ' RENAME TO my_prefix_', TABLE_NAME, ';') FROM information_schema.TABLES WHERE table_schema = 'my_database'

You just need to replace: - my_prefix: with your desired prefix - my_database: with the desired database