Re: Trouble w/ mysqldump

[Gleb Paharenko]

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