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]