Thanks for all your help Gleb! I Appreciate all your hard work!
In a message dated 1/12/2005 5:31:19 AM Eastern Standard Time, Gleb Paharenko
<[EMAIL PROTECTED]> writes:
>Hello.
>
>[mysqldump]
>default_character_set = latin1
>
>
>
>[EMAIL PROTECTED] wrote:
>> amazing.. I failed to see that i
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
<[EMA
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 defa
Hi Dr.
The avatars still show fine on 4.18a -- but the problem occurs when I
actually do a dump and reimport the dump file. That's when something goes
array.. Kinda weird if you ask me.. I wish that vBulletin wouldn't actually
hard code the binary in a table, lol.. It's got me totally baffled
I have reinstalled the v3 RPM again to my system, and used one of my original
backups from that same version. In 3.23 there is no 'collation' field.. I
wonder if that is the problem?? I am going to change it to latein1_bin to see
what happens next..
Thanks! I'll let you know!
In a messag
Hi Tom,
Thanks for the reply! I show the following information for my DB,
and shows the same for both the 3.23 DB And the 4.18a DB
Field Type Collation
avatardata mediumtext latin1_swedish_ci
I pasted a data table from the bad avatar and the good avatar
t
Sorry, forgot the attachments. These are the same exact two avatars from the
same user, using my 3.23 backup, for the good avatar, then the 4.18 bad avatar
<><>--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
I am confused over the much smaller DataBase, but also of the corrupted avatars
and file attachments (I've attached examples).. I did some research using
mysqladmin, and the 'attachment' and the 'customavatar' tables are exactly the
same size in both databases, but the entire DB is about 10MB sm
Right, three is a true dump file, and I can restore the database, everything
'seems' to be there, I can browse the table all day long, and I can see the
binary files in the database, but the length of the tables are different.
mysql@lists.mysql.com
In a message dated 1/5/2005 3:50:39 AM Eastern
Thanks for the reply.
My original install was w/ an RPM from the Redhat Network, I uninstalled all
RPM's associated w/ MySQL, Apache, and PHP and downloaded the latest of
everything and compiled it. After I did an updatedb on my box, I searched for
"mysqldump" and "mysql" to confirm it was gone
Hi All,
I run a website, and am having a problem w/ corrupt databases..
I was runnig MySQL v3.23 previously, and my db dumps worked fine .. However, I
have since upgraded to v4.1.8a-log and I am having problems getting completed
(or non corrupt) backups.. The problem is pretty big..
My Original
11 matches
Mail list logo
