Re: Trouble w/ mysqldump

[Gleb Paharenko]

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