Re: Trouble w/ mysqldump

[Hurrican19]

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 smaller on the 4.1 dump (according to mysqladmin) But the
difference in my acutal dump files is 70MB..

I was told by vBulletin that they think it has somthing to do with the way mysql 4.1.X
handles tables with languages and character encoding?

Thanks!

In a message dated 1/5/2005 12:16:19 PM Eastern Standard Time, Gleb Paharenko
<gleb.paharenko@stripped> writes:

>Hello.
>
>> Right, three is a true dump file, and I can restore the database, everything 
>>'seems' to be there,
>
>So, as I understand, the only thing that were confusing you, was the small
>dump file? If you see binary files after restoring from the dump file -
>they are in the dump file. I think that clues are in the bulk inserts which
>are tighter than ordinary.
>
>
>you Hurrican19@stripped wrote:
>> 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@stripped
>> In a message dated 1/5/2005 3:50:39 AM Eastern Standard Time, Gleb Paharenko
> <gleb.paharenko@stripped> writes:
>> 
>>>Hello.
>>>
>>>> The actual tables are there 
>>>
>>>I assume that 'there' is a dump file. One more question, can you
>>>select the Avatars data using SQL queries? For example:
>>>  SELECT 'Avatar_field' from 'avatar_table' limit 1;
>>>Does your application work after upgrade?
>>>
>>>
>>>Hurrican19@stripped wrote:
>>>> 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 -- nothing was found.   
>>>> 
>>>> ./mysqldump Ver 10.9 Distrib 4.1.8a, for redhat-linux-gnu (i686)
>>>> 
>>>> The actual tables are there, but the images (or any attachments) are
> really messed up.  Looks like something from the 60's, lol.
>>>> 
>>>> In a message dated 1/4/2005 9:36:01 AM Eastern Standard Time, Gleb
> Paharenko <gleb.paharenko@stripped> writes:
>>>> 
>>>>>Hello.
>>>>>
>>>>>In what way have you upgraded? How do you dump the data? Is everything
> fine,
>>>>>execept the database dump? As of MySQL 4.1, --opt command line option
> is on by 
>>>>>default, so it can produce a smaller output. The definions of tables
>>>>>which stores Avatars are also absent in dumps? May be you use
> mysqldump
>>>>>from old 3.23 version?
>>>>>
>>>>>
>>>>>Hurrican19@stripped wrote:
>>>>>> 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 Backup of the DB using 3.23 was 208MB --- When I
> upgraded to 4.18 the backup is only 138MB ... My users Avatar's, all attachments, etc are
> totally whacked out. Does anyone have any insight on what is causing this, and how to fix
> it? Any help is appreciated.. I need a new good backup desperately 
>>>>>> 
>>>>>
>>>>>
>>>>>
>>>
>>>
>
>-- 
>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
>
>