Using MySQL

Introduction link

Here are some solutions that will hopefully save you time.

Converting a Latin1 Database to UTF8 link

Here’s the magic command:

1

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

Adding a Prefix to All Tables in a Database link

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

1

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

References link

1. https://steindom.com/articles/adding-prefix-all-tables-mysql-database