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
<gleb.paharenko@stripped> writes:
>Hello.
>
>Have you tried to perform the dump using --default-character-set=latin1
>option and then restore data from it?
>
>Hurrican19@stripped 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
> / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
>/_/ /_/\_, /___/\___\_\___/ 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/mysql?unsub=1
>
>
