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]
