2013-03-18 12:05 pm EST
You should be ok to import your database the way you did as long as there were no charset-dependent data in the database and code. The database may have become corrupt after the collation change. Try running a repair on the database.
How to Check and Repair a MySQL Database
You may want to create the DB first, then set the collation, then import with a file which has the collation in the "create table" section. The data has to be imported into table with the correct collation.
Like this Question? Tweet