MySQL Bugs: #7659: not dumping entire DB??

Bug #7659	not dumping entire DB??
Submitted:	4 Jan 2005 13:05	Modified:	15 Jan 2005 9:56
Reporter:	Matt Arnold	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	4.18a	OS:	Linux (Linux Redhat 8)
Assigned to:		CPU Architecture:	Any

Description:
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.

How to repeat:
Backup the Database using mysqldump.

Hello,

Thank you for the report, but your report doesn't have enough info to reproduce this behavior.
What options of mysqldump do you use?
Does it report any errors during dump process?
What info is missing in the new dump file?

Hello,
      What options of mysqldump do you use?
./mysqldump --opt -Q -u (user) -p 3adlvb > /backup/forumbackup-01-03-2005.sql

      Does it report any errors during dump process?
Does not report any errors

      What info is missing in the new dump file?
I am not sure what is missing, but 75MB worth of data is. I know it corrupts my users avatar images and file attachments.

If you guys need to get in my database to look at this, let me know - I'll be most happy to allow you in to see if there is a bug or not.

Status Update?? I think it has to do with the way mysql 4.1.X handles tables with languages and character encoding.. in my old 3.23 version, it didnt have a "Collation" field, but now it does, and my stored graphic files (in a database) show to be swedish_ci    Should this be something binary??????????

Thank You for your non help.  Please close the case.  I fixed it myself.

We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.