Facebook
TwitterI recently upgraded to mysql 4.1 using arts rpm's however one of my clients was using non standard characters in his table names. The database is now unreadable.
This is a known issue according to mysql.com I just didn't know about it until after I did the upgrade.
"Important note: MySQL 4.1 stores table names and column names in utf8. If you have table names or column names that use characters outside of the standard 7-bit US-ASCII range, you may have to do a mysqldump of your tables in MySQL 4.0 and restore them after upgrading to MySQL 4.1. The symptom for this problem is that you get a table not found error when trying to access your tables. In this case, you should be able to downgrade back to MySQL 4.0 and access your data."
I have a PSAdump file created before the upgrade to Mysql 4.1? Is there any easy way to restore a single database from a psadump file?
This is a known issue according to mysql.com I just didn't know about it until after I did the upgrade.
"Important note: MySQL 4.1 stores table names and column names in utf8. If you have table names or column names that use characters outside of the standard 7-bit US-ASCII range, you may have to do a mysqldump of your tables in MySQL 4.0 and restore them after upgrading to MySQL 4.1. The symptom for this problem is that you get a table not found error when trying to access your tables. In this case, you should be able to downgrade back to MySQL 4.0 and access your data."
I have a PSAdump file created before the upgrade to Mysql 4.1? Is there any easy way to restore a single database from a psadump file?
