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]
