Basically I was trying to convert an ISM table to MYISAM and I got an error message.
I have researched this problem for a few days on google. I am a newbie.
Do I need to load a module or do something to the server to get it to work?
Or is there an easier way to convert these old tables another way?
What happened is we moved all of our stuff to a new server. Some programs were using ISM instead of MYISAM.
Thanks.
Dave.



[root@www3 ~]# cd /usr/local/mysql/bin/
[root@www3 bin]# ./mysql_convert_table_format -type=myisam personalhistory
install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.10: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
at (eval 11) line 3
Compilation failed in require at (eval 11) line 3.
Perhaps a required shared library or dll isn't installed where expected
at ./mysql_convert_table_format line 37

On the command line I typed this:
uname -a
I got this
Linux www3 2.6.9-1.667smp #1 SMP Tue Nov 2 14:59:52 EST 2004 i686 i686 i386 GNU/Linux

Any takers?

Am I posting on the correct forum or do I need to try a different one?

Maybe linux distribution?

Hello Dave,

Wild guess here, if you have reinstalled or updated perl then the modules do not always get updated or rebuilt themselves. Some distros (gentoo anyway) provide a script to rebuild all perl modules after a perl upgrade.

In any event, I think your solution will be to rebuild your mysql perl module, as there is a symbol error which typically means a version mismatch.