Answered by the Webhosting Experts
Tags +
...

Managed Services
at Hivelocity

Bare Metal Shouldn’t be a Grind
Let Hivelocity take the busy work out of your daily server maintenance with our Managed Services plans. Choose from 1 of 6 different managed service offerings. Standard and Premium plans available.

Questions about something specific? Chat now with one of our expert account managers and learn which plan is right for you and your customers!

With Managed Server Technicians on-site 24/7/365, your server is always in good hands.

Tags +
...
Tags
...
...

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.

Share

Facebook
Twitter
LinkedIn
Email
WhatsApp

Need More Personalized Help?

If you have any further issues, questions, or would like some assistance checking on this or anything else, please reach out to us from your my.hivelocity.net account and provide your server credentials within the encrypted field for the best possible security and support.

If you are unable to reach your my.hivelocity.net account or if you are on the go, please reach out from your valid my.hivelocity.net account email to us here at: support@hivelocity.net. We are also available to you through our phone and live chat system 24/7/365.