amazing.. I failed to see that in the last msg - but that seemed to do the trick - The images appear correctly now.. is there anyway in my.cnf to tell it to always use the command?? Thanks much for the help!
In a message dated 1/11/2005 4:48:27 AM Eastern Standard Time, Gleb Paharenko <[EMAIL PROTECTED]> writes: >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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
