Hi,

i have a database i have just imported into 5.0.24. Looking at it the tables are either myisam or innodb and character set latin_swedish_ci.

I want to set them all to myisam and utf8_bin.

I am using phpmyadmin 2.9.02.

Can i automate this as i will have to do this a number of times before i import the final database when i go live with a migrated forum.

cheers,


btw : consider me a total novice.

Depends on what OS you are on, you can probably write some bash script to do a mysqldump and re-import them. From my lack of experience of changing charater sets here is the safest way to do so.

First, backup, backup and more backup of your current data.

Second, do a mysqldump of all data structure; go in and change the character set and engine of each table. Also be careful if there any foreign or innodb support feature that is not supported in MyISAM.

Thrid, mysqldump only the data and have it import to you new database with the new structure.

Hope this helps