Hello.
Have you tried to perform the dump using --default-character-set=latin1 option and then restore data from it? [EMAIL PROTECTED] wrote: > Hello, thanks for helping! Here is the output of the requested statements on > live database: > > > SHOW CREATE TABLE avatardata; > | customavatar | CREATE TABLE `customavatar` ( > `userid` int(10) unsigned NOT NULL default '0', > `avatardata` mediumtext NOT NULL, > `dateline` int(10) unsigned NOT NULL default '0', > `filename` varchar(100) NOT NULL default '', > PRIMARY KEY (`userid`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | > > > SHOW CREATE DATABASE 'put the name of the avatar database'; > ERROR 1064 (42000): You have an error in your SQL syntax; check the manual > that corresponds to your MySQL server version for the right syntax to use > near ''customavatar'' at line 1 > > SHOW VARIABLES LIKE '%char%'; > +--------------------------+----------------------------------------+ > | Variable_name | Value | > +--------------------------+----------------------------------------+ > | character_set_client | latin1 | > | character_set_connection | latin1 | > | character_set_database | latin1 | > | character_set_results | latin1 | > | character_set_server | latin1 | > | character_set_system | utf8 | > | character_sets_dir | /usr/local/mysql/share/mysql/charsets/ | > +--------------------------+----------------------------------------+ > > Here is my my.cnf file [Removed commented out sections]: > [client] > #password = your_password > port = 3306 > socket = /var/lib/mysql/mysql.sock > > # Here follows entries for some specific programs > > # The MySQL server > [mysqld] > port = 3306 > socket = /var/lib/mysql/mysql.sock > skip-locking > key_buffer = 16M > max_allowed_packet = 1M > table_cache = 64 > sort_buffer_size = 512K > net_buffer_length = 8K > read_buffer_size = 256K > read_rnd_buffer_size = 512K > myisam_sort_buffer_size = 8M > datadir=/var/lib/mysql > old-passwords > > log-bin > > server-id = 1 > > [mysqldump] > quick > max_allowed_packet = 16M > > [mysql] > no-auto-rehash > # Remove the next comment character if you are not familiar with SQL > #safe-updates > > [isamchk] > key_buffer = 20M > sort_buffer_size = 20M > read_buffer = 2M > write_buffer = 2M > > [myisamchk] > key_buffer = 20M > sort_buffer_size = 20M > read_buffer = 2M > write_buffer = 2M > > [mysqlhotcopy] > interactive-timeout > > [mysql.server] > user=mysql > basedir=/var/lib > > [safe_mysqld] > err-log=/var/log/mysqld.log > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]