MySQL 5.0.10 db upgrading copied tables

Recently I copied directories – databases. Each table had files  with extension  frm, MYD, and MYI. Later,  I saw in phpmyadmin db name #mysql50#mydatab instead of expected name of database (and directory) mydatab. I was able to fix this problem by following command:
…\mysql>bin\mysqlcheck.exe -u root --check-upgrade --fix-db-names --fix-table-names #mysql50#mydatab
The reason is simply MySQL is now allowing all character sets.

This entry was posted in workday. Bookmark the permalink.

Leave a Reply