MySQL will not start, “MySQL File ‘/usr/share/mysql/charsets/?.conf’ not found” in error log.

The most common cause for this error, is a failed downgrade of MySQL from 4.1 to 4.0.  Many
changes were made between MySQL 3.x, 4.0.x, and 4.1.

The actual cause of the error itself, is missing character sets from the 4.1.x series.  The best way
to recover, would be to use a backup of your database made before the upgrade to 4.1.  This way
you can be sure there are no changes that would adversly affect the db.

As a last restort, you will need to upgrade to 4.1 again.  Once your server is running MySQL 4.1,
you can dump the databases to a 4.0 format, and facilitate a downgrade to 4.0.

To do this, open an ssh shell, and dump the database with the following command:

mysqldump --create-options --compatible=mysql40 db_name > dump_file

Just substitue your database name for db_name, and your file for dump_file.  After this has been
completed for all databases, you can completely uninstall MySQL 4.1, and reinstall MySQL 4.0.  After
that it is just a matter of importing all of your databases to your newly installed MySQL 4.0 instance.

  • 1 Bu dökümanı faydalı bulan kullanıcılar:
Bu cevap yeterince yardımcı oldu mu?

İlgili diğer dökümanlar

Manage Database Roles

Solution Database roles are conceptually completely separate from operating system users....

Manage Tablespaces

Tablespaces in PostgreSQL allow database administrators to define locations in the file system...

ColdFusion DSN parameters are not updated

SYMPTOMS New CF DSN records are created.  Even the set of parameters is tried to be updated...

Finding what packages are installed on a Linux system

For distributions that use RPM format packages, use the command: $ rpm -qa You may want to pipe...

What platforms does Linux support?

Linux runs on almost every general-purpose computer made in the last 10 years. It runs on systems...