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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] 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@lists.mysql.com >> In a message dated 1/5/2005 3:50:39 AM Eastern Standard Time, Gleb Paharenko >> <[EMAIL PROTECTED]> 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? >>> >>> >>>[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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? >>>>> >>>>> >>>>>[EMAIL PROTECTED] 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 > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] >/_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
