recompile mysql with new character set on Debian

A

asmar

Verified User
Joined
Aug 29, 2005
Messages
101
Location
https://t.me/pump_upp
Hello,

May I ask how can I recompile MySQL to include a new character set (iso-8859-7)?
The installation has been done by DA and it seems a little bit confused as everything is compiled and not used apt.


server1:# ./myisamchk -r -q --set-character-set=iso-8859-7 /home/mysql/someuser_main/accessoires.MYI
./myisamchk: Character set 'iso-8859-7' is not a compiled character set and is not specified in the '/usr/local/mysql/share/mysql/charsets/Index.xml' file

Any help is much appretiate.

Thanks
 
I also tried with ./myisamchk: Character set 'greek' is not a compiled character set and is not specified in the '/usr/local/mysql/share/mysql/charsets/Index.xml' file

but nothing. greek is the character name and is already defined under /usr/local/mysql/share/mysql/charsets/Index.xml' file
 
Anyone with a suggestion? I already contact with DA support but they didn't provide much help.

I cannot even stop the mysql without killing the processes.

./bin/mysqld_safe stop
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/myhostname.com.pid
060104 01:48:36 mysqld ended

but mysql processes are still running even if it says mysqld ended.

DA install a binary version of MySQL. Is there a problem if I download the source and compile it myself? Is it going to update it or broke it during future upgrades?

Any help is much appretiated.

Thanks
 
If mysqld isn't stopping my guess is there are too many processes running and it times out.

We often have to run:

service mysqld stop

many times before it completely stops all instances of mysqld (that command may be specific to RHEL/CentOS).

Of course you need to shut it down from the DA control panel first. Even if it fails, it'll set DA not to automatically attempt to restart it every minute.

My recollection is that DA will install MySQL only if it doesn't find one already installed.

If that's correct (you might want to ask DA support), then any way you install it should be fine with DA. I don't know what package manager you're using, but in any event, if you don't use it, you'll be responsible for updates.

Jeff
 
Hello,

Thanks for the answer.
I managed to change the default character set in both, MySQL and PhpMyAdmin but still the query brings ????? insteed of the proper characters (iso-8859-7).

The import sql comes from a 3.23 version and already tested on my localhost and also on another Debian box and runs perfect.

Any ideas how can I fix/troubleshoot this?

Thanks
 
Is it perhaps an issue with a setting in a mysql config file?

Or a mysql config file not where it's expected?

Jeff
 
Hi Jeff,

After a couple of hours searching according to MySQL this type of migration is not possible direct from 3.23 to 4.1. It needs to go through 4 and a lot of custom things....

Anyway, I will sort it out later.

Thanks anyway
 
You must log in or register to reply here.
Back
Top